Script to find over-allocated tables in Oracle
Learn how to find and shrink over-allocated tables in Oracle.
Read MoreMost Popular Oracle
1000% Performance Improvement Using Oracle 11g Result Cache
If you have a query that is executed often and reads data that rarely changes, result cache in Oracle 11g can significantly increase performance. Learn how.
Read MorePerformance Tuning and Time Invested
Read a DBA’s point of view on investing time in performance tuning SQL queries and why it matters.
Read MoreOracle Cache Buffers Chain Latch
Learn how the Oracle cache buffers chain latch can impact performance and what to do about it.
Read MoreOracle Block Change Tracking Buffer Wait Event
Learn more about the Oracle Block Change Tracking Buffer wait event and how to tune for it here.
Read MoreWait Statistics are the Bread and Butter of Performance Tuning
Yes, it’s true. Don’t believe me? Fine then, would you believe Paul Randal? It’s a simple fact, really. If you know what your queries are waiting for, then you know how to improve performance. And that is why customers LOVE SolarWinds Database Performance Analyzer because we put the statements and waits right in front of […]
Read MoreOracle Cost Optimizer Statistics
Learn how statistics are gathered for the Oracle CBO and improve your tuning efforts.
Read MoreUnderstanding the Oracle Cost-based Optimizer (CBO)
Learn how the Oracle cost-based optimizer (CBO) can impact performance.
Read MoreUsing Index Hints to Tune Oracle Performance
Knowing how to use index hints can help you improve Oracle performance tuning.
Read MoreUsing Driving Table Hints to Tune Oracle Performance
Learn how to diriving tables hints to improve Oracle performance tuning.
Read MorePartitioned Query Explain Plans
Learn how Oracle optimizes partitioned queries and how this affects performance tuning.
Read MoreOracle Explain Plans: Driving Tables and Table Joins
Learn how a query’s driving table can impact Oracle performance.
Read More