Oracle 的 X$ 表之：x$kqfta 内核SQL固定表信息

在所有的 X$ 表中，有一个特殊的存在：X$KQFTA . KQF 在内核层属于 - K ernel S Q L F ixed ta bles/views management.

所以 KQFTA 的含义就是 内核 SQL 固定表信息 。我在之前latch 的一篇文章提到过这个结构。

通过查询这个结构，可以获得所有的 X$ 对象列表，这个视图中 KQFTANAM 是固有表名称。在 Oracle 12.2 中已经达到了 1289 个对象之多。

很多内部分析需要访问这些固定结构，其实我们日常使用的大量 v$ 视图都是在此之上创建出来的。

SQL> select * from v$version;

BANNER										     CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production		  0
PL/SQL Release 12.2.0.1.0 - Production							  0
CORE	12.2.0.1.0	Production								  0
TNS for Linux: Version 12.2.0.1.0 - Production						  0
NLSRTL Version 12.2.0.1.0 - Production							  0

SQL> select count(*) from x$kqfta;

  COUNT(*)
----------
      1289

SQL> desc x$kqfta;
 Name									 Null?	  Type
 ----------------------------------------------------------------------- -------- ------------------------------------------------
 ADDR										  RAW(8)
 INDX										  NUMBER
 INST_ID									  NUMBER
 CON_ID 									  NUMBER
 KQFTAOBJ									  NUMBER
 KQFTAVER									  NUMBER
 KQFTANAM									  VARCHAR2(128)
 KQFTATYP									  NUMBER
 KQFTAFLG									  NUMBER
 KQFTARSZ									  NUMBER
 KQFTACOC									  NUMBER

