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: system views and their underlying structure

Re: system views and their underlying structure

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Tue, 29 Aug 2000 20:25:28 -0400
Message-Id: <10603.115803@fatcity.com> 





you were close,



look at v$fixed_view_definition for the gv$ view and you'll see what
x$tables it uses.




SQL> list


  1  select * from sys.v$fixed_view_definition
  2*	 where view_name = 'GV$INSTANCE'
Received on Tue Aug 29 2000 - 19:25:28 CDT












Original text of this message













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