Performance and Tuning Guide
Which
tools or utilities should I use to diagnose the poor performance of my database?
How can I calculate
SGA size in Oracle 8i?
Which are the most
crucial parameters in init.ora?
How can I get the largest amount of physical reads by any query?
How can I get the
largest amount of logical reads by any query?
What is the optimum value for hit ratio?
When one should increase db_block_buffers?
What are the techniques to
increase the reliability and performance?
What is the recommended size of block for an OLTP database.
How can I find Table, Index and Column which are indexed?
Performance and Tuning Scripts
MORE TUNING FAQ
SEARCH BOOKS
HERE:
Actual Questions, Exact Answers Become OCP on First Attempt Includes all 22 exams
PERFORMANCE & TUNING Q & A
