Oracle Internals

JulianDyke.com

Acknowledgements

Fixed Views

This section describes the fixed (X$) tables available in Oracle

X$BUFFERED_PUBLISHERS

X$BUFFERED_QUEUES

X$BUFFERED_SUBSCRIBERS

X$DBKH_CHECK_PARAM

X$DBKINCMETINFO

X$DBKINCMETSUMMARY

X$DNFS_CHANNELS

X$ESTIMATED_MTTR

X$GLOBALCONTEXT

X$INSTANCE_CACHE_TRANSFER

X$IR_MANUAL_OPTION

X$IR_REPAIR_OPTION

X$IR_REPAIR_STEP

X$IR_WORKING_FAILURE_SET

X$IR_WORKING_REPAIR_SET

X$KCRRPTDGSTATS

X$KESWXMON_PLAN

X$KEWRATTRSTALE

X$KEWX_SEGMENTS

X$KJDRMAFNSTATS

X$KKOCS_HISTOGRAM

X$KKOCS_SELECTIVITY

X$KKOCS_STATISTICS

X$KSDHNG_CHAINS

X$KSPVLD_VALUES

X$KTFTBTXNGRAPH

X$KWQMNTASKSTAT

X$LOGBUF_READHIST

X$LOGMNR_ATTRCOL$

X$LOGMNR_ATTRIBUTE$

X$LOGMNR_CALLBACK

X$LOGMNR_COLTYPE$

X$LOGMNR_CONTENTS

X$LOGMNR_DICTIONARY

X$LOGMNR_DICTIONARY_LOAD

X$LOGMNR_ENCRYPTED_OBJ$

X$LOGMNR_ENCRYPTION_PROFILE$

X$LOGMNR_INDCOMPART$

X$LOGMNR_INDPART$

X$LOGMNR_INDSUBPART$

X$LOGMNR_KTFBUE

X$LOGMNR_LOBFRAG$

X$LOGMNR_LOGFILE

X$LOGMNR_OPQTYPE$

X$LOGMNR_PARAMETERS

X$LOGMNR_PARTOBJ$

X$LOGMNR_PROCESS

X$LOGMNR_PROPS$

X$LOGMNR_REFCON$

X$LOGMNR_REGION

X$LOGMNR_SESSION

X$LOGMNR_SUBCOLTYPE$

X$LOGMNR_TABCOMPART$

X$LOGMNR_TABPART$

X$LOGMNR_TABSUBPART$

X$LOGMNR_TRANSACTION

X$MUTEX_SLEEP_HISTORY

X$NLS_PARAMETERS

X$OBJECT_AFFINITY_STATISTICS

X$OBJECT_POLICY_STATISTICS

X$PERSISTENT_PUBLISHERS

X$PERSISTENT_QUEUES

X$PERSISTENT_SUBSCRIBERS

X$POLICY_HISTORY

X$TEMPORARY_LOB_REFCNT

X$TIMEZONE_FILE

X$TIMEZONE_NAMES

X$XML_AUDIT_TRAIL

X$XS_SESSION_ROLES