GV$FIXED_VIEW_DEFINITION

select
i.inst_id,               -- INST_ID NUMBER
kqfvinam,                -- VIEW_NAME VARCHAR2(30)
kqftpsel                 -- VIEW_DEFINITION VARCHAR2(4000)
from
x$kqfvi i,
x$kqfvt t 
where
i.indx = t.indx
home |  up  |  mailbox