Category: Performance

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 statistics Missing or wrong dictionary statistics can lead to performance issues from Oracle...

Read More