Secret hacking session ? full scans, direct path reads, object level checkpoints, ORA-8103s!Topics:How do full table scans workHow and why do the ?ORA-8103: object no longer exists? happenHow does Oracle (11g) decide between a buffered full table scan and a direct path read scan (plus smart scan in Exadata)What?s the difference between an object_id and data_object_id?and more!
This is the first episode of the first season of the Oracle Troubleshooting TV show by Tanel Poder, suitable for all audiences! ;-) Scripts, tools and more info can be downloaded from my blog: http://blog.tanelpoder.com