|
||||
|
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 […] Hello, This is the second part of the series of Performance Troubleshooting, Whilst the first one is from AWR/Statspack tables. And what if , if you don’t have both in your environment, That made me to write up this second post. Those who does not know about the metrics tables a short notes here, After […] Hello, Very long back, Karlarao has written a wonderful script which delivers a exhaustive report for database performance. The script extracts the data from AWR repository tables. Where in I have took liberty to tweak the same script for those who does not have AWR licensing and having statspack only. Here is the script […] Ever, interested in looking for statistics staleness for each table including how much percent they stale are. The following query helps you to get you the details. This query filter out the staleness for those tables which having more than or equal to 10%, you can adjust accordingly. However, you will need to […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!