What Tuning Indicators Can One Use?

1.	What Tuning Indicators Can One Use?
Answer» The following high-level TUNING indicators can be used to establish if a database is performing optimally or not: Buffer Cache Hit RATIO. FORMULA: Hit Ratio = (LOGICAL READS - Physical Reads) / Logical Reads. Action: Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i) to increase hit ratio. Library Cache Hit Ratio. Action: Increase the SHARED_POOL_SIZE to increase hit ratio. The following high-level tuning indicators can be used to establish if a database is performing optimally or not: Formula: Hit Ratio = (Logical Reads - Physical Reads) / Logical Reads. Action: Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i) to increase hit ratio. Action: Increase the SHARED_POOL_SIZE to increase hit ratio.

Answer»

The following high-level TUNING indicators can be used to establish if a database is performing optimally or not:

FORMULA: Hit Ratio = (LOGICAL READS - Physical Reads) / Logical Reads.

Action: Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i) to increase hit ratio.

Action: Increase the SHARED_POOL_SIZE to increase hit ratio.

The following high-level tuning indicators can be used to establish if a database is performing optimally or not:

Formula: Hit Ratio = (Logical Reads - Physical Reads) / Logical Reads.

Action: Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i) to increase hit ratio.

Action: Increase the SHARED_POOL_SIZE to increase hit ratio.

Discussion