oracle X$表命名约定

[plain]

X$表命名约定

[plain]

[K]ernel Layer

[2]-Phase Commit

[G]lobal [T]ransaction [E]ntry

X$K2GTE - Current 2PC tx

X$K2GTE2 - Current 2PC tx

[C]ache Layer

[B]uffer Management

Buffer [H]ash

X$BH - Hash Table

Buffer LRU Statistics

X$KCBCBH - [C]urrent [B]uffers (buckets) - lru_statistics

X$KCBRBH - [R]ecent [B]uffers (buckets) - lru_extended

Buffer [WAIT]s

X$KCBWAIT - Waits by block class

X$KCBFWAIT - Waits by File

[W]orking Sets - 7.3 or higher

X$KCBWDS - Set [D]escriptors

[C]ontrol File Management

[C]ontrol [F]ile List - 7.0.16 or higher

X$KCCCF - Control File Names & status

[D]atabase [I]nformation

X$KCCDI - Database Information

Data [F]iles

X$KCCFE - File [E]ntries ( from control file )

X$KCCFN - [F]ile [N]ames

[L]og Files

X$KCCLE - Log File [E]ntries

X$KCCLH - Log [H]istory ( archive entries )

Thread Information

X$KCCRT - [R]edo [T]hread Information

[F]ile Management

X$KCFIO - File [IO] Statistics

[L]ock Manager Component ( LCK )

[H]ash and Bucket Tables - 7.0.15 to 7.1.1, and 7.2.0 or higher

X$KCLFH - File [H]ash Table

X$KCLFI - File Bucket Table

X$LE - Lock [E]lements

X$LE_STAT - Lock Conversion [STAT]istics

X$KCLFX - Lock Element [F]ree list statistics - 7.3 or higher

X$KCLLS - Per LCK free list statistics - 7.3 or higher

X$KCLQN - [N]ame (hash) table statistics - 7.3 or higher

[R]edo Component

[M]edia recovery - kcra.h - 7.3 or higher

X$KCRMF - [F]ile context

X$KCRMT - [T]hread context

X$KCRMX - Recovery Conte[X]t

[F]ile read

X$KCRFX - File Read Conte[X]t - 7.3 or higher

Reco[V]ery Component

[F]ile [H]eaders

X$KCVFH - All file headers

X$KCVFHMRR - Files with [M]edia [R]ecovery [R]equired

X$KCVFHONL - [ONL]ine File headers

[K]ompatibility Management - 7.1.1 or higher

X$KCKCE - [C]ompatibility Segment [E]ntries

X$KCKTY - Compatibility [TY]pes

X$KCKFM - Compatibility [F]or[M]ats ( index into X$KCKCE )

[D]ata Layer

Sequence [N]umber Component

X$KDNCE - Sequence [C]ache [E]ntries - 7.2 or lower

[S]equence Enqueues - common area for enqueue objects

X$KDNSSC - [C]ache Enqueue Objects - 7.2 or lower

X$KDNSSF - [F]lush Enqueue Objects - 7.2 or lower

X$KDNST - Cache [ST]atistics - 7.2 or lower

Inde[X] Block Component

X$KDXHS - Index [H]i[S]togram

X$KDXST - Index [ST]atistics

[G]eneric Layer

[H]eap Manager

X$KGHLU - State (summary) of [L]R[U] heap(s) - defined in ksmh.h

[I]nstantiation Manager

[C]ursor [C]ache

X$KGICC - Session statistics - defined in kqlf.h

X$KGICS - System wide statistics - defined in kqlf.h

[L]ibrary Cache Manager ( defined and mapped from kqlf )

Bind Variables

X$KKSBV - Library Object [B]ind [V]ariables

Object Cache

X$KGLOB - All [OB]jects

X$KGLTABLE - Filter for [TABLE]s

X$KGLBODY - Filter for [BODY] ( packages )

X$KGLTRIGGER - Filter for [TRIGGER]s

X$KGLINDEX - Filter for [INDEX]es

X$KGLCLUSTER - Filter for [CLUSTER]s

X$KGLCURSOR - Filter for [CURSOR]s

Cache Dependency

X$KGLDP - Object [D]e[P]endency table

X$KGLRD - [R]ead only [D]ependency table - 7.3 or higher

Object Locks

X$KGLLK - Object [L]oc[K]s

Object Names

X$KGLNA - Object [NA]mes (sql text)

X$KGLNA1 - Object [NA]mes (sql text) with newlines - 7.2.0 or higher

Object Pins

X$KGLPN - Object [P]i[N]s

Cache Statistics

X$KGLST - Library cache [ST]atistics

Translation Table

X$KGLTR - Address [TR]anslation

Access Table

X$KGLXS - Object Access Table

Authorization Table - 7.1.5 or higher

X$KGLAU - Object Authorization table

Latch Cleanup - 7.0.15 or higher

X$KGLLC - [L]atch [C]leanup for Cache/Pin Latches

[K]ompile Layer

[S]hared Objects

X$KKSAI - Cursor [A]llocation [I]nformation - 7.3.2 or higher

[L]oader

[L]ibrary

X$KLLCNT - [C]o[NT]rol Statistics

X$KLLTAB - [TAB]le Statistics

[M]ulti-Threaded Layer

[C]ircuit component

X$KMCQS - Current [Q]ueue [S]tate

X$KMCVC - [V]irtual [C]ircuit state

[M]onitor Server/dispatcher

[D]ispatcher

X$KMMDI - [D]ispatcher [I]nfo (status)

X$KMMDP - [D]ispatcher Config ( [P]rotocol info )

[S]erver

X$KMMSI - [S]erver [I]nfo ( status )

X$KMMSG - [SG]a info ( global statistics)

X$KMMRD - [R]equest timing [D]istributions

s[Q]l Version and Opti

上一个：oracle锁的概念-1
下一个：web os commander外部表

更多图片编程知识:

更多Oracle疑问解答：: 运行exp备份oracle数据库提示oracle-12154错误; 有没有，生产Oracle Rman 备份脚本的工具啊！; 初学orcle，希望有大大帮忙解说一下详细步骤，从登录oracle到创建表的过程; oracle语句问题：一张user表，三个字段，id,name,time，插入记录比如：张三2007，李四2008，张三2011; 如何写一个ORACLE触发器同步两个表中的数据？; oracle 如何查看一个服务器上有多少个数据库.; oracle 创建包的时候错误求解; oracle 重复列的问题; oracle 中如何查处2星期前的数据; 请教oracle数据库安装中的问题; 请问谁能提供给我标准的oracle ERP的数据库表结构并详细说明各表主要的作用?; 安装oracle遇到的问题 invalid entry CRC (expected 0x3e12e795 but got 0x9db0e9fd); 我的是ORACLE 10G，在RMAN中如何按指定的时间恢复数据文件啊？; oracle为什么没有自动增长列; oracle快捷键都有哪些啊？