Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.2 Fixed Tables

In Oracle 10.1 there were 529 fixed tables; in Oracle 10.2 there are 597 fixed tables

The following table shows the 73 fixed tables that were added in Oracle 10.2:

Name
X$BUFFER2
X$JSKSLV
X$KCCNRS
X$KCCRSP
X$KCRRASTATS
X$KCRRNHG
X$KCRRPTDGSTATS
X$KCRRPVRS
X$KELRSGA
X$KELRXMR
X$KEWRATTRNEW
X$KEWRATTRSTALE
X$KEWRSQLCRIT
X$KEWRTOPTENV
X$KEWRTSQLPLAN
X$KEWRTSQLTEXT
X$KFBH
X$KFCBH
X$KFCCE
X$KFCLLE
X$KFDSK_STAT
X$KFGRP_STAT
X$KFKLIB
X$KGSKSCS
X$KGSKVFT
X$KJLEQFP
X$KJREQFP
X$KKSSQLSTAT
X$KMGSBSADV
X$KMGSTFR
X$KNGFLE
X$KNLAROW
X$KNLASG
X$KNSTTXN
X$KQFOPT
X$KRBZA
X$KRFSTHRD
X$KRVSLVAS
X$KRVSLVPG
X$KRVSLVST
X$KRVSLVTHRD
X$KRVXTHRD
X$KRVXTX
X$KRVXWNMESG
X$KSBFT
X$KSIRGD
X$KSKPLW
X$KSLHOT
X$KSMPGDP
X$KSMPGDST
X$KSMPGST
X$KSMSST
X$KSPVLD_VALUES
X$KSUSM
X$KTATL
X$KTATRFIL
X$KTATRFSL
X$KTCNREG
X$KTSTUSC
X$KTSTUSG
X$KTSTUSS
X$KTUSUS
X$KXFPBS
X$KZEKMFVW
X$LOGMNR_LOG
X$MUTEX_SLEEP
X$MUTEX_SLEEP_HISTORY
X$OBJECT_AFFINITY_STATISTICS
X$OPERATORS
X$QESBLSTAT
X$RULE
X$RULE_SET
X$XML_AUDIT_TRAIL

The following table shows the five fixed tables that were removed in Oracle 10.2:

Name
X$KEWRTSQLSTAT
X$KSPXFR
X$KZEMAEA
X$KZEMAIE
X$LOGMNR_TRANSACTION