Wait Events
select name from v$event_name where name like ‘%cell%’;
NAME
—————————————————————-
cell smart table scan
cell smart index scan
cell statistics gather
cell smart incremental backup
cell smart file creation
cell smart restore from backup
cell single block physical read
…
Â
From AWR
     cell single block physical read: 533,424,212 in 293,122seconds = 550 microseconds (!)
per single block IO. See ‘db file sequential read’ on non-Exadata
Discussion ¬