Re: Internal Tables X$xxxx

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Thu, 11 Feb 1999 11:06:59 -0800
Message-ID: <36C32A53.FB6AC01A@us.oracle.com>

It certainly does have a lot of information, but not on the x$ tables. These are built in the kernel, and there is no script that you can see them in. I think someone else has already mentioned v$fixed_view_definitions, which is the only place I've seen a listing of them.

I wonder what the benefit is of obtaining such a listing though. These fixed views can change from release to release, and so would be out of date quickly. In addition, as you've probably already seen the table names and the column names are deliberately obtuse, so even having a listing of them wouldn't benefit you much.

HTH. Pete

Torsten Borchert wrote:

> Hi,
>
> look in $ORACLE_HOME/rdbms/admin at the file sql.bsq - it runs on
> DB-Creation, there are a lot of information (Oracle 7...).
>
> Torsten
>
> gcwong_at_interlog.com wrote:
> >
> > Does anyone know where I can obtain a list of the internal Oracle tables
> > X$xxxx and what each tables does? Is there anywhere that I can get
> > information on these objects?
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Thu Feb 11 1999 - 13:06:59 CST