Re: viewing the x$ tables

View V$FIXED_TABLE list the X$ views, but not the columns and the meaning. You really must be SYS to be able to query them. In my opinion you do not need to know about the X$-views for normal daily DBA work.
They are Oracle internal, changing a lot with the version and therefore not documented.

For some situations you may need them. But I always just believe the scripts I find then.
Site http://www.ixora.com.au/ describes much about X$-views. And it can help to really get to know Oracle internals.

An example - and one of my favorites - is X$KSMLRU which is usefull when there is severe fragmentation of the shared pool. It shows what came into the shared pool that caused something else to be flushed out, how many chunks where flushed and the size. A bizar property is that it is erased every time you select from it and it stores only the last 10 occurences. Detailed description in Metalink note 61623.1.

Ryan Gaffuri <rgaffuri_at_cox.net> schreef in berichtnieuws 1efdad5b.0205300957.51a1184f_at_posting.google.com...
| Which priviledge do I need to view this? DBA access doesnt cut it. Ive
| been looking at them from the SYS account which I would prefer not to
| be in.
|
| Also, which data dictionary view do I use to get a list of the x$
| tables? DBA_OBJECTS and DBA_TABLES did not work?
|
| One other thing... does anyone really use these to do work? I find
| them incredibly hard to read... just learning them to improve my
| overall knowledge of Oracle.
|
| Thanks,
|
| Ryan
Received on Thu May 30 2002 - 17:02:16 CDT