前言
最早从 Yong Huang 那里看到关于比较详细的X$表的介绍，后来陆续从其他Oracle专家那里得到了不少信息。在Steve Adams 的书中对X$表多有提及，而且他的站点也是个资源比较丰富的地方。不过在中文Oracle技术社区很少能看到一份比较完备的介绍X$的文档。这算是整理这篇文档的一个起因吧。
Oracle 数据库引擎是个复杂无比的系统，随着每个新版本的推出，Oracle都会有不少新功能新特性加入其中，越发变得复杂。从X$表的数量上可见一斑:
SELECT NAME x$table_name FROM v$fixed_table WHERE NAME LIKE 'X$%' ORDER BY NAME;
V$fixed_table中可以查到所有的X$TABLE的名字。其值等于：X$KQFTA+X$KQFDT这两个表中X$Table的数量。也可以通过 Unix 的 strings 命令抽取 oracle 命令里的 X$ 表的信息。
http://www.dbanotes.net/X$TABLES/xtable.sql
http://www.orafaq.com/faqdbain.htm
http://www.stormloader.com/yonghuang/computer/x$table.html
http://www.adp-gmbh.ch/ora/misc/x.html
http://www.geocities.com/kgkrish/ http://www.oracle-training.cc/oracle_tips_x$.htm
注释
一些特定的缩写的含义
<1blockquote style="box-sizing:border-box;margin:20px 0px;font-size:13.92px;line-height:26px;text-align:justify;white-space:normal;padding:20px 50px;background:url(" border:2px="" solid="" #efefef;font-family:verdana,="" arial,="" helvetica,="" sans-serif;"="">
X$KS - Kernel Services X$KSL - Kernel Service Latch X$KC - Kernel Cache X$KQ - Kernel Query X$KQ - Kernel Generic X$LE - Lock Element X$KZ - Kernel Security
| Table_Name | Meanings | Comments | V$ Views / Scripts |
| X$ABSTRACT_LOB | LOB's ABSTRACT |
|
|
| X$ACTIVECKPT | ACTIVE Check Point |
|
|
| X$ASH | Active Session History |
|
|
| X$BH | Buffer Header |
Buffer Cache
中所有块的当前状态 从State列可得到缓冲区状态值表: 0,'free' 空闲 1,'xcur' 独占 2,'scur' 并发共享 3,'cr' 一致性读取 4,'read' 读取 5,'mrec' MediaRecovery 6,'irec' InstanceRecovery 7,'write' 写入 8,'pi', Pinned 9,'memory' 内存 10,'mwrite' 内存写 11,'donated' ? |
This is a very useful internal view on the buffer cache headers for database blocks in the buffer cache.
GV$BH / V$BH 脚本: 查询当前X$BH状态的脚本 |
| X$BUFFER |
|
|
|
| X$BUFFERED_PUBLISHERS |
|
|
GV$BUFFERED_PUBLISHERS
& V$BUFFERED_PUBLISHERS |
| X$BUFFERED_QUEUES |
|
|
|
| X$BUFFERED_SUBSCRIBERS |
|
|
|
| X$CKPTBUF | Check Point Buffer |
|
|
| X$CONTEXT |
|
|
|
| X$DUAL | DUAL table |
|
SYS.STANDARD需要用到X$DUAL, |
| X$ESTIMATED_MTTR |
|
|
|
| X$GLOBALCONTEXT |
|
|
|
| X$HOFP |
|
|
|
| X$HS_SESSION |
|
|
|
| X$INSTANCE_CACHE_TRANSFER |
|
|
|
| X$JOXFC |
|
|
|
| X$JOXFD |
|
|
|
| X$JOXFM |
|
|
|
| X$JOXFR |
|
|
|
| X$JOXFS |
|
|
|
| X$JOXFT |
|
|
|
| X$JSKJOBQ |
|
|
|
| X$JSKSLV |
|
|
|
| X$K2GTE |
|
|
|
| X$K2GTE2 |
|
|
|
| X$KAUVRSTAT |
|
|
|
| X$KCBBES |
|
|
|
| X$KCBBF |
|
|
|
| X$KCBBHS |
|
|
|
| X$KCBFWAIT |
|
|
|
| X$KCBKPFS |
|
|
|
| X$KCBKWRL |
|
|
|
| X$KCBLDRHIST |
|
|
|
| X$KCBLSC |
|
|
|
| X$KCBMMAV |
|
|
|
| X$KCBOBH |
|
|
|
| X$KCBOQH |
|
|
|
| X$KCBSC |
|
|
|
| X$KCBSDS |
|
|
|
| X$KCBSH |
|
|
|
| X$KCBSW |
|
|
|
| X$KCBVBL |
|
|
|
| X$KCBWAIT |
|
|
|
| X$KCBWBPD |
|
|
|
| X$KCBWDS |
|
|
|
| X$KCBWH |
|
|
|
| X$KCCAGF |
|
|
|
| X$KCCAL |
|
|
|
| X$KCCBF |
|
|
|
| X$KCCBI |
|
|
|
| X$KCCBL |
|
|
|
| X$KCCBP |
|
|
|
| X$KCCBS |
|
|
|
| X$KCCCC |
|
|
|
| X$KCCCF | Kernel Cache Controlfile management ControlFile name |
|
|
| X$KCCCP |
|
|
|
| X$KCCDC |
|
|
|
| X$KCCDFHIST |
|
|
|
| X$KCCDI |
|
|
MAXLOGMEMBERS is available via x$kccdi.dimlm |
| X$KCCDI2 |
|
|
|
| X$KCCDL |
|
|
|
| X$KCCFC |
|
|
|
| X$KCCFE |
|
|
|
| X$KCCFLE |
|
|
|
| X$KCCFN |
|
|
|
| X$KCCIC |
|
|
|
| X$KCCIRT |
|
|
|
| X$KCCLE |
|
|
|
| X$KCCLH |
|
|
|
| X$KCCOR |
|
|
|
| X$KCCPA |
|
|
|
| X$KCCPD |
|
|
|
| X$KCCRDI |
|
|
|
| X$KCCRM |
|
|
|
| X$KCCRS |
|
|
|
| X$KCCRSR |
|
|
|
| X$KCCRT |
|
|
|
| X$KCCSL |
|
|
|
| X$KCCTF |
|
|
|
| X$KCCTIR |
|
|
|
| X$KCCTS |
|
|
|
| X$KCFIO |
|
|
|
| X$KCFIOHIST |
|
|
|
| X$KCFTIO |
|
|
|
| X$KCFTIOHIST |
|
|
|
| X$KCKCE |
|
|
|
| X$KCKFM |
|
|
|
| X$KCKTY |
|
|
|
| X$KCLCRST |
|
|
|
| X$KCLCURST |
|
|
|
| X$KCLFH |
|
|
|
| X$KCLFI |
|
|
|
| X$KCLFX |
|
|
|
| X$KCLLS |
|
|
|
| X$KCLQN |
|
|
|
| X$KCLRCVST |
|
|
|
| X$KCPXPL |
|
|
|
| X$KCRFDEBUG |
|
|
|
| X$KCRFSTRAND |
|
|
|
| X$KCRFWS |
|
|
|
| X$KCRFX |
|
|
|
| X$KCRMF |
|
|
|
| X$KCRMT |
|
|
|
| X$KCRMX |
|
|
|
| X$KCRRALG |
|
|
|
| X$KCRRARCH |
|
|
|
| X$KCRRDEST |
|
|
|
| X$KCRRDGC |
|
|
|
| X$KCRRDSTAT |
|
|
|
| X$KCRRLNS |
|
|
|
| X$KCRRMS |
|
|
|
| X$KCTICW |
|
|
|
| X$KCTLAX |
|
|
|
| X$KCVFH |
|
|
|
| X$KCVFHALL |
|
|
|
| X$KCVFHMRR |
|
|
|
| X$KCVFHONL |
|
|
|
| X$KCVFHTMP |
|
|
|
| X$KDLT |
|
|
|
| X$KDNSSF |
|
|
|
| X$KDXHS |
|
|
|
| X$KDXST |
|
|
|
| X$KEACMDN |
|
|
|
| X$KEAOBJT |
|
|
|
| X$KEHECLMAP |
|
|
|
| X$KEHEVTMAP |
|
|
|
| X$KEHF |
|
|
|
| X$KEHOSMAP |
|
|
|
| X$KEHPRMMAP |
|
|
|
| X$KEHR |
|
|
|
| X$KEHRP |
|
|
|
| X$KEHR_CHILD |
|
|
|
| X$KEHSQT |
|
|
|
| X$KEHSYSMAP |
|
|
|
| X$KEHTIMMAP |
|
|
|
| X$KELRTD |
|
|
|
| X$KELTGSD |
|
|
|
| X$KELTOSD |
|
|
|
| X$KELTSD |
|
|
|
| X$KEWAM |
|
|
|
| X$KEWASH |
|
|
|
| X$KEWECLS |
|
|
|
| X$KEWEFXT |
|
|
|
| X$KEWESMAS |
|
|
|
| X$KEWESMS |
|
|
|
| X$KEWMAFMV |
|
|
|
| X$KEWMDRMV |
|
|
|
| X$KEWMDSM |
|
|
|
| X$KEWMEVMV |
|
|
|
| X$KEWMFLMV |
|
|
|
| X$KEWMGSM |
|
|
|
| X$KEWMRSM |
|
|
|
| X$KEWMRWMV |
|
|
|
| X$KEWMSEMV |
|
|
|
| X$KEWMSMDV |
|
|
|
| X$KEWMSVCMV |
|
|
|
| X$KEWRSQLIDTAB |
|
|
|
| X$KEWRTB |
|
|
|
| X$KEWRTSEGSTAT |
|
|
|
| X$KEWRTSQLSTAT |
|
|
|
| X$KEWSSESV |
|
|
|
| X$KEWSSMAP |
|
|
|
| X$KEWSSVCV |
|
|
|
| X$KEWSSYSV |
|
|
|
| X$KEWXOCF |
|
|
|
| X$KEWX_LOBS |
|
|
|
| X$KEWX_SEGMENTS |
|
|
|
| X$KFALS |
|
|
|
| X$KFDAT |
|
|
|
| X$KFDPARTNER |
|
|
|
| X$KFDSK |
|
|
|
| X$KFFIL |
|
|
|
| X$KFFXP |
|
|
|
| X$KFGMG |
|
|
|
| X$KFGRP |
|
|
|
| X$KFKID |
|
|
|
| X$KFNCL |
|
|
|
| X$KFTMTA |
|
|
|
| X$KGHLU |
|
|
|
| X$KGICC |
|
|
|
| X$KGICS |
|
|
|
| X$KGLAU |
|
|
|
| X$KGLBODY |
|
|
|
| X$KGLCLUSTER |
|
|
|
| X$KGLCURSOR |
|
|
|
| X$KGLDP |
|
|
|
| X$KGLINDEX |
|
|
|
| X$KGLJMEM |
|
|
|
| X$KGLJSIM |
|
|
|
| X$KGLLC |
|
|
|
| X$KGLLK |
|
|
|
| X$KGLMEM |
|
|
|
| X$KGLNA |
|
|
|
| X$KGLNA1 |
|
|
|
| X$KGLOB |
|
|
|
| X$KGLPN |
|
|
|
| X$KGLRD |
|
|
|
| X$KGLSIM |
|
|
|
| X$KGLSN |
|
|
|
| X$KGLST |
|
|
|
| X$KGLTABLE |
|
|
|
| X$KGLTR |
|
|
|
| X$KGLTRIGGER |
|
|
|
| X$KGLXS |
|
|
|
| X$KGSKASP |
|
|
|
| X$KGSKCFT |
|
|
|
| X$KGSKCP |
|
|
|
| X$KGSKDOPP |
|
|
|
| X$KGSKPFT |
|
|
|
| X$KGSKPP |
|
|
|
| X$KGSKQUEP |
|
|
|
| X$KGSKTE |
|
|
|
| X$KGSKTO |
|
|
|
| X$KJBL |
|
|
|
| X$KJBLFX |
|
|
|
| X$KJBR |
|
|
|
| X$KJBRFX |
|
|
|
| X$KJCTFR |
|
|
|
| X$KJCTFRI |
|
|
|
| X$KJCTFS |
|
|
|
| X$KJDRHV |
|
|
|
| X$KJDRMAFNSTATS |
|
|
|
| X$KJDRMHVSTATS |
|
|
|
| X$KJDRMREQ |
|
|
|
| X$KJDRPCMHV |
|
|
|
| X$KJDRPCMPF |
|
|
|
| X$KJICVT |
|
|
|
| X$KJILFT |
|
|
|
| X$KJILKFT |
|
|
|
| X$KJIRFT |
|
|
|
| X$KJISFT |
|
|
|
| X$KJITRFT |
|
|
|
| X$KJMDDP |
|
|
|
| X$KJMSDP |
|
|
|
| X$KJXM |
|
|
|
| X$KKSAI |
|
|
|
| X$KKSBV |
|
|
|
| X$KKSCS | Kernel Kompile Shared Cursor Sharing |
|
|
| X$KKSSRD |
|
|
|
| X$KLCIE |
|
|
|
| X$KLPT |
|
|
|
| X$KMCQS |
|
|
|
| X$KMCVC |
|
|
|
| X$KMGSCT |
|
|
|
| X$KMGSOP |
|
|
|
| X$KMMDI |
|
|
|
| X$KMMDP |
|
|
|
| X$KMMRD |
|
|
|
| X$KMMSG |
|
|
|
| X$KMMSI |
|
|
|
| X$KNGFL |
|
|
|
| X$KNSTACR |
|
|
|
| X$KNSTASL |
|
|
|
| X$KNSTCAP |
|
|
|
| X$KNSTMVR |
|
|
|
| X$KNSTRPP |
|
|
|
| X$KNSTRQU |
|
|
|
| X$KOCST |
|
|
|
| X$KQDPG |
|
|
|
| X$KQFCO |
|
|
|
| X$KQFDT |
|
|
|
| X$KQFP |
|
|
|
| X$KQFSZ |
|
|
|
| X$KQFTA |
|
|
|
| X$KQFVI |
|
|
|
| X$KQFVT |
|
|
|
| X$KQLFBC |
|
|
|
| X$KQLFSQCE |
|
|
|
| X$KQLFXPL |
|
|
|
| X$KQLSET |
|
|
|
| X$KQRFP |
|
|
|
| X$KQRFS |
|
|
|
| X$KQRPD |
|
|
|
| X$KQRSD |
|
|
|
| X$KQRST |
|
|
|
| X$KRBAFF |
|
|
|
| X$KRBMROT |
|
|
|
| X$KRBMRST |
|
|
|
| X$KRBMSFT |
|
|
|
| X$KRCBIT |
|
|
|
| X$KRCCDE |
|
|
|
| X$KRCCDR |
|
|
|
| X$KRCCDS |
|
|
|
| X$KRCEXT |
|
|
|
| X$KRCFBH |
|
|
|
| X$KRCFDE |
|
|
|
| X$KRCFH |
|
|
|
| X$KRCGFE |
|
|
|
| X$KRCSTAT |
|
|
|
| X$KRFBLOG |
|
|
|
| X$KRFGSTAT |
|
|
|
| X$KRVSLV |
|
|
|
| X$KRVSLVS |
|
|
|
| X$KRVXDKA |
|
|
|
| X$KRVXSV |
|
|
|
| X$KSBDD |
|
|
|
| X$KSBDP |
|
|
|
| X$KSBTABACT |
|
|
|
| X$KSFMCOMPL |
|
|
|
| X$KSFMELEM |
|
|
|
| X$KSFMEXTELEM |
|
|
|
| X$KSFMFILE |
|
|
|
| X$KSFMFILEEXT |
|
|
|
| X$KSFMIOST |
|
|
|
| X$KSFMLIB |
|
|
|
| X$KSFMSUBELEM |
|
|
|
| X$KSFQDVNT |
|
|
|
| X$KSFQP |
|
|
|
| X$KSFVQST |
|
|
|
| X$KSFVSL |
|
|
|
| X$KSFVSTA |
|
|
|
| X$KSIMAT |
|
|
|
| X$KSIMAV |
|
|
|
| X$KSIMSI |
|
|
|
| X$KSIRESTYP |
|
|
|
| X$KSLCS |
|
|
|
| X$KSLECLASS |
|
|
|
| X$KSLED |
|
|
|
| X$KSLEI |
|
|
|
| X$KSLEMAP |
|
|
|
| X$KSLES |
|
|
|
| X$KSLLCLASS |
|
|
|
| X$KSLLD |
|
|
|
| X$KSLLT |
|
|
|
| X$KSLLW |
|
|
|
| X$KSLPO |
|
|
|
| X$KSLSCS |
|
|
|
| X$KSLSESHIST |
|
|
|
| X$KSLWSC |
|
|
|
| X$KSMDD |
|
|
|
| X$KSMDUT1 |
|
|
|
| X$KSMFS |
|
|
|
| X$KSMFSV |
|
|
|
| X$KSMGE |
|
|
|
| X$KSMHP |
|
|
|
| X$KSMJCH |
|
|
|
| X$KSMJS |
|
|
|
| X$KSMLRU |
|
|
|
| X$KSMLS |
|
|
|
| X$KSMMEM |
|
|
|
| X$KSMNIM |
|
|
|
| X$KSMNS |
|
|
|
| X$KSMPP |
|
|
|
| X$KSMSD |
|
|
|
| X$KSMSGMEM |
|
|
|
| X$KSMSP | Kernel Service Memory in Shared Pool |
|
|
| X$KSMSPR |
|
|
|
| X$KSMSP_DSNEW |
|
|
|
| X$KSMSP_NWEX |
|
|
|
| X$KSMSS |
|
|
|
| X$KSMSTRS |
|
|
|
| X$KSMUP |
|
|
|
| X$KSOLSFTS |
|
|
|
| X$KSOLSSTAT |
|
|
|
| X$KSPPCV |
|
|
|
| X$KSPPCV2 |
|
|
|
| X$KSPPI | Kernel Service, Parameter, Parameter Info |
|
|
| X$KSPPO |
|
|
|
| X$KSPPSV |
|
|
|
| X$KSPPSV2 |
|
|
|
| X$KSPSPFH |
|
|
|
| X$KSPSPFILE |
|
|
|
| X$KSPXFR |
|
|
|
| X$KSQDN |
|
|
|
| X$KSQEQ |
|
|
|
| X$KSQEQTYP |
|
|
|
| X$KSQRS |
|
|
|
| X$KSQST |
|
|
|
| X$KSRCCTX |
|
|
|
| X$KSRCDES |
|
|
|
| X$KSRCHDL |
|
|
|
| X$KSRMPCTX |
|
|
|
| X$KSRMSGDES |
|
|
|
| X$KSRMSGO |
|
|
|
| X$KSTEX |
|
|
|
| X$KSUCF |
|
|
|
| X$KSUCPUSTAT |
|
|
|
| X$KSULL |
|
|
|
| X$KSULOP |
|
|
|
| X$KSULV |
|
|
|
| X$KSUMYSTA |
|
|
|
| X$KSUPGP |
|
|
|
| X$KSUPGS |
|
|
|
| X$KSUPL |
|
|
|
| X$KSUPR | Kernel Services User Process |
|
V$PROCESS is based on GV$PROCESS;
GV$PROCESS is based on X$KSUPR |
| X$KSUPRLAT |
|
|
|
| X$KSURLMT |
|
|
|
| X$KSURU |
|
|
|
| X$KSUSD |
|
|
|
| X$KSUSE |
|
|
|
| X$KSUSECON |
|
|
|
| X$KSUSECST |
|
|
|
| X$KSUSEH |
|
|
|
| X$KSUSESTA |
|
|
|
| X$KSUSEX |
|
|
|
| X$KSUSGIF |
|
|
|
| X$KSUSGSTA |
|
|
|
| X$KSUSIO |
|
|
|
| X$KSUTM |
|
|
|
| X$KSUVMSTAT |
|
|
|
| X$KSUXSINST |
|
|
|
| X$KSWSASTAB |
|
|
|
| X$KSWSCLSTAB |
|
|
|
| X$KSWSEVTAB |
|
|
|
| X$KSXAFA |
|
|
|
| X$KSXPIA |
|
|
|
| X$KSXRCH |
|
|
|
| X$KSXRCONQ |
|
|
|
| X$KSXRMSG |
|
|
|
| X$KSXRREPQ |
|
|
|
| X$KSXRSG |
|
|
|
| X$KTADM |
|
|
|
| X$KTCSP |
|
|
|
| X$KTCXB |
|
|
|
| X$KTFBFE |
|
|
|
| X$KTFBHC |
|
|
|
| X$KTFBUE |
|
|
|
| X$KTFTHC |
|
|
|
| X$KTFTME |
|
|
|
| X$KTIFB |
|
|
|
| X$KTIFF |
|
|
|
| X$KTIFP |
|
|
|
| X$KTIFV |
|
|
|
| X$KTPRHIST |
|
|
|
| X$KTPRXRS |
|
|
|
| X$KTPRXRT |
|
|
|
| X$KTRSO |
|
|
|
| X$KTSKSTAT |
|
|
|
| X$KTSPSTAT |
|
|
|
| X$KTSSO |
|
|
|
| X$KTSTFC |
|
|
|
| X$KTSTSSD |
|
|
|
| X$KTTEFINFO |
|
|
|
| X$KTTVS |
|
|
|
| X$KTUGD |
|
|
|
| X$KTUQQRY |
|
|
|
| X$KTURD |
|
|
|
| X$KTURHIST |
|
|
|
| X$KTUSMST |
|
|
|
| X$KTUSMST2 |
|
|
|
| X$KTUXE | Kernel Transaction Undo Transaxtion Entry | This view holds entry for each active undo slot. |
To see any DEAD transactions for deferred transaction recovery after startup:
SELECT * FROM x$ktuxe WHERE ktuxecfl = 'DEAD'; |
| X$KUPVA |
|
|
|
| X$KUPVJ |
|
|
|
| X$KVII |
|
|
|
| X$KVIS |
|
|
SELECT kvisval, kvisdsc FROM x$kvis; |
| X$KVIT |
|
|
|
| X$KWDDEF |
|
|
|
| X$KWQBPMT |
|
|
|
| X$KWQPD |
|
|
|
| X$KWQPS |
|
|
|
| X$KWQSI |
|
|
|
| X$KWRSNV |
|
|
|
| X$KXFPCDS |
|
|
|
| X$KXFPCMS |
|
|
|
| X$KXFPCST |
|
|
|
| X$KXFPDP |
|
|
|
| X$KXFPNS |
|
|
|
| X$KXFPPFT |
|
|
|
| X$KXFPSDS |
|
|
|
| X$KXFPSMS |
|
|
|
| X$KXFPSST |
|
|
|
| X$KXFPYS |
|
|
|
| X$KXFQSROW |
|
|
|
| X$KXSBD |
|
|
|
| X$KXSCC |
|
|
|
| X$KZDOS |
|
|
|
| X$KZEMAEA |
|
|
|
| X$KZEMAIE |
|
|
|
| X$KZRTPD |
|
|
|
| X$KZSPR |
|
|
|
| X$KZSRO |
|
|
|
| X$KZSRT |
|
|
|
| X$LCR |
|
|
|
| X$LE |
|
|
|
| X$LOGMNR_ATTRIBUTE$ |
|
|
|
| X$LOGMNR_CALLBACK |
|
|
|
| X$LOGMNR_COL$ |
|
|
|
| X$LOGMNR_COLTYPE$ |
|
|
|
| X$LOGMNR_CONTENTS |
|
|
|
| X$LOGMNR_DICT$ |
|
|
|
| X$LOGMNR_DICTIONARY |
|
|
|
| X$LOGMNR_DICTIONARY_LOAD |
|
|
|
| X$LOGMNR_ENCRYPTED_OBJ$ |
|
|
|
| X$LOGMNR_ENCRYPTION_PROFILE$ |
|
|
|
| X$LOGMNR_IND$ |
|
|
|
| X$LOGMNR_INDPART$ |
|
|
|
| X$LOGMNR_LATCH |
|
|
|
| X$LOGMNR_LOGFILE |
|
|
|
| X$LOGMNR_LOGS |
|
|
|
| X$LOGMNR_OBJ$ |
|
|
|
| X$LOGMNR_PARAMETERS |
|
|
|
| X$LOGMNR_PROCESS |
|
|
|
| X$LOGMNR_REGION |
|
|
|
| X$LOGMNR_ROOT$ |
|
|
|
| X$LOGMNR_SESSION |
|
|
|
| X$LOGMNR_TAB$ |
|
|
|
| X$LOGMNR_TABCOMPART$ |
|
|
|
| X$LOGMNR_TABPART$ |
|
|
|
| X$LOGMNR_TABSUBPART$ |
|
|
|
| X$LOGMNR_TRANSACTION |
|
|
|
| X$LOGMNR_TS$ |
|
|
|
| X$LOGMNR_TYPE$ |
|
|
|
| X$LOGMNR_USER$ |
|
|
|
| X$MESSAGES |
|
|
|
| X$NLS_PARAMETERS |
|
|
|
| X$NSV |
|
|
|
| X$OPTION |
|
|
|
| X$PRMSLTYX |
|
|
|
| X$QESMMAHIST |
|
|
|
| X$QESMMAPADV |
|
|
|
| X$QESMMIWH |
|
|
|
| X$QESMMIWT |
|
|
|
| X$QESMMSGA |
|
|
|
| X$QESRSTAT |
|
|
|
| X$QESRSTATALL |
|
|
|
| X$QKSCESES |
|
|
|
| X$QKSCESYS |
|
|
|
| X$QKSMMWDS |
|
|
|
| X$QUIESCE |
|
|
|
| X$RFMP |
|
|
|
| X$RFMTE |
|
|
|
| X$SKGXPIA |
|
|
|
| X$TARGETRBA |
|
|
|
| X$TEMPORARY_LOB_REFCNT |
|
|
|
| X$TIMEZONE_FILE |
|
|
|
| X$TIMEZONE_NAMES |
|
|
|
| X$TRACE |
|
|
|
| X$TRACE_EVENTS |
|
|
|
| X$UGANCO |
|
|
|
| X$VERSION |
|
|
|
| X$VINST |
|
|
|
| X$XSAGGR |
|
|
|
| X$XSAGOP |
|
|
|
| X$XSAWSO |
|
|
|
| X$XSLONGOPS |
|
|
|
| X$XSOBJECT |
|
|
|
| X$XSOQMEHI |
|
|
|
| X$XSOQOJHI |
|
|
|
| X$XSOQOPHI |
|
|
|
| X$XSOQOPLU |
|
|
|
| X$XSOQSEHI |
|
|
|
| X$XSSINFO |
|
|
|
源自：http://www.cnblogs.com/sopost/archive/2010/07/14/2190104.html
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8484829/viewspace-2151182/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
