Expand the Buffer Cache to Reduce Physical Reads in an Oracle Database
Learn how exapnding the Oracle buffer cache can reduce physical reads and improve performance.
Read MoreMost Popular Oracle
Why Oracle Execution Plans with Predicates are an Important Tuning Tool
Learn about the importance of reviewing Oracle SQL plans in tuning SQL statements.
Read MoreTuning “IS NULL” Query Criteria with Clever Oracle Indexing
Learn about a clever Oracle indexing strategy for queries that involve “IS NULL” criteria.
Read MoreUsing 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 MoreTop 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 More