Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: X$ objects location
these are not physical objects, they are array/structures
in SGA, there array eliments are shown as rows/columns
> ----------
> From: Surya Rao[SMTP:surya.rao_at_reuters.com]
> Sent: Thursday, June 22, 2000 21:06
> To: oracledba_at_lazydba.com
> Subject: X$ objects location
> Sensitivity: Confidential
>
> if I select * from v$fixed_table as sys, I can see all
> the x$ object names e/g x$kccle for getting redo log
> information etc
>
> but why can't i find these objects when i do this?
>
> as sys
>
> select object_name
> from dba_objects
> where upper(object_name) like 'X%'
> /
>
> aren't these objects catalogued in the data dictionary
> somewhere?
>
> any ideas?
>
> -----------------------------------------------------------------
> Visit our Internet site at http://www.reuters.com
>
> Any views expressed in this message are those of the individual
> sender, except where the sender specifically states them to be
> the views of Reuters Ltd.
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Thu Jun 22 2000 - 01:56:24 CDT