X$ tables

[jdorlon]

Hi

I have read somewhere (it has been a while, so I forget where) that all of those strangely named columns in all of those strangely named X$ tables actually make sense because they are made up many abbreviations smashed together.

L might stand for 'Lock', O, might stand for 'object', etc...

Whatever I was reading said that it is actually fairly easy to know what the table name and column names mean once you know what all the abbreviations are.

Does anyone know what the abbreviations are or where a
document is that tells what they are?

Thanks in advance.

-John

[LND]

I do not remember where I downloaded this:

Oracle Database Internals FAQ
$Date: 15-Jul-2000 $
$Revision: 0.50 $
$Author: Frank Naudé $

....

Kernel Subsystems:
OPI Oracle Program Interface
KK Compilation Layer - Parse SQL, compile PL/SQL
KX Execution Layer - Bind and execute SQL and PL/SQL
K2 Distributed Execution Layer - 2PC handling
NPI Network Program Interface
KZ Security Layer - Validate privs
KQ Query Layer
RPI Recursive Program Interface
KA Access Layer
KD Data Layer
KT Transaction Layer
KC Cache Layer
KS Services Layer
KJ Lock Manager Layer
KG Generic Layer
S or ODS Operating System Dependencies

[pando]

[url]http://www.orafaq.com/faqdbain.htm#KERNEL[/url]


Oracle Kernel Subsystems
Listed below are some of the important subsystems in the Oracle kernel. This table might help you to read those dreaded trace files and internal messages. For example, if you see messages like this, you will at least know where they come from:

OPIRIP: Uncaught error 447. Error stack:
KCF: write/open error block=0x3e800 online=1

Kernel Subsystems:
OPI Oracle Program Interface
KK Compilation Layer - Parse SQL, compile PL/SQL
KX Execution Layer - Bind and execute SQL and PL/SQL
K2 Distributed Execution Layer - 2PC handling
NPI Network Program Interface
KZ Security Layer - Validate privs
KQ Query Layer
RPI Recursive Program Interface
KA Access Layer
KD Data Layer
KT Transaction Layer
KC Cache Layer
KS Services Layer
KJ Lock Manager Layer
KG Generic Layer
S or ODS Operating System Dependencies

Although I dont think is what you are looking for

[Edited by pando on 02-15-2001 at 07:31 AM]