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.115804@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'

VIEW_NAME

---

VIEW_DEFINITION

---

GV$INSTANCE
select

ks.inst_id,ksuxsins,ksuxssid,ksuxshst,ksuxsver,ksuxstim,decode(ksuxssts,0
,'STARTED',1,'MOUNTED',2,'OPEN','UNKNOWN'),decode(ksuxsshr,0,'NO',1,'YES',2,NULL
),ksuxsthr,decode(ksuxsarc,0,'STOPPED',1,'STARTED','FAILED'),decode(ksuxslsw,0,N

ULL,2,'ARCHIVE LOG',3,'CLEAR
LOG',4,'CHECKPOINT'),decode(ksuxsdba,0,'ALLOWED','R ESTRICTED'),decode(ksuxsshp,0,'NO','YES'),decode(kvitval,0,'ACTIVE',2147483647,' SUSPENDED','INSTANCE RECOVERY') from x$ksuxsinst ks, x$kvit kv where kvittag = '
kcbwst'

hth, joe

-- 
Joe Testa  http://www.oracle-dba.com
Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs

Received on Tue Aug 29 2000 - 19:25:28 CDT