Oracle's x$ Tables

select kqftanam from x$kqfta;

x$activeckpt

x$bh

select count(*), State from (
    select decode (state, 
       0, 'Free',
       1, decode (lrba_seq,
          0, 'Available',
             'Being Used'),
       3, 'Being Used',
          state) State
     from x$bh )
    group by state

x$bufqm

x$class_stat

x$context

x$globalcontext

x$hofp

x$hs_session

The x$kc... tables

x$kcbbhs

x$kcbmmav

x$kcbsc

x$kcbwait

x$kcbwbpd

x$kcbwds

x$kccal

x$kccbf

x$kccbi

x$kccbl

x$kccbp

x$kccbs

x$kcccc

x$kcccf

x$kccdc

x$kccdi

x$kccdl

x$kccfc

x$kccfe

x$kccfn

x$kccic

x$kccle

select max(lebsz) from x$kccle

x$kcclh

x$kccor

x$kcccp

select
  le.leseq                        "Current log sequence No",
  100*cp.cpodr_bno/le.lesiz       "Percent Full",
  cp.cpodr_bno                    "Current Block No",
  le.lesiz                        "Size of Log in Blocks"
from
  x$kcccp cp,
  x$kccle le
where
  LE.leseq =CP.cpodr_seq
  and bitand(le.leflg,24)=8;

x$kccrs

x$kccrt

x$kccsl

x$kcctf

x$kccts

x$kcfio

x$kcftio

x$kckce

x$kckty

x$kclcrst

x$kcrfx

x$kcrmf

x$kcrmx

x$kcrralg

x$kcrrarch

x$kcrrdest

x$kcrrdstat

x$kcrrms

x$kcvfh

x$kcvfhmrr

x$kcvfhonl

x$kcvfhtmp

x$kdnssf

The x$kg... tables

x$kghlu

x$kgicc

x$kgics

x$kglcursor

x$kgldp

x$kgllk

select 
  kglnaobj, kgllkreq
from 
  x$kgllk x join v$session s on 
    s.saddr = x.kgllkses;

x$kglmem

x$kglna

x$kglna1

x$kglob

x$kglsim

x$kglst

x$kgskasp

x$kgskcft

x$kgskcp

x$kgskdopp

x$kgskpft

x$kgskpp

x$kgskquep

x$kjbl

x$kjbr

x$kjdrhv

x$kjdrpcmhv

x$kjdrpcmpf

x$kjicvt

x$kjilkft

x$kjirft

x$kjisft

x$kjitrft

x$kksbv

x$kkscs

x$kkssrd

x$klcie

x$klpt

x$kmcqs

x$kmcvc

x$kmmdi

x$kmmrd

x$kmmsg

x$kmmsi

x$knstacr

x$knstasl

x$knstcap

x$knstmvr

x$knstrpp

x$knstrqu

x$kocst

The x$kq... tables

x$kqfco

select
  t.kqftanam "Table Name",
  c.kqfconam "Column Name",
  c.kqfcosiz "Column Size"
from
  x$kqfta t,
  x$kqfco c
where
  t.indx = c.kqfcotab

x$kqfdt

x$kqfsz

x$kqfta

select kqftanam from x$kqfta;

select
  t.kqftanam "Table Name",
  c.kqfconam "Column Name"
from
  x$kqfta t,
  x$kqfco c
where
  t.indx = c.kqfcotab

x$kqfvi

x$kqfvt

x$kqlfxpl

x$kqlset

x$kqrfp

x$kqrfs

x$kqrst

x$krvslv

x$krvslvs

x$krvxsv

The x$ks... tables

x$ksbdd

x$ksbdp

x$ksfhdvnt

x$ksfmcompl

x$ksfmelem

x$ksfmextelem

x$ksfmfile

x$ksfmfileext

x$ksfmiost

x$ksfmlib

x$ksfmsubelem

x$ksfqp

x$ksimsi

x$ksled

x$kslei

x$ksles

x$kslld

x$ksllt

x$ksllw

x$kslwsc

x$ksmfs

x$ksmfsv

x$ksmge

x$ksmgop

x$ksmgsc

x$ksmgst

x$ksmgv

x$ksmhp

x$ksmjch

x$ksmjs

x$ksmlru

x$ksmls

x$ksmmem

select 
  (select sum(value)  from v$sga  ) -
  (select 4*count(*) from x$ksmmem) "Must be Zero!"
from 
  dual;

x$ksmsd

x$ksmsp

x$ksmsp_nwex

x$ksmspr

x$ksmss

x$ksolsfts

x$ksolsstat

x$ksppcv

x$ksppcv2

x$ksppi

x$ksppo

x$ksppsv

x$ksppsv2

x$kspspfile

x$ksqeq

x$ksqrs

x$ksqst

x$kstex

x$ksull

x$ksulop

x$ksulv

x$ksumysta

x$ksupr

x$ksuprlat

x$ksurlmt

x$ksusd

x$ksuse

x$ksusecon

x$ksusecst

x$ksusesta

x$ksusgif

x$ksusgsta

x$ksusio

x$ksutm

x$ksuxsinst

x$ktadm

x$targetrba

x$ktcxb

x$ktfbfe

x$ktfthc

x$ktftme

x$ktprxrs

x$ktprxrt

x$ktrso

x$ktsso

x$ktstfc

x$ktstssd

x$kttvs

x$kturd

x$ktuxe

x$kvis

 select kvisval from x$kvis where kvistag = 'kcbbkl'

x$kvit

x$kwddef

x$kwqpd

x$kwqps

x$kxfpdp

x$kxfpns

x$kxfpsst

x$kxfpys

x$kxfqsrow

x$kxsbd

x$kxscc

x$kzrtpd

x$kzspr

x$kzsrt

x$le

x$le_stat

x$logmnr_callback

x$logmnr_contents

x$logmnr_dictionary

x$logmnr_logfile

x$logmnr_logs

x$logmnr_parameters

x$logmnr_process

x$logmnr_region

x$logmnr_session

x$logmnr_transaction

x$nls_parameters

x$option

x$prmsltyx

x$qesmmiwt

x$qesmmsga

x$quiesce

x$uganco

x$version

x$xsaggr

x$xsawso

x$xssinfo

A perlscript to find x$ tables

#!/usr/bin/perl -w

use strict;

open O, ("/appl/oracle/product/9.2.0.2/bin/oracle");
open F, (">x");

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

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

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

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

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