Author: abuData

Real World Performance Day @Frankfurt

Real World Performance Day took place in Frankfurt on 25-AUG-2011. Real World Performance Day means three presenters – three roles – three screens. Tom Kyte acted as developer and showed the material available...

Read More

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