Using Histograms to Help Oracle Cost-Based Optimizer Make Better Decisions
Learn how histograms help Oracle’s cost-based optimizer (CBO) to make better decisions and improve performance.
Read MoreMost Popular Databases
Top Objects finds PK Index in Oracle
Learn more about Oracle’s Top Objects view and how to use it.
Read MoreLooking at Linux Utilization with sar and Oracle’s V$OSSTAT
Learn some tips for looking at Linux Utilization with sar and Oracle’s V$OSSTAT.
Read MoreComparing and Merging Divergent Data in Oracle
Learn how Oracle packages and views can help validate and then re-sync database objects.
Read MoreExtended Optimizer Statistics in Oracle 11g Improve Performance
Learn how extended optimizer statistics in Oracle 11g can lead to better execution plans and improved performance.
Read MoreFinding Usable Oracle Indexes
Learn how cleaning up unused indexes can impact Oracle performance.
Read MoreInvisible Indexes in Oracle 11g
Learn about how invisible index in Oracle 11g can impact performance.
Read MoreOracle Wait Event Explained: Direct Path Read Temp
When a session reads buffers from disk directly into the PGA, the wait is on direct path read temp. Learn which tuning efforts can reduce this wait.
Read MorePerformance Improvements with Oracle 11g Data Types
Learn how Oracle 11g provides a new data type that will reduce some of the overhead otherwise found using PL/SQL numbers.
Read MoreScript to find over-allocated tables in Oracle
Learn how to find and shrink over-allocated tables in Oracle.
Read More1000% 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 MoreSQL Server Consolidation, Part 3
Any SQL Server consolidation project is going to have its share of bumps in the road, but planning and up-front research can help you avoid a lot of headaches and miscommunication later on.
Read More