Oracle Scratchpad

June 2, 2009

Fixed Stats

Filed under: Execution plans, Performance, Statistics, Troubleshooting, Tuning — Jonathan Lewis @ 7:19 pm UTC Jun 2,2009

There was a question about the notorious dba_extents view on the comp.databases.oracle.server newsgroup a little while ago.

This is a view that has been popularly abused over the years despite warnings such as a note of mine in 2006 and even back as far as 2001 this one from Connor McDonald.

There are many reasons why this is a nasty view – and the number of reasons has grown as Oracle has evolved – but David FitzJarell has highlighted an important point in one of his blog postings that was worth a mention. So here it is.

Blog at WordPress.com.