CODEWITHSUNDEEP
oracle-database
kred
kred

Reputation: 1

What are User I O wait events like 'cell single block physical read', 'cell multiblock physical read', 'direct path read' and 'cell smart table scan'

I am learning Oracle DB performance monitoring data. From the dashboards, we have graphs showing User I O wait events and would like to understand what each of these events mean. Any inputs would greatly help 1. cell single block physical read 2. cell multiblock physical read 3. direct path read 4. cell smart table scan

Looking forward for some insights. If any references also helps

Upvotes: 0

Views: 6515

Answers (1)

Jon Heller
Jon Heller

Reputation: 36808

Start with the Oracle Wait Events Appendix in the Database Reference.

There are many other sources online that explain Oracle wait events, but you should always start with the manual.

Upvotes: 1

Related Questions