Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: X$ objects location

RE: X$ objects location

From: Rahul <rahul_at_ratelindo.co.id>
Date: Thu, 22 Jun 2000 13:56:24 +0700
Message-Id: <10536.110107@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US