Re: selecting from oralcle Internal tables

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Thu, 29 Oct 1998 08:08:37 -0800
Message-ID: <Pine.OSF.3.95.981029075643.11991A-100000@gonzo.wolfenet.com>

On Thu, 29 Oct 1998, Billy Verreynne wrote:
>
> segoro_at_my-dejanews.com wrote in message <719as7$9ib$1_at_nnrp1.dejanews.com>...
> >WHO Knows how Can I obtain
> >a LiST of oracle intenal tables with columns and maybe descriptions!
> >I mean Tables named like 'X$%' and other.
> >for Example x$kzsro x$kglpn ...
>
> X$ tables are not suppose to be used by us mere mortals. That's why we have
> the V$ and DBA views and why X$ tables descriptions are not available
> outside Oracle. However, you can use v$fixed_view_definition to see what
> and how X$ tables and columns are used in creating the V$ views.

select kqftanam from x$kqfta;

In the names of these tables, each letter represents a kernel layer.

My favorite: X$KTURD. (K)ernel (T)ransaction (U)ndo (R)?? (D)escriptor.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Thu Oct 29 1998 - 10:08:37 CST