Oracle Pools Used to Store the Actual Data in Memory
The initialization parameters DB_CACHE_SIZE, DB_KEEP_CACHE_SIZE, and DB_RECYCLE_CACHE_SIZE are the determining factors for memory used to store data in Oracle.
Read MoreMost Popular
Oracle Waits and Latches Related to Initialization Parameters
Setting Oracle initialization parameters incorrectly can result in performance issues that show up as general “waits” or “latch waits” in a STATSPACK report. Learn more.
Read MoreBest Settings for Oracle Library Cache Reload and Library Cache Hit Ratios
For optimal performance, keep the Oracle library cache reload ratio at zero and the library cache hit ratio greater than 95 percent. Learn more.
Read MoreBest Settings for Oracle Data Dictionary Cache Hit Ratio
The Oracle data dictionary cache is a key area to tune because the dictionary is accessed so frequently, but it should be monitored only after the system has been up for a while and stabilized.
Read MoreOptimal Use of the Shared SQL Area in Oracle
To ensure optimal use of the shared SQL area in Oracle, use stored procedures as much as possible. Learn more.
Read MoreBest Setting for Oracle DB_BLOCK_SIZE
The Oracle DB_BLOCK_SIZE is the default data block size when the database is created. A separate cache memory allocation must be made for each different database block size, and choose wisely.
Read MoreHow to Identify Crucial Initialization Parameters in Oracle
Even with query tuning, Oracle will still be slow if the parameters for the initialization file aren’t set correctly, and there are a few parameters can lead to significant performance gains.
Read MoreHow to Determine If the Oracle Redo Log File Size Is a Problem
Two potential problems to consider when increasing the size of Oracle log files: batch jobs without enough total redo space and long-running jobs spending lots of time switching online redo logs.
Read MoreSpeed Oracle by Increasing the Log File Size
To speed up large numbers of INSERTs, UPDATEs, and DELETEs, increase the sizes of your log files but there are some critical points to consider before you do.
Read MoreAvoid Chaining in Oracle by Setting PCTFREE Correctly
Row chaining can occur in Oracle when there isn’t enough room in the data blocks to store a single row or the most recent changes to a row, and can impact performance.
Read MoreFragmentation in Oracle 11gR2–Myths and Realities
If you need to deal with reorganization because of fragmentation in Oracle, there are several ways to do so while minimizing downtime.
Read MoreAbout Index Partitioning in Oracle 11gR2
Partitioned indexes in Oracle have the same advantages as partitioned tables: Improved performance. Learn more.
Read More