Month: July 2011

Oracle Fixed Object Statistics

Fixed objects are in-memory structures and variables inside the Oracle kernel. Fixed table names start with X$ and represent data via performance views like v$session. Performance views are used in applications (fixed tables...

Read More

Oracle Dictionary Statistics

Statistics on Oracle-defined schemas like sys, ctxsys, dbsnmp, mdsys, etc are called dictionary statistics.  Why to gather dictionary statisticsMissing or wrong dictionary statistics can lead to performance issues from...

Read More