Hi,
I have an Oracle RDBMS 11gR2 EE that uses Exadata,
I have a process that has the followiing steps:
1) Disable all constraint
2) Drop index
3) Truncate table
4) Repopulate table from other kind of data
5) Recreate index
6) Reenable constraints
The involed table is compressed with HCC option.
When I run the step 5) it takes quite some time and one of the main wait event is "cell single block physical read".
Can someone explain me why I get why I get this wat event instead of a smart scans?
Thanks and Regards.