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 from his website ( http://asktom.oracle.com ). Andrew...
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 should not be queried directly). Why to...
Oracle Dictionary Statistics
Statistics on Oracle-defined schemas like sys, ctxsys, dbsnmp, mdsys, etc are called dictionary statistics. Why to gather dictionary statistics Missing or wrong dictionary statistics can lead to performance issues from Oracle 10g onwards. For Oracle version 9i, Oracle...