Search notes:

Oracle: Fixed tables (X$ tables)

Dynamic performance tables (whose names start with x$) and their indexes are commonly referred to as fixed objects. The data of these tables only exists in memory when an instance is running. Thus, they provide an SQL interface to view Oracle's memory in the SGA.
These objects are called fixed because no DML statement (let alone DDL statement) is allowed on these - only select statements.
Table names and their respective column names can be queried with the following SQL statement:
select
   x$kqfta.kqftanam   table_name,
   x$kqfco.kqfconam   column_name
from
   x$kqfta   left join
   x$kqfco             on x$kqfta.kqftaobj  = x$kqfco.kqfcotob
order by
   x$kqfta.kqftanam,
   x$kqfco.indx;
With the dynamic performance views, it's possible to query x$ table names from v$fixed_table.
Columns that are indexed can be queried from v$indexed_fixed_column.
A query that returns dependencies between dynamic performance views (v$ views) and x$ tables is here.

List of some X$ tables

A «work-in-progress» list of x$ tables:
x$abstract_lob
x$activeckpt
x$all_ash referenced in x$kqfdt
x$all_keswxmon referenced in x$kqfdt
x$all_keswxmon_plan referenced in x$kqfdt
x$all_kqlfxpl referenced in x$kqfdt
x$aq_message_cache_advice
x$aq_opt_cached_subshard
x$aq_opt_inactive_subshard
x$aq_opt_stats
x$aq_opt_uncached_subshard
x$aq_remote_deqaff
x$aq_subscriber_load
x$aq_subtrans
x$ash
x$ash_for_awr
x$aud_dpapi_actions
x$aud_dp_actions
x$aud_dv_obj_events
x$aud_obj_actions
x$aud_ols_actions
x$aud_protocol_actions
x$aud_xs_actions
x$bh Buffer header
x$bmapnondursub
x$buffer
x$buffer2
x$buffered_publishers
x$buffered_queues
x$buffered_subscribers
x$cdbvw$
x$cell_name
x$ckptbuf
x$comvw$
x$con
x$context
x$con_kewmdrmv
x$con_kewmsmdv
x$con_kewssysv
x$con_kslei
x$con_kslscs
x$con_kslseshist_micro
x$con_ksusgsta
x$dbgalertext Content of the alert log.
x$dbgatflist
x$dbgdirext
x$dbglogext
x$dbgricx
x$dbgrifx
x$dbgrikx
x$dbgripx
x$dbgtflist
x$dbgtfoptt
x$dbgtfsoptt
x$dbgtfsqlt
x$dbgtfssqlt
x$dbgtfview Contents of trace files?
x$dbkece
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 Executions of database structure integrity checks?
x$dbreplay_patch_info
x$dglparam
x$dglxdat
x$diag_adr_control
x$diag_adr_control_aux
x$diag_adr_invalidation
x$diag_alert_ext Alert file?
x$diag_ams_xaction
x$diag_dde_user_action
x$diag_dde_user_action_def
x$diag_dde_usr_act_param
x$diag_dde_usr_act_param_def
x$diag_dde_usr_inc_act_map
x$diag_dde_usr_inc_type
x$diag_dfw_config_capture
x$diag_dfw_config_item
x$diag_dfw_patch_capture
x$diag_dfw_patch_item
x$diag_dfw_purge
x$diag_dfw_purge_item
x$diag_diagv_incident
x$diag_dir_ext
x$diag_em_diag_job
x$diag_em_target_info
x$diag_em_user_activity
x$diag_hm_fdg_set
x$diag_hm_finding
x$diag_hm_info
x$diag_hm_message
x$diag_hm_recommendation
x$diag_hm_run
x$diag_incckey
x$diag_incident
x$diag_incident_file
x$diag_inc_meter_config
x$diag_inc_meter_impt_def
x$diag_inc_meter_info
x$diag_inc_meter_pk_impts
x$diag_inc_meter_summary
x$diag_info
x$diag_ips_configuration
x$diag_ips_file_copy_log
x$diag_ips_file_metadata
x$diag_ips_package
x$diag_ips_package_file
x$diag_ips_package_history
x$diag_ips_package_incident
x$diag_ips_pkg_unpack_hist
x$diag_ips_progress_log
x$diag_ips_remote_package
x$diag_log_ext
x$diag_pdb_problem
x$diag_pdb_space_mgmt
x$diag_pickleerr
x$diag_problem
x$diag_relmd_ext
x$diag_sweeperr
x$diag_vadr_control
x$diag_vem_user_actlog
x$diag_vem_user_actlog1
x$diag_vhm_run
x$diag_view
x$diag_viewcol
x$diag_vincident
x$diag_vincident_file
x$diag_vinc_meter_info
x$diag_vips_file_copy_log
x$diag_vips_file_metadata
x$diag_vips_package_file
x$diag_vips_package_history
x$diag_vips_package_main_int
x$diag_vips_package_size
x$diag_vips_pkg_file
x$diag_vips_pkg_inc_cand
x$diag_vips_pkg_inc_dtl
x$diag_vips_pkg_inc_dtl1
x$diag_vips_pkg_main_problem
x$diag_vnot_exist_incident
x$diag_vpdb_problem
x$diag_vproblem
x$diag_vproblem1
x$diag_vproblem2
x$diag_vproblem_bucket
x$diag_vproblem_bucket1
x$diag_vproblem_bucket_count
x$diag_vproblem_int
x$diag_vproblem_lastinc
x$diag_vshowcatview
x$diag_vshowincb
x$diag_vshowincb_i
x$diag_vtest_exists
x$diag_v_actinc
x$diag_v_actprob
x$diag_v_inccount
x$diag_v_incfcount
x$diag_v_inc_meter_info_prob
x$diag_v_ipsprbcnt
x$diag_v_ipsprbcnt1
x$diag_v_nfcinc
x$diag_v_swperrcount
x$dir
x$dnfs_channels
x$dnfs_files
x$dnfs_hist
x$dnfs_meta
x$dnfs_servers
x$dnfs_stats
x$dra_failure
x$dra_failure_check
x$dra_failure_check_map
x$dra_failure_param
x$dra_failure_parent_map
x$dra_failure_repair
x$dra_failure_repair_map
x$dra_repair
x$dra_repair_param
x$drc
x$drm_history
x$drm_history_stats
x$drm_wait_stats
x$dual
x$durable_sharded_subs
x$estimated_mttr
x$gcractions
x$gcrlog
x$gcrmetrics
x$gcrstatus
x$gimsa
x$globalcontext
x$gsmregions
x$gwmraff
x$heatmapsegment
x$heatmapsegment1
x$hofp
x$hs_session
x$iee
x$iee_condition
x$iee_orpiece
x$imcsegextmap
x$imcsegments
x$imctbsextmap
x$imhmseg
x$imhmseg1
x$instance_cache_transfer
x$ipcor_topo_domain
x$ipcor_topo_ndev
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$joxdrc referenced in x$kqfdt
x$joxdrr referenced in x$kqfdt
x$joxfc referenced in x$kqfdt
x$joxfd referenced in x$kqfdt
x$joxfr referenced in x$kqfdt
x$joxfs referenced in x$kqfdt
x$joxfm
x$joxft
x$joxmag referenced in x$kqfdt
x$joxmex referenced in x$kqfdt
x$joxmfd referenced in x$kqfdt
x$joxmic referenced in x$kqfdt
x$joxmif referenced in x$kqfdt
x$joxmmd referenced in x$kqfdt
x$joxmob referenced in x$kqfdt
x$joxobj referenced in x$kqfdt
x$joxref referenced in x$kqfdt
x$joxrsv referenced in x$kqfdt
x$joxscd referenced in x$kqfdt
x$jsimtft
x$jskjobq
x$jskmimmd
x$jskmimrt
x$jskslv
x$k2gte
x$k2gte2
x$kauvrstat
x$kbrpstat
x$kcbbes
x$kcbbf
x$kcbbhs
x$kcbdbk
x$kcbdwobj
x$kcbdws
x$kcbfcio
x$kcbfwait
x$kcbinstview
x$kcbkpfs
x$kcbkwrl
x$kcbldrhist
x$kcblsc
x$kcbmkid
x$kcbmmav
x$kcbobh
x$kcboqh
x$kcbpdbrm
x$kcbpintime
x$kcbprfh
x$kcbsc
x$kcbsds
x$kcbsh
x$kcbsw
x$kcbtek
x$kcbuwhy
x$kcbwait
x$kcbwbpd Working pool descriptions?
x$kcbwds Working data set?
x$kcbwh
x$kccacm
x$kccadfc
x$kccagf
x$kccal Archived logs
x$kccbf
x$kccbi
x$kccbl
x$kccblkcor
x$kccbp Autobackup?
x$kccbs
x$kcccc
x$kcccf Name and characteristics(?) of Control files.
x$kcccp Checkpoint progress
x$kccdc
x$kccdfhist
x$kccdi
x$kccdi2
x$kccdl
x$kccfc
x$kccfe File Entries (from Control files)
x$kccfle
x$kccfn Database files and log files (fntyp = 3)
x$kccic
x$kccirt
x$kccle Log information
x$kcclh log history
x$kccnrs
x$kccor
x$kccpa
x$kccpd
x$kccpdb
x$kccpic
x$kccrdi Base for v$recovery_file_dest
x$kccrl
x$kccrm RMAN configuration?
x$kccrs
x$kccrsp
x$kccrsr
x$kccrt (Current?) redo thread?
x$kccsl
x$kcctf
x$kcctir
x$kcctkh
x$kccts Tablespaces
x$kcfio (Data?)file I/O statistics
x$kcfiofchist
x$kcfiohist
x$kcfiscap Capabilities?
x$kcfisoss
x$kcfisossawr
x$kcfisossc
x$kcfisossl
x$kcfisossn
x$kcfisosst
x$kcfistcap
x$kcfistsa
x$kcftio
x$kclcrst
x$kclcurst
x$kclfx
x$kclls
x$kclpingpin
x$kclpingwev
x$kclrcvst
x$kcmscn
x$kcnt
x$kcpdbinc
x$kcpxpl
x$kcrfdebug
x$kcrfstrand
x$kcrfws
x$kcrfx
x$kcrmf
x$kcrmt
x$kcrmx
x$kcrrarch
x$kcrrastats
x$kcrrdstat
x$kcrrlns
x$kcrrnhg
x$kcticw
x$kctlax
x$kcvdf
x$kcvfh File headers
x$kcvfhall referenced in x$kqfdt
x$kcvfhmrr referenced in x$kqfdt
x$kcvfhonl referenced in x$kqfdt
x$kcvfhtmp
x$kdkvimhashindex
x$kdkvimhashindex_objects
x$kdlt
x$kdlu_stat
x$kdmadoelements
x$kdmadotaskdetails
x$kdmadotasks
x$kdmimccol
x$kdmimchead
x$kdmimdeltahead
x$kdmimeucol
x$kdmimeuhead
x$kdmufaststartarea
x$kdmuglobaldict
x$kdmuglobaldictpmap
x$kdmuglobaldictso
x$kdmuglobaldictver
x$kdnssf
x$kdxhs
x$kdxst
x$kdzcolcl
x$kd_column_statistics
x$keacmdn SQL (advisory) commands; dba_advisor_commands selects from x$keacmdn
x$keafdgn
x$keaobjt
x$kecpdentry
x$kecprt
x$kecptc
x$kecuc_cache
x$kec_component_timing
x$kec_progress
x$keheclmap
x$kehetsx
x$kehevtmap
x$kehf
x$kehosmap
x$kehprmmap
x$kehr
x$kehrp
x$kehr_child
x$kehsqt
x$kehsysmap
x$kehtimmap
x$keiut
x$keiut_info
x$kelrsga
x$kelrtd
x$kelrxmr
x$keltgsd
x$keltosd
x$keltsd
x$keomm_dbop_list
x$keomnmon_sesstat
x$kerpirepreq
x$kerpistats
x$kesplan
x$kesspamet
x$keswxmon
x$keswxmon_plan
x$keswxmon_statname
x$ketcl
x$ketop
x$kettg
x$keumlinktb
x$keumregtb
x$keumsvctb
x$keumtb
x$keumtoptb
x$kewam
x$kewash
x$kewcimpstgtb
x$kewecls
x$kewefxt
x$kewepcs
x$kewesmas
x$kewesms
x$kewflinfo
x$kewmafmv
x$kewmchkmv
x$kewmdrmv
x$kewmdsm
x$kewmevmv
x$kewmflmv
x$kewmgsm
x$kewmiofmv
x$kewmrmgmv
x$kewmrmpdbmv
x$kewmrsm
x$kewmrwmv
x$kewmsemv
x$kewmsmdv
x$kewmsrgmv
x$kewmsvcmv
x$kewmwcrmv
x$kewmwpcmv
x$kewpdbinsnap
x$kewrattrnew
x$kewrattrstale
x$kewrcache
x$kewrconidlookup
x$kewrimsegstat
x$kewripsl
x$kewrsqlcrit
x$kewrsqlidtab
x$kewrsqlsum
x$kewrstgtb
x$kewrtb
x$kewrtbgm
x$kewrtb_all
x$kewrtoptenv
x$kewrtsegstat
x$kewrtsqlplan
x$kewrtsqltext
x$kewssesv
x$kewssmap
x$kewssvcv
x$kewssysv
x$kewxocf
x$kewx_indexes
x$kewx_lobs
x$kewx_segments
x$kexsvfu
x$kexsvus
x$kfals
x$kfbf
x$kfbh
x$kfbtyp
x$kfcbh
x$kfcce
x$kfclle
x$kfcsga
x$kfcstat
x$kfcte
x$kfctet
x$kfctet_delta
x$kfdap
x$kfdat
x$kfddd
x$kfdfs
x$kfdpartner
x$kfdsd
x$kfdsk
x$kfdsk_sparse
x$kfdsk_sparse_stat
x$kfdsk_stat
x$kfdsr
x$kfdxext
x$kfenv
x$kffg
x$kffgf
x$kffgpt
x$kffil
x$kffil_sparse
x$kffof
x$kffscrub
x$kffxp
x$kfgbrb
x$kfgbrc
x$kfgbrs
x$kfgbrw
x$kfgmg
x$kfgrp
x$kfgrp_sparse
x$kfgrp_stat
x$kfgxp
x$kfias_clnt
x$kfias_file
x$kfias_proc
x$kfipcompat
x$kfkid
x$kfklib
x$kfklsod
x$kfmdgrp
x$kfncl
x$kfncwcl
x$kfndiosprs
x$kfnrcl
x$kfnsdskiost
x$kfqg
x$kfrc
x$kftmta
x$kfvacfs
x$kfvacfsa
x$kfvacfsadmin
x$kfvacfscmdrule
x$kfvacfsencr
x$kfvacfsrealm
x$kfvacfsrealmfilter
x$kfvacfsrealmgroup
x$kfvacfsrealms
x$kfvacfsrealmuser
x$kfvacfsrepl
x$kfvacfsrepltag
x$kfvacfsrule
x$kfvacfsruleset
x$kfvacfsrulesetrule
x$kfvacfss
x$kfvacfstag
x$kfvacfsv
x$kfvol
x$kfvolstat
x$kfzgdr
x$kfzpblk
x$kfzuagr
x$kfzudr
x$kghlu summary of shared pool (sub)heap allocations and how many of these chunks are in the «transient list» (used once) vs. «recurrent list» (used more than once). (Does it show one record per shared pool area? Does it add another record if there is a Java pool?)
x$kgics
x$kglau
x$kglbody referenced in x$kqfdt
x$kglcluster referenced in x$kqfdt
x$kglcursor referenced in x$kqfdt
x$kglcursor_child referenced in x$kqfdt
x$kglcursor_child_sqlid referenced in x$kqfdt
x$kglcursor_child_sqlidph referenced in x$kqfdt
x$kglcursor_parent referenced in x$kqfdt
x$kgldp Object dependency
x$kglindex Indices? referenced in x$kqfdt
x$kgljmem
x$kgljsim
x$kgllk List all library object locks, held or requested.
x$kglmem
x$kglna Names?
x$kglna1
x$kglob Objects?
x$kglobxml
x$kglpn
x$kglrd
x$kglsim
x$kglsn
x$kglsqltxl referenced in x$kqfdt
x$kglst
x$kgltable Tables? referenced in x$kqfdt
x$kgltr
x$kgltrigger Triggers? referenced in x$kqfdt
x$kglxs Library cache access
x$kgscc
x$kgskasp
x$kgskcft
x$kgskcp
x$kgskdopp
x$kgskmeminfo
x$kgskncft
x$kgskpdbft
x$kgskpdbhistft
x$kgskpft
x$kgskpp
x$kgskquep
x$kgskscs
x$kgskte
x$kgskto
x$kgskvft
x$kjac_config
x$kjac_id
x$kjac_my_id
x$kjbfpbr
x$kjbl
x$kjblfx
x$kjbr
x$kjbrfx
x$kjcisot
x$kjcispt
x$kjctfr
x$kjctfri
x$kjctfs
x$kjdddeadlocks
x$kjdddeadlockses
x$kjdrbh
x$kjdrhv
x$kjdrmafnstats
x$kjdrmhvstats
x$kjdrmreadmostlystats
x$kjdrmreq
x$kjdrpcmhv
x$kjdrpcmpf
x$kjfmhbacl
x$kjicvt
x$kjidt
x$kjilft
x$kjilkft
x$kjirft
x$kjisft
x$kjitrft
x$kjkmkga
x$kjkmlock
x$kjkmreq
x$kjleqfp
x$kjmddp
x$kjmsdp
x$kjpmprc
x$kjpnpx
x$kjreqfp
x$kjrtbcfp
x$kjr_chunk_stats
x$kjr_freeable_chunks
x$kjscapkat
x$kjscasvcat
x$kjxgna_stats
x$kjxm
x$kjzncbhangs
x$kjznhangs
x$kjznhangses
x$kjznhmlsi
x$kjznhngmgrsts
x$kjznhngstats
x$kjznrslnrc
x$kjznwlmpcrank
x$kjzsiwtevt
x$kkaeet
x$kkcnereg
x$kkcneregstat
x$kkcnrstat
x$kkkicr
x$kkoar_hint
x$kkocs_histogram
x$kkocs_selectivity
x$kkocs_statistics
x$kksai … allocation info
x$kksbv bind variables
x$kkscs («reason»)
x$kkspcib
x$kkssqlstat ? SQL/Cursor statistics ?
x$kkssqlstat_plan_hash referenced in x$kqfdt
x$kkssrd
x$kksxsqlstat
x$klcie
x$klpt
x$kmcqs
x$kmcvc
x$kmgsbsadv
x$kmgsbsmemadv
x$kmgsct
x$kmgsop
x$kmgstfr
x$kmmdi
x$kmmdp
x$kmmhst
x$kmmnv
x$kmmrd
x$kmmsas
x$kmmsg
x$kmmsi
x$kmpcmon
x$kmpcp
x$kmpcso
x$kmpdh
x$kmpsrv
x$kngfl
x$kngfle
x$knlarow
x$knlasg
x$knlpmsgstat
x$knlp_actv_msgs
x$knlp_pend_msgs
x$knstacr
x$knstanr
x$knstasl
x$knstcap
x$knstcapcache
x$knstcaps
x$knstmt
x$knstmvr
x$knstoggc
x$knstord
x$knstpsts
x$knstrpp
x$knstrqu
x$knstsess
x$knsttxn
x$knstxsts
x$kocst
x$kpdbvproxy
x$kpondconstat
x$kpondestat
x$kponestat
x$kponjstat
x$kpoqsta
x$kpoxft
x$kpplcc_info
x$kpplcc_stats
x$kpplconn_info
x$kpplcp_stats
x$kqdpg
x$kqfco Columns of fixed tables
x$kqfdt
x$kqfopt
x$kqfp
x$kqfsz Sizes (in bytes) of some database components, to be used to estimate data block capacity.
x$kqfta Exhibits the names of the X$ tables.
x$kqftvrttst0
x$kqfvi names of the V$ (dynamic performance) views.
x$kqfvt Select statement of V$ (dynamic performance) views.
x$kqlfbc Bind variable capture?
x$kqlfsqce
x$kqlfxpl SQL execution plan
x$kqlset
x$kqpxinv
x$kqrfp
x$kqrfs
x$kqrpd
x$kqrsd
x$kqrst
x$krasga
x$krbabrstat
x$krbaff
x$krbmca
x$krbmrot
x$krbmrst
x$krbmsft
x$krbpdata
x$krbpdir
x$krbphead
x$krbppbctx
x$krbppbtbl
x$krbpsparse
x$krbza
x$krcbit
x$krccde
x$krccdr
x$krccds
x$krcext
x$krcfbh
x$krcfde
x$krcfh
x$krcgfe
x$krcstat
x$krdevthist
x$krdmmira
x$krdrsbrov
x$krfblog
x$krfgstat
x$krfsthrd
x$krsnissrt
x$krsoproc
x$krssms
x$krssrtt
x$krstalg
x$krstappstats
x$krstdest
x$krstdgc
x$krstpvrs
x$krvslv
x$krvslvpg
x$krvslvs
x$krvslvst
x$krvslvthrd
x$krvxdka
x$krvxdta
x$krvxispchk
x$krvxisplcr
x$krvxop
x$krvxsv
x$krvxthrd
x$krvxtx
x$krvxwarnv
x$ksacltab
x$ksast
x$ksbdd
x$ksbdp
x$ksbdpneeded
x$ksbft
x$ksbsrvdt
x$ksbtabact
x$ksbucpuwtm
x$ksdaf
x$ksdaft
x$ksdhng_cache_history
x$ksdhng_chains Hang analysis results, see $ORACLE_HOME/rdmbs/admin/hangdiag.sql
x$ksdhng_session_blockers
x$ksfdftyp
x$ksfdfunnm
x$ksfdftynm File types?
x$ksfdkll
x$ksfdsscloneinfo
x$ksfdstblk
x$ksfdstcg
x$ksfdstcmp
x$ksfdstfile
x$ksfdsthist
x$ksfdstll
x$ksfdstthist
x$ksfmcompl
x$ksfmelem
x$ksfmextelem
x$ksfmfile
x$ksfmfileext
x$ksfmiost
x$ksfmlib
x$ksfmsubelem
x$ksfqdvnt RMAN devices?
x$ksfqp Compare with the latch with the same name.
x$ksfvqst
x$ksfvsl
x$ksfvsta
x$ksimat
x$ksimav
x$ksimsi
x$ksimtsr
x$ksipcip
x$ksipcip_ci
x$ksipcip_kggpnp
x$ksipcip_osd
x$ksipc_info
x$ksipc_proc_stats
x$ksipc_skgsndomain
x$ksirestyp
x$ksirgd
x$ksirpinfo
x$ksi_reuse_stats
x$kskcdbplw
x$kskcgmetric
x$kskpdbmetric
x$kskplw
x$kskqdft
x$kskqvft
x$kslcs
x$ksleclass
x$ksled
x$kslei
x$kslemap
x$kslepx
x$ksles
x$kslhot
x$ksllclass
x$kslld Latch
x$kslltr
x$kslltr_children referenced in x$kqfdt
x$kslltr_osp referenced in x$kqfdt
x$kslltr_parent referenced in x$kqfdt
x$ksllw L(ist of) L(atches): W(here)
x$kslpo
x$kslscs
x$kslseshist
x$kslseshist_micro
x$kslsesout
x$kslwh
x$kslwsc
x$kslwsc_osp referenced in x$kqfdt
x$kslwt
x$ksmdd Segmented arrays?
x$ksmdut1
x$ksmfs
x$ksmfsv Variable names and their addresses in the SGA
x$ksmge
x$ksmhp
x$ksmjch
x$ksmjs
x$ksmlru
x$ksmls kernel service, memory large pool summary
x$ksmmem Allows to read the value of every byte in the SGA
x$ksmmgapid
x$ksmmgaseg
x$ksmnim
x$ksmns
x$ksmpdbcsd
x$ksmpgdp
x$ksmpgdst
x$ksmpgdsta
x$ksmpgst
x$ksmpp PGA heap
x$ksmsd Sizes of the four main components of the SGA
x$ksmsgmap
x$ksmsgmem
x$ksmsp SGA heap
x$ksmspr
x$ksmsp_dsnew
x$ksmsp_nwex
x$ksmss
x$ksmssinfo
x$ksmsst
x$ksmstrs
x$ksmup UGA heap
x$ksmupgastats
x$ksmxminfo
x$ksnsobj
x$ksnsresinfo
x$ksolsfts
x$ksolsstat
x$ksoltd
x$kso_prespawn_pool
x$kso_sched_delay_history
x$kspcs_cpu_stat
x$ksppcv Current session value of init parameter. Compare with x$ksppsv.
x$ksppcv2
x$ksppi (Init-) parameter names and description, including hidden parameters.
x$ksppo
x$ksppscv
x$ksppsv Current system value of init parameter. This object is selected from in v$system_parameter. Compare with x$ksppcv.
x$ksppsv2
x$ksprstv
x$ksprstv2
x$kspspfh
x$kspspfile
x$ksptch
x$kspvld_values
x$ksqdn
x$ksqeq
x$ksqeqtyp
x$ksqrs
x$ksqst
x$ksrcctx
x$ksrcdes
x$ksrchdl
x$ksrmpctx
x$ksrmsgdes
x$ksrmsgo
x$ksrpcios
x$kssquar
x$kssquar_reg
x$kssquar_sum
x$kstex
x$ksucf
x$ksuclndpcc
x$ksuclnproc
x$ksucpustat
x$ksugblnetstat Apparently a wrapper over the tcp_info struct.
x$ksugblnetstatawr
x$ksuinststat
x$ksull
x$ksulop
x$ksulv
x$ksumysta
x$ksunetstat
x$ksupdbses
x$ksupgp
x$ksupgs
x$ksupl
x$ksupr Kernel Service User Processes?
x$ksuprlat Latch holder?
x$ksurlmt
x$ksuru
x$ksusd Session statistics
x$ksuse Sessions
x$ksusecon
x$ksusecst
x$ksusesta
x$ksusex
x$ksusgif
x$ksusgsta
x$ksusio
x$ksusm
x$ksutm
x$ksuvmstat
x$ksuxsinst
x$kswsaftab
x$kswsastab
x$kswsclstab
x$kswscrssvctab
x$kswscrstab
x$kswsevtab
x$kswsinttab
x$kswsjpopertab
x$kswsjptab
x$ksxafa
x$ksxmcolst
x$ksxmme
x$ksxm_mae
x$ksxm_dft
x$ksxm_exp_stats
x$ksxm_zut
x$ksxpclient
x$ksxpia
x$ksxpif
x$ksxpping
x$ksxptesttbl
x$ksxp_stats
x$ksxrch
x$ksxrconq
x$ksxrmsg
x$ksxrrepq
x$ksxrsg
x$ktadm
x$ktatl
x$ktatrfil
x$ktatrfsl
x$ktcnclauses
x$ktcninband
x$ktcnqrow
x$ktcnquery
x$ktcnreg
x$ktcnregquery
x$ktcsp
x$ktcxb Transaction object
x$ktfbfe blocks(?) / bitmaps(?) of free extents?
x$ktfbhc Data files: number of blocks, max number of blocks etc.
x$ktfbnstat
x$ktfbue blocks(?) / bitmaps(?) of used extents?
x$ktfsan
x$ktfsbi
x$ktfsimstat
x$ktfsri
x$ktfstat
x$ktftbtxngraph
x$ktftbtxnmods
x$ktfthc
x$ktftme
x$ktifb
x$ktiff
x$ktifp
x$ktifv
x$ktmtxnchunk
x$ktmtxncrclone
x$ktmtxndelta
x$ktmtxnhead
x$ktprhist
x$ktprxrs
x$ktprxrt
x$ktrso
x$ktsimapool
x$ktsimau
x$ktsimxmemarea
x$ktsjproc
x$ktsjtask
x$ktsjtaskclass
x$ktskstat
x$ktslchunk
x$ktspgs_stat
x$ktspstat
x$ktsp_repair_list
x$ktsso
x$ktsspu
x$ktstfc
x$ktstssd
x$ktstusc
x$ktstusg
x$ktstuss
x$kttefinfo
x$kttets
x$kttvs Save undo for each tablespace (name in kttvsnm)
x$ktucus
x$ktugd
x$ktumascn
x$ktuqqry
x$kturd
x$kturhist
x$ktusmst
x$ktusmst2
x$ktusus
x$ktutst
x$ktuxche
x$ktuxe Kernel Transaction: Undo transaXtion Entry
x$kupva
x$kupvj
x$kvii
x$kvis Used to store information like db block size (select kvisval from x$kvis where kvistag = 'kcbbkl'). Not anymore?
x$kvit
x$kwddef
x$kwqbpmt
x$kwqdlstat
x$kwqitcx
x$kwqmnc
x$kwqmnjit
x$kwqmnsctx
x$kwqmntask
x$kwqmntaskstat
x$kwqpd
x$kwqps
x$kwqsi
x$kwrsnv
x$kwsbgaqpcstat
x$kwsbgqmnstat
x$kwsbjcsqjit
x$kwsbsmslvstat
x$kwscpjobstat
x$kwssubustats
x$kxdbio_stats
x$kxdcm_db
x$kxdcm_db_history
x$kxdcm_disk
x$kxdcm_disk_history
x$kxdcm_global
x$kxdcm_global_history
x$kxdcm_ioreason
x$kxdcm_ioreason_name
x$kxdcm_metric_desc
x$kxdcm_open_alerts
x$kxdrs
x$kxdspphysmp
x$kxfbbox
x$kxfpbs
x$kxfpcds
x$kxfpcms
x$kxfpcst
x$kxfpdp
x$kxfpig
x$kxfpns
x$kxfppft
x$kxfppig
x$kxfpreminstload
x$kxfpsds
x$kxfpsms
x$kxfpsst
x$kxfpys
x$kxfqsrow
x$kxfrsvchash
x$kxfsource
x$kxftask
x$kxsbd Related to bind variable data. Compare with value of kxsbbbfp in 10046 trace file
x$kxscc
x$kxsreplay
x$kxsreplaydate
x$kxsreplayguid
x$kxsreplaylob
x$kxsreplayseq
x$kxsreplaytime
x$kxttstecs
x$kxttstehs
x$kxttsteis
x$kxttstets Session private stats for GTTs. (TODO: See here).
x$kxtt_ptt
x$kywmcltab
x$kywmnf
x$kywmpcmn
x$kywmpcs
x$kywmpctab
x$kywmwrctab
x$kzahist
x$kzajobs
x$kzaloadjobs
x$kzaparams
x$kzats
x$kzckmcs
x$kzckmek
x$kzdos Operating system roles
x$kzdpsupsf
x$kzekmencwal
x$kzekmfvw
x$kzpopr
x$kzrtpd
x$kzspr
x$kzsro Granted role(?) in current session(?). (select obj# from sys.objauth$ where granteee# in (select kzsrorol from x$kzsrc))
x$kzsrpwfile
x$kzsrt
x$kzvdvclause
x$le Lock element: contains an entry for each PCM lock held for the buffer cache. x$le can be left outer joined to x$bh on le_addr.
x$lobsegstat
x$lobstat
x$lobstathist
x$lockdown
x$logbuf_readhist
x$logmnr_attrcol$
x$logmnr_attribute$
x$logmnr_callback
x$logmnr_cdef$
x$logmnr_clu$
x$logmnr_col$
x$logmnr_coltype$
x$logmnr_contents
x$logmnr_dictionary
x$logmnr_dictionary_load
x$logmnr_enc$
x$logmnr_encrypted_obj$
x$logmnr_encryption_profile$
x$logmnr_file$
x$logmnr_ind$
x$logmnr_indcompart$
x$logmnr_indpart$
x$logmnr_indsubpart$
x$logmnr_kopm$
x$logmnr_ktfbue
x$logmnr_latch
x$logmnr_lob$
x$logmnr_lobfrag$
x$logmnr_log
x$logmnr_logfile
x$logmnr_logs
x$logmnr_ntab$
x$logmnr_obj$
x$logmnr_opqtype$
x$logmnr_parameters
x$logmnr_partobj$
x$logmnr_process
x$logmnr_props$
x$logmnr_refcon$
x$logmnr_root$
x$logmnr_seg$
x$logmnr_session
x$logmnr_subcoltype$
x$logmnr_tab$
x$logmnr_tabcompart$
x$logmnr_tabpart$
x$logmnr_tabsubpart$
x$logmnr_ts$
x$logmnr_type$
x$logmnr_uet$
x$logmnr_undo$
x$logmnr_user$
x$memoptimize_write_area
x$messages
x$message_cache
x$mmon_action
x$mmon_autotask
x$mmon_tracking_debug
x$modact_length
x$msgbm
x$mutex_sleep
x$mutex_sleep_history
x$nfsclients
x$nfslocks
x$nfsopens
x$nls_parameters
x$nondursub
x$nondursub_lwm
x$nsv
x$object_policy_statistics
x$obj_bin_exceptions
x$oblnk$
x$oct
x$ofsmount
x$ofs_rw_latency_stats
x$ofs_rw_size_stats
x$ofs_stats
x$oparg
x$opdesc
x$operators
x$optim_calib_stats
x$option
x$opversion
x$orafn
x$persistent_publishers
x$persistent_queues
x$persistent_subscribers
x$policy_history
x$pqscanrate
x$prmsltyx
x$props Database properties. Base table for database_properties view. Compare with sys.props$.
x$qerfxtst
x$qesblstat
x$qesmmahist
x$qesmmapadv
x$qesmmiwh
x$qesmmiwt
x$qesmmsga
x$qesrcdep
x$qesrcdr
x$qesrcmem
x$qesrcmsg
x$qesrcobj Objects in the result cache.
x$qesrcrd
x$qesrcrr
x$qesrcsta
x$qesrstat
x$qesrstatall
x$qesxl
x$qksbgses
x$qksbgsys
x$qksceses
x$qkscesys
x$qkscr
x$qkscr_rsn
x$qksfgi_cursor
x$qksfm
x$qksfmdep
x$qksfmprt
x$qksht
x$qksmmwds
x$qksxa_reason
x$qosadvactiondef
x$qosadvfindingdef
x$qosadvrationaledef
x$qosadvrecdef
x$qosadvruledef
x$quiesce
x$rfafo
x$rfahist
x$rfmp
x$rfmte
x$rfob
x$rma_latch
x$ro_user_account
x$rpop_filestats
x$rule
x$rule_set
x$rxs_session_roles
x$shadow_datafile
x$skgxpia
x$skgxp_connection
x$skgxp_misc
x$skgxp_port
x$sql_shard
x$sql_testcases
x$targetrba
x$temporary_lob_refcnt
x$timezone_file
x$timezone_names
x$trace
x$trace_events
x$uganco
x$unflushed_dequeues
x$unified_audit_record_format
x$unified_audit_trail
x$version
x$vinst
x$xml_audit_trail
x$xplton
x$xpltoo
x$xsaggr
x$xsagop
x$xsawso
x$xslongops
x$xsobject
x$xsoqmehi
x$xsoqojhi
x$xsoqophi
x$xsoqoplu
x$xsoqsehi
x$xssinfo
x$xs_sessions
x$xs_session_ns_attributes
x$xs_session_roles
x$zasaxtab
x$zasaxtd1 referenced in x$kqfdt
x$zasaxtd2 referenced in x$kqfdt
x$zasaxtd3 referenced in x$kqfdt

TODO

x$kqlfsqce - optimizer environment?

select
   kqlfsqce_sqlid,
   kqlfsqce_chno,
   kqlfsqce_pname,
   kqlfsqce_pvalue,
   kqlfsqce_pnum,
   kqlfsqce_flags
from
  x$kqlfsqce  k;

Perl script to find x$ tables

#!/usr/bin/perl -w

use strict;

open my $ora , '<', $ENV{ORACLE_HOME} . "/bin/oracle.exe" or die 'could not open oracle.exe';
open my $xout, '>', 'x.out' or die;

my $l;
my $p = ' ' x 40;
my %x;

while (read ($ora, $l, 10000)) {
   $l = $p.$l;

   foreach ($l =~ /(x\$\w{3,})/g) {
      $x{$_}++;
   }

   $p = substr ($l,-40);
}

foreach (sort keys %x) {
   print $xout "$_\n";
}

TODO

select * from x$ksmsd;
select
   x$ksuse.ksuudsna,
   x$ksuse.ksuseunm,
   x$ksuse.ksusemnm,
   x$ksuse.ksusesvc,
   x$ksuse.ksusepesta,
   x$ksuse.*
from
   x$ksuse;

See also

The dynamic performance views query their data mainly from the dynamic performance (x$) tables
dbms_stats.gather_fixed_objects_stats
The SQL plan operator FIXED TABLE FULL
fixed_obj$
oradebug direct_access allows to dump the result of a query on a fixed table to a trace file.
ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

Links

Rodrigo Jorge's pkg_xdollar_search.
Frits Hoogland maintains a list of x$ table descriptions.

Index