Oracle DBA Question:
Download Questions PDF

Explain below wait events in STATSPACK report DB SCATTERED READ, DB SEQUENTIAL REAL, ENQUEUE?

DB SCATTERED READ - FULL TABLE SCAN
DB SEQUENTIAL REAL - IO
ENQUEUE - LOCKING

Download Oracle DBA Interview Questions And Answers PDF

Previous Question	Next Question
Process you follow to start looking into Performance issue at database level (If the application is running very slow, at what points do you need to go about the database in order to improve the performance?)	List five most important parameter in 9i affecting performance?