SQL> select KQFTANAM from x$kqfta;

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KQFTA
X$KQFVI
X$KQFVT
X$KQFDT
X$KQFCO
X$KQFOPT
X$KYWMPCTAB
X$KYWMWRCTAB
X$KYWMCLTAB
X$KYWMNF
X$KYWMPCMN

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSDAF
X$KSDAFT
X$KSLLTR
X$KSLHOT
X$KSLLCLASS
X$KSLECLASS
X$KSLEMAP
X$KSLLD
X$KSLED
X$KSLEPX
X$KSLCS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSLSCS
X$CON_KSLSCS
X$KSLES
X$KSLSESHIST_MICRO
X$CON_KSLSESHIST_MICRO
X$KSLSESHIST
X$KSLSESOUT
X$KSLEI
X$CON_KSLEI
X$KSLLW
X$KSLPO

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSLWSC
X$KSLWH
X$KSLWT
X$KSQEQTYP
X$KSQRS
X$KSQDN
X$KSQST
X$KSUINSTSTAT
X$KSUSE
X$KSUSEX
X$KSUPR

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSUPRLAT
X$KSURLMT
X$KSUSD
X$KSUSGSTA
X$CON_KSUSGSTA
X$KSUTM
X$KSUSGIF
X$KSUSESTA
X$KSUMYSTA
X$KSUSIO
X$KSUSECST

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSULOP
X$KSUPGP
X$KSUPGS
X$KSURU
X$KSUPL
X$KSUCF
X$KSULL
X$KSUCPUSTAT
X$KSUVMSTAT
X$KSUNETSTAT
X$KSUSM

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$MODACT_LENGTH
X$KSUPDBSES
X$KSIRESTYP
X$KSI_REUSE_STATS
X$KSIMSI
X$KSIMAV
X$KSIMAT
X$KSIMTSR
X$KSPTCH
X$KSMSD
X$KSMSS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSMNS
X$KSMNIM
X$KSMLS
X$KSMFS
X$KSMJS
X$KSMSTRS
X$KSMMEM
X$KSMFSV
X$KSMLRU
X$KGHLU
X$KSMSP

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSMSPR
X$KSMPP
X$KSMUP
X$KSMHP
X$KSMJCH
X$KSMSST
X$KSMSP_DSNEW
X$KSMSP_NWEX
X$KGLSIM
X$KGLJSIM
X$KGLMEM

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KGLJMEM
X$KSMSGMEM
X$KSMSGMAP
X$KSMPGST
X$KSMPGDST
X$KSMPGDP
X$KSMPGDSTA
X$KSMSSINFO
X$KSPPI
X$KSPPCV
X$KSPPSV

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSPRSTV
X$KSPPCV2
X$KSPPSV2
X$KSPRSTV2
X$KSPPSCV
X$KSPSPFILE
X$KSPSPFH
X$KSPVLD_VALUES
X$KSPPO
X$KSBDP
X$KSBDPNEEDED

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSBDD
X$MESSAGES
X$KSBFT
X$KSBSRVDT
X$KSBTABACT
X$KSAST
X$KSQEQ
X$TRACE
X$TRACE_EVENTS
X$KSTEX
X$NLS_PARAMETERS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSULV
X$TIMEZONE_NAMES
X$TIMEZONE_FILE
X$KSUXSINST
X$KSUSECON
X$KSRPCIOS
X$KSFVQST
X$KSFVSTA
X$KSFVSL
X$KSFDFTYP
X$KSFDSTCG

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSFDSTCMP
X$KSFDSTFILE
X$KSFDSTBLK
X$KSFDSTHIST
X$KSFDSTTHIST
X$KSFDSTLL
X$KSFDKLL
X$DNFS_STATS
X$DNFS_HIST
X$DNFS_SERVERS
X$DNFS_META

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DNFS_FILES
X$DNFS_CHANNELS
X$KSFQP
X$KSFQDVNT
X$OFSMOUNT
X$OFS_STATS
X$OFS_RW_LATENCY_STATS
X$OFS_RW_SIZE_STATS
X$KGSKTE
X$KGSKTO
X$KGSKCP

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KGSKPP
X$KGSKASP
X$KGSKDOPP
X$KGSKQUEP
X$KGSKVFT
X$KGSKCFT
X$KGSKNCFT
X$KGSKPFT
X$KGSKPDBFT
X$KSKPLW
X$KSKCDBPLW

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KGSKSCS
X$KGSKPDBHISTFT
X$KSKCGMETRIC
X$KSKPDBMETRIC
X$KGSKMEMINFO
X$KSKQVFT
X$KSKQDFT
X$KSRCDES
X$KSRCCTX
X$KSRMSGDES
X$KSRMPCTX

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSRCHDL
X$KSRMSGO
X$KSIPCIP
X$KSIPCIP_CI
X$KSIPCIP_KGGPNP
X$KSIPCIP_OSD
X$IPCOR_TOPO_NDEV
X$KSIPC_SKGSNDOMAIN
X$IPCOR_TOPO_DOMAIN
X$KSXPPING
X$KSXPCLIENT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSXPIF
X$KSXPIA
X$SKGXPIA
X$KSMDD
X$KSMDUT1
X$KSMGE
X$KSXRMSG
X$KSXRREPQ
X$KSXRCONQ
X$KSXRCH
X$KSXRSG

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSFMLIB
X$KSFMIOST
X$KSFMFILE
X$KSFMFILEEXT
X$KSFMSUBELEM
X$KSFMELEM
X$KSFMEXTELEM
X$KSFMCOMPL
X$KSOLSSTAT
X$KSOLSFTS
X$KSWSCLSTAB

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSWSEVTAB
X$KSWSASTAB
X$KSWSAFTAB
X$KSWSCRSTAB
X$KSWSCRSSVCTAB
X$KSWSINTTAB
X$KSWSJPTAB
X$GIMSA
X$KSO_SCHED_DELAY_HISTORY
X$KSO_PRESPAWN_POOL
X$KSIRGD

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSIRPINFO
X$KSDHNG_CHAINS
X$KSDHNG_SESSION_BLOCKERS
X$KSDHNG_CACHE_HISTORY
X$KSUCLNDPCC
X$KSUCLNPROC
X$KBRPSTAT
X$KSOLTD
X$KSFDSSCLONEINFO
X$KQPXINV
X$RMA_LATCH

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSACLTAB
X$KSSQUAR
X$KSMXMINFO
X$KJZNHANGS
X$KJZNHANGSES
X$KJZNWLMPCRANK
X$KJZNRSLNRC
X$KJZNHNGSTATS
X$KJZNCBHANGS
X$KJZNHNGMGRSTS
X$KJZNHMLSI

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KJREQFP
X$KJRTBCFP
X$KJR_CHUNK_STATS
X$KJR_FREEABLE_CHUNKS
X$KJLEQFP
X$KJISFT
X$KJILFT
X$KJICVT
X$KJILKFT
X$KJIRFT
X$KJITRFT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KJIDT
X$KJDDDEADLOCKS
X$KJDDDEADLOCKSES
X$KJCISOT
X$KJCISPT
X$KJSCAPKAT
X$KJSCASVCAT
X$KJXM
X$KJCTFS
X$KJCTFR
X$KJCTFRI

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KJBR
X$KJBRFX
X$KJBL
X$KJBLFX
X$KJXGNA_STATS
X$KJMSDP
X$KJMDDP
X$KJDRHV
X$KJDRPCMHV
X$KJDRPCMPF
X$KJDRMAFNSTATS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KJDRMREADMOSTLYSTATS
X$KJDRMHVSTATS
X$KJDRMREQ
X$DRM_HISTORY
X$DRM_HISTORY_STATS
X$DRM_WAIT_STATS
X$KJPNPX
X$KJFMHBACL
X$KJZSIWTEVT
X$GCRMETRICS
X$GCRACTIONS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$GCRSTATUS
X$GCRLOG
X$KJAC_ID
X$KJAC_MY_ID
X$KJAC_CONFIG
X$KJKMKGA
X$KJKMREQ
X$KJKMLOCK
X$KJBFPBR
X$KJPMPRC
X$KMGSCT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KMGSTFR
X$KMGSOP
X$KMGSBSADV
X$KMGSBSMEMADV
X$KCCCF
X$KCCRS
X$KCCDI
X$KCCDI2
X$KCCRT
X$KCCTIR
X$KCCLE

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KCCSL
X$KCCFE
X$KCCTF
X$KCCFN
X$KCCTS
X$KCCTKH
X$KCCRM
X$KCCLH
X$KCCOR
X$KCCAL
X$KCCRL

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KCCBS
X$KCCBP
X$KCCBF
X$KCCBL
X$KCCDC
X$KCCFC
X$KCCCC
X$KCCDL
X$KCCPD
X$KCCPA
X$KCCBI

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KCCIC
X$KCCRDI
X$KCCIRT
X$KCCAGF
X$KCCFLE
X$KCCRSP
X$KCCNRS
X$KCCRSR
X$KCCDFHIST
X$KCCBLKCOR
X$KCCACM

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KCCPDB
X$KCCADFC
X$KCCPIC
X$KCBWDS
X$KCBWBPD
X$KCBBHS
X$KCBBES
X$ACTIVECKPT
X$CKPTBUF
X$KCBKWRL
X$KCBKPFS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$BH
X$KCBBF
X$KCBWH
X$KCBSW
X$KCBUWHY
X$KCBWAIT
X$KCBFWAIT
X$KCBTEK
X$KCBDBK
X$KCBMKID
X$KCBPRFH

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KCBPDBRM
X$KCBPINTIME
X$KCBDWS
X$KCBDWOBJ
X$KCBFCIO
X$KCBINSTVIEW
X$KCBSC
X$KCBSH
X$KCBSDS
X$KCBMMAV
X$KCBOBH

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KCBOQH
X$KCMSCN
X$KCRMF
X$KCRMT
X$KCRMX
X$KRSSMS
X$KRSTAPPSTATS
X$KRSTDGC
X$KRSTDEST
X$KRSTPVRS
X$KRSTALG

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KCRRDSTAT
X$KCRRARCH
X$KRFSTHRD
X$KRSOPROC
X$KRSSRTT
X$KCRRLNS
X$KCRRNHG
X$KCRRASTATS
X$KCRFWS
X$LOGBUF_READHIST
X$KCRFSTRAND

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KCRFDEBUG
X$KCRFX
X$KCFIOHIST
X$KCFIOFCHIST
X$KCFIO
X$KCFTIO
X$KCLFX
X$LE
X$KCLLS
X$KCLCRST
X$KCLPINGPIN

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KCLPINGWEV
X$INSTANCE_CACHE_TRANSFER
X$KCLCURST
X$KCLRCVST
X$OBJECT_POLICY_STATISTICS
X$POLICY_HISTORY
X$KCBLDRHIST
X$KCBLSC
X$KCCCP
X$ESTIMATED_MTTR
X$KCTLAX

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KCTICW
X$TARGETRBA
X$KCVFH
X$KCVFHTMP
X$KCVDF
X$KRBPHEAD
X$KRBPDIR
X$KRBPDATA
X$KRBPSPARSE
X$KRBAFF
X$KRBMSFT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KRBMRST
X$KRBMROT
X$KRBMCA
X$KRBABRSTAT
X$KRBPPBTBL
X$KRBPPBCTX
X$LOGMNR_LOGS
X$LOGMNR_PARAMETERS
X$LOGMNR_DICTIONARY
X$LOGMNR_CONTENTS
X$LOGMNR_ROOT$

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$LOGMNR_COL$
X$LOGMNR_TAB$
X$LOGMNR_OBJ$
X$LOGMNR_TS$
X$LOGMNR_IND$
X$LOGMNR_USER$
X$LOGMNR_TABPART$
X$LOGMNR_TABSUBPART$
X$LOGMNR_TABCOMPART$
X$LOGMNR_INDPART$
X$LOGMNR_TYPE$

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$LOGMNR_COLTYPE$
X$LOGMNR_ATTRIBUTE$
X$LOGMNR_ENCRYPTION_PROFILE$
X$LOGMNR_ENCRYPTED_OBJ$
X$KRVXDKA
X$KRVXDTA
X$LOGMNR_ENC$
X$LOGMNR_CLU$
X$LOGMNR_FILE$
X$LOGMNR_INDSUBPART$
X$LOGMNR_LOB$

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$LOGMNR_LOBFRAG$
X$LOGMNR_SEG$
X$LOGMNR_UET$
X$LOGMNR_KTFBUE
X$LOGMNR_UNDO$
X$LOGMNR_ATTRCOL$
X$LOGMNR_INDCOMPART$
X$LOGMNR_KOPM$
X$LOGMNR_NTAB$
X$LOGMNR_OPQTYPE$
X$LOGMNR_PARTOBJ$

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$LOGMNR_PROPS$
X$LOGMNR_REFCON$
X$LOGMNR_SUBCOLTYPE$
X$LOGMNR_CDEF$
X$LOGMNR_SESSION
X$LOGMNR_LATCH
X$LOGMNR_DICTIONARY_LOAD
X$LOGMNR_LOGFILE
X$LOGMNR_PROCESS
X$KRVXTX
X$LOGMNR_REGION

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$LOGMNR_CALLBACK
X$KRVXSV
X$KRVXOP
X$KRVXTHRD
X$LOGMNR_LOG
X$KRVXWARNV
X$KRVXISPCHK
X$KRVXISPLCR
X$KCPXPL
X$KCPDBINC
X$KRVSLV

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KRVSLVS
X$KRVSLVPG
X$KRVSLVST
X$KRVSLVTHRD
X$DGLPARAM
X$DGLXDAT
X$QUIESCE
X$KRDRSBROV
X$KRDEVTHIST
X$KRCFH
X$KRCEXT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KRCCDE
X$KRCCDS
X$KRCCDR
X$KRCGFE
X$KRCFDE
X$KRCFBH
X$KRCBIT
X$KRCSTAT
X$KRASGA
X$KRFBLOG
X$KRFGSTAT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KRBZA
X$KCFISTSA
X$KCFISOSS
X$KCFISOSSN
X$KCFISOSSL
X$KCFISOSST
X$KCFISOSSC
X$KCFISOSSAWR
X$KCFISCAP
X$KCFISTCAP
X$KRDMMIRA

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$SHADOW_DATAFILE
X$KTADM
X$KTATRFIL
X$KTATRFSL
X$KTATL
X$KTCXB
X$KTCSP
X$KTUGD
X$KTURD
X$KTUXE
X$KTUSMST

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KTUSMST2
X$KTUSUS
X$KTUCUS
X$KTUTST
X$KTUXCHE
X$KTURHIST
X$KTPRXRS
X$KTPRXRT
X$KTPRHIST
X$KTRSO
X$KTIFP

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KTIFF
X$KTIFB
X$KTIFV
X$KTUQQRY
X$KTCNREG
X$KTUMASCN
X$KTFTBTXNMODS
X$KTFTBTXNGRAPH
X$KTCNQUERY
X$KTCNREGQUERY
X$KTCNCLAUSES

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KTCNINBAND
X$HEATMAPSEGMENT
X$HEATMAPSEGMENT1
X$KTMTXNHEAD
X$KTMTXNCHUNK
X$KTMTXNCRCLONE
X$KTSTSSD
X$KTSSO
X$KTSTFC
X$KTSTUSC
X$KTSTUSS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KTSTUSG
X$KTSPSTAT
X$KTSKSTAT
X$KTTEFINFO
X$KTSSPU
X$LOBSTATHIST
X$LOBSTAT
X$LOBSEGSTAT
X$KTSLCHUNK
X$KTTVS
X$KTTETS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KTFBNSTAT
X$KTFBFE
X$KTFBHC
X$KTFBUE
X$KTFTHC
X$KTFTME
X$KTSJTASK
X$KTSJPROC
X$KTSJTASKCLASS
X$KTFSTAT
X$KTFSIMSTAT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KTFSAN
X$KTFSBI
X$KTFSRI
X$IMCTBSEXTMAP
X$IMCSEGEXTMAP
X$KTSIMAU
X$KTSIMXMEMAREA
X$KTSIMAPOOL
X$IMCSEGMENTS
X$KTSPGS_STAT
X$KTSP_REPAIR_LIST

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KDNSSF
X$KDXST
X$KDXHS
X$KDLT
X$KDLU_STAT
X$KDZCOLCL
X$KDMIMCHEAD
X$KDMIMEUHEAD
X$KDMIMCCOL
X$KDMUFASTSTARTAREA
X$KDMUSEGDICT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KDMUSEGDICTVER
X$KDMUSEGDICTSO
X$KDMUSEGDICTPMAP
X$KDMIMEUCOL
X$KDMADOTASKS
X$KDMADOTASKDETAILS
X$KDMADOELEMENTS
X$KD_COLUMN_STATISTICS
X$KQRST
X$KQRPD
X$KQRSD

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KQRFP
X$KQRFS
X$KQDPG
X$KGLOB
X$KGLOBXML
X$KGLLK
X$KGLPN
X$KGLST
X$KGLAU
X$KGLSN
X$KGLTR

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KGLXS
X$KGLRD
X$KGLDP
X$KGLNA
X$KGLNA1
X$KKSBV
X$KKSSRD
X$KGSCC
X$KQLSET
X$KGICS
X$KQLFXPL

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KQLFSQCE
X$KQLFBC
X$MUTEX_SLEEP_HISTORY
X$MUTEX_SLEEP
X$DIR
X$KKSPCIB
X$VERSION
X$KQFSZ
X$KQFP
X$DUAL
X$KKKICR

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KKSSQLSTAT
X$KKAEET
X$KKCNRSTAT
X$PROPS
X$KZDOS
X$KZSRO
X$KZSPR
X$KZSRT
X$KZSRPWFILE
X$RO_USER_ACCOUNT
X$KZRTPD

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$CONTEXT
X$KZEKMFVW
X$KZEKMENCWAL
X$KZCKMEK
X$KZCKMCS
X$KZVDVCLAUSE
X$GLOBALCONTEXT
X$XML_AUDIT_TRAIL
X$KZPOPR
X$XS_SESSION_NS_ATTRIBUTES
X$RXS_SESSION_ROLES

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$XS_SESSION_ROLES
X$XS_SESSIONS
X$ZASAXTAB
X$AUD_OBJ_ACTIONS
X$AUD_XS_ACTIONS
X$AUD_OLS_ACTIONS
X$AUD_DV_OBJ_EVENTS
X$AUD_DP_ACTIONS
X$AUD_DPAPI_ACTIONS
X$UNIFIED_AUDIT_RECORD_FORMAT
X$UNIFIED_AUDIT_TRAIL

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KZAHIST
X$KZAJOBS
X$KZAPARAMS
X$KZATS
X$KZDPSUPSF
X$K2GTE2
X$K2GTE
X$KMMSI
X$KMMDI
X$KMMSG
X$KMMDP

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KMMRD
X$KMMSAS
X$KMMHST
X$KMMNV
X$KMCQS
X$KMCVC
X$KMPCP
X$KMPCSO
X$KMPDH
X$KMPCMON
X$KMPSRV

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KKSAI
X$KKSCS
X$JOXFT
X$JOXFM
X$KXTTSTETS
X$KXTTSTECS
X$KXTTSTEHS
X$KXTTSTEIS
X$OPTIM_CALIB_STATS
X$KKSXSQLSTAT
X$QOSADVRULEDEF

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$QOSADVFINDINGDEF
X$QOSADVRECDEF
X$QOSADVRATIONALEDEF
X$QOSADVACTIONDEF
X$QKSFGI_CURSOR
X$KXSCC
X$KXSBD
X$KXSREPLAY
X$KXSREPLAYTIME
X$KXSREPLAYDATE
X$KXSREPLAYGUID

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KXSREPLAYSEQ
X$KXSREPLAYLOB
X$KXFBBOX
X$KXFPCST
X$KXFPCMS
X$KXFPSMS
X$KXFPCDS
X$KXFPSDS
X$KXFPDP
X$KXFPSST
X$KXFPYS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KXFPNS
X$KXFPPIG
X$KXFPIG
X$KXFPREMINSTLOAD
X$KXFPPFT
X$KXFSOURCE
X$KXFPBS
X$PQSCANRATE
X$KXFQSROW
X$KXFRSVCHASH
X$KSXM_DFT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSXM_ZUT
X$KSXM_EXP_STATS
X$KSXMME
X$KSXAFA
X$QESMMSGA
X$QESMMIWT
X$QESMMIWH
X$QKSMMWDS
X$QESMMAHIST
X$QESMMAPADV
X$QESRSTAT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$QESRSTATALL
X$QKSCESYS
X$QKSCESES
X$KAUVRSTAT
X$QESBLSTAT
X$QKSBGSYS
X$QKSBGSES
X$QKSFM
X$QKSFMPRT
X$QKSFMDEP
X$QKSHT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$QESRCSTA
X$QESRCOBJ
X$QESRCMEM
X$QESRCDEP
X$QESRCMSG
X$QESRCDR
X$QESRCRD
X$QESRCRR
X$KKOCS_HISTOGRAM
X$KKOCS_SELECTIVITY
X$KKOCS_STATISTICS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$XPLTON
X$XPLTOO
X$KXFTASK
X$KKOAR_HINT
X$QKSCR
X$QKSCR_RSN
X$QKSXA_REASON
X$QESXL
X$KLPT
X$KLCIE
X$KVII

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KVIS
X$KVIT
X$KUPVJ
X$KUPVA
X$KNSTACR
X$KNSTASL
X$KNSTRPP
X$KNSTANR
X$KNSTMVR
X$KNSTORD
X$KNSTCAP

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KNSTCAPS
X$KNSTRQU
X$KNGFL
X$KNGFLE
X$KNSTTXN
X$KNSTMT
X$KNSTXSTS
X$KNSTCAPCACHE
X$KNSTOGGC
X$KNSTSESS
X$KNSTPSTS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KNLAROW
X$KNLASG
X$TEMPORARY_LOB_REFCNT
X$ABSTRACT_LOB
X$KOCST
X$UGANCO
X$PRMSLTYX
X$OPTION
X$KPOQSTA
X$KPONESTAT
X$KPONJSTAT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KPONDCONSTAT
X$KPONDESTAT
X$KKCNEREG
X$KKCNEREGSTAT
X$KWDDEF
X$OPERATORS
X$OPVERSION
X$OPDESC
X$OPARG
X$KPPLCC_INFO
X$KPPLCC_STATS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KPPLCP_STATS
X$KPPLCONN_INFO
X$QERFXTST
X$KWQITCX
X$KWQPS
X$KWQPD
X$KWQSI
X$PERSISTENT_QUEUES
X$PERSISTENT_SUBSCRIBERS
X$PERSISTENT_PUBLISHERS
X$KWRSNV

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$RULE_SET
X$RULE
X$IEE
X$IEE_ORPIECE
X$IEE_CONDITION
X$BUFFERED_QUEUES
X$BUFFERED_SUBSCRIBERS
X$BUFFERED_PUBLISHERS
X$BUFFER2
X$BUFFER
X$KWQBPMT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KWQMNC
X$KWQMNSCTX
X$KWQMNTASK
X$KWQMNTASKSTAT
X$KWQMNJIT
X$KWQDLSTAT
X$UNFLUSHED_DEQUEUES
X$MESSAGE_CACHE
X$MSGBM
X$AQ_SUBSCRIBER_LOAD
X$AQ_SUBTRANS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$AQ_REMOTE_DEQAFF
X$KWSCPJOBSTAT
X$KWSBGAQPCSTAT
X$KWSBGQMNSTAT
X$KWSBSMSLVSTAT
X$KWSBJCSQJIT
X$NONDURSUB
X$NONDURSUB_LWM
X$BMAPNONDURSUB
X$KWSSUBUSTATS
X$DURABLE_SHARDED_SUBS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$AQ_MESSAGE_CACHE_ADVICE
X$AQ_OPT_STATS
X$AQ_OPT_CACHED_SUBSHARD
X$AQ_OPT_UNCACHED_SUBSHARD
X$AQ_OPT_INACTIVE_SUBSHARD
X$HS_SESSION
X$HOFP
X$NFSCLIENTS
X$NFSOPENS
X$NFSLOCKS
X$RFMP

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$RFMTE
X$VINST
X$DRC
X$NSV
X$RFAHIST
X$RFAFO
X$RFOB
X$XSAGGR
X$XSSINFO
X$XSAGOP
X$XSOBJECT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$XSLONGOPS
X$XSOQSEHI
X$XSOQOJHI
X$XSOQOPHI
X$XSOQMEHI
X$XSOQOPLU
X$XSAWSO
X$KFALS
X$KFCBH
X$KFCCE
X$KFBH

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KFCSTAT
X$KFCSGA
X$KFDSK
X$KFDSK_STAT
X$KFDAT
X$KFDFS
X$KFDDD
X$KFDSK_SPARSE
X$KFDSK_SPARSE_STAT
X$KFDAP
X$KFDXEXT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KFGRP
X$KFGRP_STAT
X$KFGRP_SPARSE
X$KFGMG
X$KFGBRB
X$KFGBRW
X$KFGBRS
X$KFGBRC
X$KFGXP
X$KFKID
X$KFKLIB

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KFKLSOD
X$KFMDGRP
X$KFNCL
X$KFNCWCL
X$KFNRCL
X$KFNSDSKIOST
X$KFNDIOSPRS
X$KFTMTA
X$KFFIL
X$KFFXP
X$KFFOF

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KFFIL_SPARSE
X$KFRC
X$KFIAS_CLNT
X$KFIAS_PROC
X$KFIAS_FILE
X$KFDPARTNER
X$KFCLLE
X$KFENV
X$KFIPCOMPAT
X$KFDSR
X$KFDSD

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KFVOL
X$KFVOLSTAT
X$KFVACFS
X$KFVACFSV
X$KFVACFSS
X$KFVACFSTAG
X$KFVACFSREALM
X$KFVACFSENCR
X$KFVACFSRULE
X$KFVACFSREALMS
X$KFVACFSREALMUSER

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KFVACFSREALMGROUP
X$KFVACFSREALMFILTER
X$KFVACFSRULESET
X$KFVACFSRULESETRULE
X$KFVACFSCMDRULE
X$KFVACFSADMIN
X$KFVACFSREPL
X$KFVACFSREPLTAG
X$KFZUDR
X$KFZGDR
X$KFZUAGR

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KFZPBLK
X$KFFSCRUB
X$KFQG
X$KFFG
X$KFFGPT
X$KFFGF
X$KFBF
X$ORAFN
X$OCT
X$KELTOSD
X$KELTSD

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KELTGSD
X$KEWEFXT
X$KEWECLS
X$KEWESMS
X$KEWESMAS
X$KEWEPCS
X$KEWRTB
X$KEWRTB_ALL
X$KEWRSTGTB
X$KEWXOCF
X$KEWX_SEGMENTS

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KEWX_LOBS
X$KEWRSQLIDTAB
X$KEWRTSQLPLAN
X$KEWRTOPTENV
X$KEWRSQLCRIT
X$KEWRATTRNEW
X$KEWRATTRSTALE
X$KEWRTSQLTEXT
X$KEWRIMSEGSTAT
X$KEWRTSEGSTAT
X$KEWRIPSL

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KEWPDBIX
X$KEWPDBINSNAP
X$KEWCATPDBINSNAP
X$KEWRSQLSUM
X$KEWRCONIDLOOKUP
X$KEWRCACHE
X$ASH
X$KEWASH
X$KEWAM
X$KEAOBJT
X$KEACMDN

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KEAFDGN
X$MMON_ACTION
X$MMON_TRACKING_DEBUG
X$KEWSSMAP
X$KEWSSYSV
X$CON_KEWSSYSV
X$KEWSSESV
X$KEWSSVCV
X$KEWMRWMV
X$KEWMDRMV
X$CON_KEWMDRMV

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KEWMSEMV
X$KEWMSVCMV
X$KEWMFLMV
X$KEWMIOFMV
X$KEWMRMGMV
X$KEWMRMPDBMV
X$KEWMWCRMV
X$KEWMEVMV
X$KEWMWPCMV
X$KEWMSRGMV
X$KEWMCHKMV

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KEWMRSM
X$KEWMDSM
X$KEWMGSM
X$KEWMAFMV
X$KEWMSMDV
X$CON_KEWMSMDV
X$KELRTD
X$KELRXMR
X$KELRSGA
X$KEHR
X$KEHR_CHILD

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KEHRP
X$KEHF
X$KEHSQT
X$KEHEVTMAP
X$KEHECLMAP
X$KEHSYSMAP
X$KEHOSMAP
X$KEHTIMMAP
X$KEHPRMMAP
X$KESSPAMET
X$KESPLAN

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KETTG
X$KETOP
X$KETCL
X$KECPDENTRY
X$KECPRT
X$KECPTC
X$KEXSVUS
X$KEXSVFU
X$KESWXMON
X$KESWXMON_PLAN
X$KESWXMON_STATNAME

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KEOMNMON_SESSTAT
X$KEOMM_DBOP_LIST
X$KERPIREPREQ
X$KERPISTATS
X$KEHETSX
X$KEUMTB
X$KEUMTOPTB
X$KEUMREGTB
X$KEUMLINKTB
X$KEUMSVCTB
X$KEIUT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KEIUT_INFO
X$DBREPLAY_PATCH_INFO
X$KEC_COMPONENT_TIMING
X$JSKJOBQ
X$JSKSLV
X$JSKMIMRT
X$JSKMIMMD
X$DBGRICX
X$DBGRIPX
X$DBGRIKX
X$DBGRIFX

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DBGDIREXT
X$DBGALERTEXT
X$DBGLOGEXT
X$DBKFDG
X$DBKRECO
X$DBKFSET
X$DBKRUN
X$DBKINFO
X$DBKH_CHECK
X$DBKH_CHECK_PARAM
X$DIAG_INFO

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$IR_WORKING_FAILURE_SET
X$IR_WORKING_REPAIR_SET
X$IR_REPAIR_OPTION
X$IR_MANUAL_OPTION
X$IR_REPAIR_STEP
X$IR_WF_PARAM
X$IR_WR_PARAM
X$IR_RS_PARAM
X$DRA_FAILURE
X$DRA_FAILURE_PARAM
X$DRA_REPAIR

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DRA_REPAIR_PARAM
X$DRA_FAILURE_REPAIR
X$DRA_FAILURE_CHECK
X$DRA_FAILURE_CHECK_MAP
X$DRA_FAILURE_PARENT_MAP
X$DRA_FAILURE_REPAIR_MAP
X$DBKINCMETCFG
X$DBKINCMETSUMMARY
X$DBKINCMETINFO
X$DBKEFEFC
X$DBKEFAFC

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DBKEFIEFC
X$DBKEFDEAFC
X$DBKECE
X$DBGTFLIST
X$DBGATFLIST
X$DBGTFVIEW
X$DBGTFSQLT
X$DBGTFOPTT
X$DBGTFSSQLT
X$DBGTFSOPTT
X$CELL_NAME

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KXDBIO_STATS
X$KXDRS
X$KXDCM_GLOBAL
X$KXDCM_GLOBAL_HISTORY
X$KXDCM_DISK
X$KXDCM_DISK_HISTORY
X$KXDCM_IOREASON
X$KXDCM_METRIC_DESC
X$KXDCM_IOREASON_NAME
X$KXDCM_DB
X$KXDCM_DB_HISTORY

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KXDCM_OPEN_ALERTS
X$KXDSPPHYSMP
X$CON
X$CDBVW$
X$COMVW$
X$OBLNK$
X$KPDBVPROXY
X$GSMREGIONS
X$KSIPC_PROC_STATS
X$KSIPC_INFO
X$KSXPTESTTBL

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$KSXP_STATS
X$SKGXP_PORT
X$SKGXP_CONNECTION
X$SKGXP_MISC
X$KTCNQROW
X$KQFTVRTTST0
X$DIAG_ADR_CONTROL
X$DIAG_ADR_INVALIDATION
X$DIAG_INCIDENT
X$DIAG_PROBLEM
X$DIAG_INCCKEY

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DIAG_INCIDENT_FILE
X$DIAG_SWEEPERR
X$DIAG_PICKLEERR
X$DIAG_VIEW
X$DIAG_VIEWCOL
X$DIAG_HM_RUN
X$DIAG_HM_FINDING
X$DIAG_HM_RECOMMENDATION
X$DIAG_HM_FDG_SET
X$DIAG_HM_INFO
X$DIAG_HM_MESSAGE

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DIAG_DDE_USER_ACTION_DEF
X$DIAG_DDE_USR_ACT_PARAM_DEF
X$DIAG_DDE_USER_ACTION
X$DIAG_DDE_USR_ACT_PARAM
X$DIAG_DDE_USR_INC_TYPE
X$DIAG_DDE_USR_INC_ACT_MAP
X$DIAG_IPS_PACKAGE
X$DIAG_IPS_PACKAGE_INCIDENT
X$DIAG_IPS_PACKAGE_FILE
X$DIAG_IPS_FILE_METADATA
X$DIAG_IPS_FILE_COPY_LOG

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DIAG_IPS_PACKAGE_HISTORY
X$DIAG_IPS_PKG_UNPACK_HIST
X$DIAG_IPS_REMOTE_PACKAGE
X$DIAG_IPS_CONFIGURATION
X$DIAG_IPS_PROGRESS_LOG
X$DIAG_INC_METER_SUMMARY
X$DIAG_INC_METER_INFO
X$DIAG_INC_METER_CONFIG
X$DIAG_INC_METER_IMPT_DEF
X$DIAG_INC_METER_PK_IMPTS
X$DIAG_DIR_EXT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DIAG_LOG_EXT
X$DIAG_ALERT_EXT
X$DIAG_RELMD_EXT
X$DIAG_EM_USER_ACTIVITY
X$DIAG_EM_DIAG_JOB
X$DIAG_EM_TARGET_INFO
X$DIAG_AMS_XACTION
X$DIAG_DFW_CONFIG_CAPTURE
X$DIAG_DFW_CONFIG_ITEM
X$DIAG_DFW_PATCH_CAPTURE
X$DIAG_DFW_PATCH_ITEM

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DIAG_DFW_PURGE
X$DIAG_DFW_PURGE_ITEM
X$DIAG_ADR_CONTROL_AUX
X$DIAG_PDB_PROBLEM
X$DIAG_PDB_SPACE_MGMT
X$DIAG_VSHOWINCB
X$DIAG_VSHOWINCB_I
X$DIAG_V_INCFCOUNT
X$DIAG_V_NFCINC
X$DIAG_VSHOWCATVIEW
X$DIAG_VINCIDENT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DIAG_VINC_METER_INFO
X$DIAG_VIPS_FILE_METADATA
X$DIAG_VIPS_PKG_FILE
X$DIAG_VIPS_PACKAGE_FILE
X$DIAG_VIPS_PACKAGE_HISTORY
X$DIAG_VIPS_FILE_COPY_LOG
X$DIAG_VIPS_PACKAGE_SIZE
X$DIAG_VIPS_PKG_INC_DTL1
X$DIAG_VIPS_PKG_INC_DTL
X$DIAG_VINCIDENT_FILE
X$DIAG_V_INCCOUNT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DIAG_V_IPSPRBCNT1
X$DIAG_V_IPSPRBCNT
X$DIAG_VPROBLEM_LASTINC
X$DIAG_VPROBLEM_INT
X$DIAG_VEM_USER_ACTLOG
X$DIAG_VEM_USER_ACTLOG1
X$DIAG_VPROBLEM1
X$DIAG_VPROBLEM2
X$DIAG_V_INC_METER_INFO_PROB
X$DIAG_VPROBLEM
X$DIAG_VPROBLEM_BUCKET1

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DIAG_VPROBLEM_BUCKET
X$DIAG_VPROBLEM_BUCKET_COUNT
X$DIAG_VHM_RUN
X$DIAG_DIAGV_INCIDENT
X$DIAG_VIPS_PACKAGE_MAIN_INT
X$DIAG_VIPS_PKG_MAIN_PROBLEM
X$DIAG_V_ACTINC
X$DIAG_V_ACTPROB
X$DIAG_V_SWPERRCOUNT
X$DIAG_VIPS_PKG_INC_CAND
X$DIAG_VNOT_EXIST_INCIDENT

KQFTANAM
--------------------------------------------------------------------------------------------------------------------------------
X$DIAG_VPDB_PROBLEM
X$DIAG_VTEST_EXISTS

1289 rows selected

历史上的今天...

>> 2010-09-16 文章:

Oracle PSU （Patch Set Update） 笔记

>> 2009-09-16 文章:

SUN + Oracle推出Exadata 2 终止与HP的合作

CBO的魔术 - 一个错误的索引选择会带来的后果

>> 2008-09-16 文章:

《深入浅出Oracle》被某大学选为教材

>> 2007-09-16 文章:

结束IT168《循序渐进Oracle》技术交流会

>> 2005-09-16 文章:

Tom's New book has landed

>> 2004-09-16 文章:

关于Oracle9i的Peeking of User-Defined Bind Variables

By eygle on 2018-09-16 23:37 |Comments (0) |Internal | 3316 |