Re: X$ Tables....anyone have a list of them?

From: Heidi M Thorpe <hthorpe_at_usa.net>
Date: Thu, 12 Nov 1998 12:43:52 +1100
Message-ID: <72deok$gj4$1@news.mel.aone.net.au>

Hi,

All of the X$ tables are listed in the dynamic table V$fixed_table (in Oracle 8).

There is very little documentation on any of these tables.

However, if you look in V$fixed_view_definition you can get an idea of what the tables are for.

regards,
Heidi

John0725 wrote in message <19981111182653.16036.00000260_at_ng111.aol.com>...
>Hi everyone....
>
>I have some questions.
>
>1) Does anyone have a description and listing of the X$ tables?
>
>2) Do theses tables change much between versions of Oracle?
>
>3) I know that the V$ tables have most of the same data as what's in the
X$
>tables......why are they so hard to get to? I can't find any documentation
on
>them, but I know of a few and suspect there are many more. Is it because
of
>#2?
>
>4) In general are the X$ tables any faster than the V$ tables?
>
>Thanks to anyone who replies.
>
>--John Dorlon
Received on Wed Nov 11 1998 - 19:43:52 CST