오라클 19c v$로 시작하는 뷰 원본 쿼리 확인

OS환경 : Oracle Linux 7.6 (64bit)

 

DB 환경 : Oracle Database 19.10.0.0

 

방법 : 오라클 19c v$로 시작하는 뷰 원본 쿼리 확인

v$fixed_view_definition 뷰를 이용해 확인 가능

SQL> select view_definition
  2  from v$fixed_view_definition
  3  where view_name = 'GV$WAITSTAT';
 
VIEW_DEFINITION
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select inst_id,decode(indx,1,'data block',2,'sort block',3,'save undo block', 4,'segment header',5,'save undo header',6,'free list',7,'extent map', 8,'1st level bmb',9,'2nd level bmb',10,'3rd level bm
b', 11,'bitmap block',12,'bitmap index block',13,'file header block',14,'unused', 15,'system undo header',16,'system undo block', 17,'undo header',18,'undo block'), count,time from x$kcbwait where ind
x!=0
 

 

 

참조 : https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-FIXED_VIEW_DEFINITION.html