Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 11.1 Fixed Tables

In Oracle 10.2 there were 597 fixed tables; in Oracle 11.1 there are 767 fixed tables

The following table shows the 186 fixed tables that were added in Oracle 11.1:

Name
X$DBGALERTEXT
X$DBGDIREXT
X$DBGRICX
X$DBGRIFX
X$DBGRIKX
X$DBGRIPX
X$DBKEFAFC
X$DBKEFDEAFC
X$DBKEFEFC
X$DBKEFIEFC
X$DBKFDG
X$DBKFSET
X$DBKH_CHECK
X$DBKH_CHECK_PARAM
X$DBKINCMETCFG
X$DBKINCMETINFO
X$DBKINCMETSUMMARY
X$DBKINFO
X$DBKRECO
X$DBKRUN
X$DGLPARAM
X$DIAG_INFO
X$DNFS_CHANNELS
X$DNFS_FILES
X$DNFS_HIST
X$DNFS_META
X$DNFS_SERVERS
X$DNFS_STATS
X$GIMSA
X$IR_MANUAL_OPTION
X$IR_REPAIR_OPTION
X$IR_REPAIR_STEP
X$IR_RS_PARAM
X$IR_WF_PARAM
X$IR_WORKING_FAILURE_SET
X$IR_WORKING_REPAIR_SET
X$IR_WR_PARAM
X$KCBDBK
X$KCBTEK
X$KCBUWHY
X$KCCACM
X$KCCBLKCOR
X$KCCRL
X$KCFISTSA
X$KDLU_STAT
X$KEAFDGN
X$KECPDENTRY
X$KECPRT
X$KESWXMON
X$KESWXMON_PLAN
X$KETCL
X$KETOP
X$KETTG
X$KEWMIOFMV
X$KEWMRMGMV
X$KFDDD
X$KFDFS
X$KFENV
X$KFGBRB
X$KFMDGRP
X$KFNSDSKIOST
X$KFVOFS
X$KFVOFSV
X$KFVOL
X$KFVOLSTAT
X$KGSCC
X$KGSKNCFT
X$KJPNPX
X$KKCNRSTAT
X$KKKICR
X$KKOCS_HISTOGRAM
X$KKOCS_SELECTIVITY
X$KKOCS_STATISTICS
X$KMGSBSMEMADV
X$KMPCMON
X$KMPCP
X$KMPCSO
X$KMPSRV
X$KNSTMT
X$KPONEXSTAT
X$KPOQSTA
X$KPPLCC_INFO
X$KPPLCC_STATS
X$KPPLCP_STATS
X$KRASGA
X$KRBMCA
X$KRSSMS
X$KRSTALG
X$KRSTDEST
X$KRSTDGC
X$KRSTPVRS
X$KRVXDTA
X$KRVXOP
X$KRVXWARNV
X$KSDAF
X$KSDAFT
X$KSDHNG_CHAINS
X$KSFDSTCG
X$KSFDSTCMP
X$KSFDSTFILE
X$KSFDSTHIST
X$KSFDSTTHIST
X$KSLLTR
X$KSLWH
X$KSLWT
X$KSRPCIOS
X$KSUINSTSTAT
X$KSUNETSTAT
X$KSXPCLIENT
X$KSXPIF
X$KSXPPING
X$KSXPTESTTBL
X$KTCNCLAUSES
X$KTCNINBAND
X$KTCNQROW
X$KTCNQUERY
X$KTCNREGQUERY
X$KTFTBTXNGRAPH
X$KTFTBTXNMODS
X$KTSLCHUNK
X$KTTETS
X$KTUCUS
X$KWQMNC
X$KWQMNJIT
X$KWQMNSCTX
X$KWQMNTASK
X$KWQMNTASKSTAT
X$KXFPIG
X$KXFPPIG
X$KYWMCLTAB
X$KYWMNF
X$KYWMPCTAB
X$KYWMWRCTAB
X$KZEKMENCWAL
X$KZPOPR
X$LOBSEGSTAT
X$LOBSTAT
X$LOBSTATHIST
X$LOGBUF_READHIST
X$LOGMNR_ATTRCOL$
X$LOGMNR_CDEF$
X$LOGMNR_CLU$
X$LOGMNR_ENC$
X$LOGMNR_FILE$
X$LOGMNR_INDCOMPART$
X$LOGMNR_INDSUBPART$
X$LOGMNR_KOPM$
X$LOGMNR_KTFBUE
X$LOGMNR_LOB$
X$LOGMNR_LOBFRAG$
X$LOGMNR_NTAB$
X$LOGMNR_OPQTYPE$
X$LOGMNR_PARTOBJ$
X$LOGMNR_PROPS$
X$LOGMNR_REFCON$
X$LOGMNR_SEG$
X$LOGMNR_SUBCOLTYPE$
X$LOGMNR_UET$
X$LOGMNR_UNDO$
X$NFSCLIENTS
X$NFSLOCKS
X$NFSOPENS
X$OBJECT_POLICY_STATISTICS
X$OPARG
X$OPDESC
X$OPVERSION
X$PERSISTENT_PUBLISHERS
X$PERSISTENT_QUEUES
X$PERSISTENT_SUBSCRIBERS
X$POLICY_HISTORY
X$QESRCDEP
X$QESRCMEM
X$QESRCOBJ
X$QESRCSO
X$QESRCSTA
X$QKSBGSES
X$QKSBGSYS
X$QKSFM
X$QKSFMDEP
X$QKSFMPRT
X$QKSHT
X$RFAFO
X$RFAHIST
X$XPLTON
X$XPLTOO
X$XS_SESSION_ROLES

The following table shows the 16 fixed tables that were removed in Oracle 11.1:

Name
X$KCFTIOHIST
X$KCKCE
X$KCKFM
X$KCKTY
X$KCRRALG
X$KCRRDEST
X$KCRRDGC
X$KCRRMS
X$KCRRPVRS
X$KGICC
X$KRVXWNMESG
X$KSLLT
X$KSUSEH
X$LCR
X$LOGMNR_DICT$
X$OBJECT_AFFINITY_STATISTICS