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
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 Question | Next Question |
Explain below wait events in STATSPACK report DB SCATTERED READ, DB SEQUENTIAL REAL, ENQUEUE? | What is PGA_AGGREGATE_TARGET? |