Oracle9i Database: Performance Tuning (3)

Sizing the Shared Pool

• V$librarycache è library cache hit ratio è Ratio = sum(PINHITS)/sum(PINS). Or (sum(PINS)- sum(RELOADS))/ sum(PINS)

Sizing the Buffer Cache

• Sized redo log file size so that v$system_event indicates no LOG FILE PARALLEL WRITE WAIT EVENT

• Database buffer cache store

Ø The rollback segments

Ø Temporary segments

Ø Clusters

Ø Database tables

Ø Index

Ø Large objects(LOB)