Oracle 23c New Features for DBA'sThe issue is there’s a query which executes quickly through 12c client in 12c database where as it is taking longer time when connecting as with 11g Clients to 12c database.
The table has a […]
|
||||
|
Most of us know the result cache is introduced in 11g initially with pl/sql result cache and then the query result cache to store the results of query in a separate memory structures in shared pool. As I do not want to get into how it works, what it do, may be the best start […] Hello While doing some setup, I have came across a diskgroup (OCRDG) missing in CRS registry, however the diskgroup is present in the ASM instance and showing mounted. [root@oinfo12c-rac1 ~]# crsctl stat res -t ——————————————————————————– Name Target State Server State details ——————————————————————————– Local Resources ——————————————————————————– ora.DATA.dg ONLINE ONLINE oinfo12c-rac1 STABLE ONLINE ONLINE oinfo12c-rac2 STABLE ora.LISTENER.lsnr […] In the Previous Posts , to troubleshoot the problematic queries/long running session issues, we have sorted out two approaches, Here we discuss the Method 1 Method 1. Session Wait Event Approach:- In this approach we will try to identify from the problematic session what its waiting for , why its waiting, what can be […] In this part of the series, we will be looking into , how to identify the Problematic Sessions or Queries. Before beginning, one should distinguish the question here. You may face questions like, and the answer for both is to identify either loaded sessions for a database. 1. Database is/was slow.
This post is about installing Exadata storage server while I am preparing for exadata certification. This is just for educational and learning purposes to understand exadata components and commands to get some hands on experience before exam. Pre-requisities Install virtualbox Install Oracle Linux 5 Update 9 (just install this ersion only not even oracle linux […] In the previous series we have seen how to troubleshoot IO, CPU and Database TimeSpent/Consumed, Today’s Post I will be sharing with you the most common issues or to tackle memory related questions. As we all know Oracle does manage things (blocks/modifications) in memory and track them in memory and sort them in memory and […] Hello, Previous parts in the series we have covered, DB Load Profile, DB Load Profile2, Time Model, IO Performance. In Today’s series, we will see, I cover both current/AWR in one after another below, the scripts are attached and linked for each screenshot for your later use. (It took longer than usual, as such I […] Want to know new features in 12c, 18c, 19c, 20c ??? Follow this More than 100+ features listed here : http://db.geeksinsight.com/category/12c-database/ More than 50+ features listed here: http://db.geeksinsight.com/category/18c-database/ More than 40 features listed here: http://db.geeksinsight.com/category/19c-database/ Upcoming 20c features : http://db.geeksinsight.com/category/20c-database/ Hello, After Looking at identifying Database Load in previous posts (Post 1,Post 2) and seeing […] Hello, This is the third post in this series, If you haven’t read the previous articles please go through here, First Post, http://db.geeksinsight.com/2015/10/08/performance-troubleshooting-series-understanding-your-oracle-database-load/ Second Post, http://db.geeksinsight.com/2015/10/09/performance-troubleshooting-series-understanding-your-database-load-from-metrics-part-2/ Starting 10g, Apart from Metrics tables, there is another area of troubleshooting can be done by using Time Model series. Its very useful to understand where is the over […] |
||||
Follow Me!!!