Oracle DBA Question:
Download Questions PDF

List five most important parameter in 9i affecting performance?

Answer:

CURSOR_SHARING
DB_CACHE_SIZE
PGA_AGGREGATE_TARGET
DB_16K_CACHE_SIZE, DB_8K_CACHE_SIZE, DB_2K_CACHE_SIZE

Download Oracle DBA Interview Questions And Answers PDF

Previous QuestionNext Question
Explain below wait events in STATSPACK report DB SCATTERED READ, DB SEQUENTIAL REAL, ENQUEUE?What is PGA_AGGREGATE_TARGET?