Subscribe to Posts by Email

Subscriber Count

    696

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Performance Troubleshooting Series : Troubleshooting Instance Memory Structures (SGA + PGA) Usage

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 […]

Performance Troubleshooting Series : Understanding Database CPU – Consumers – Waiters – Average Active Sessions

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 […]

Performance Troubleshooting Series: Understanding I/O Wait Performance of Oracle Database

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 […]

Performance Troubleshooting Series : Understanding where the database time is spending – Time Model Statistics

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 […]

Performance Troubleshooting Series : Understanding your database load from Metrics – Part 2

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 […]

Performance Troubleshooting Series : Understanding your Oracle Database Load

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 […]

Script for Staleness Percent for each table

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 […]