Category: Performance

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...

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...