ANBOB™

SQL> select * from gv$fixed_view_definition where VIEW_name='V$FIXED_TABLE';

   INST_ID VIEW_NAME
---------- ------------------------------
VIEW_DEFINITION
--------------------------------------------------------------------------------
         1 V$FIXED_TABLE
select  NAME , OBJECT_ID , TYPE , TABLE_NUM from GV$FIXED_TABLE where inst_id =
USERENV('Instance')


SQL> select * from gv$fixed_view_definition where VIEW_name='GV$FIXED_TABLE';

   INST_ID VIEW_NAME
---------- ------------------------------
VIEW_DEFINITION
--------------------------------------------------------------------------------
         1 GV$FIXED_TABLE
select inst_id,kqftanam, kqftaobj, 'TABLE', indx from x$kqfta union all select i
nst_id,kqfvinam, kqfviobj, 'VIEW', 65537 from x$kqfvi union all select inst_id,k
qfdtnam, kqfdtobj, 'TABLE', 65537 from x$kqfdt

SQL> select TEXT from dba_views where view_name='V_$FIXED_TABLE';

TEXT
----------------------------------------------------------------------------
select "NAME","OBJECT_ID","TYPE","TABLE_NUM" from v$fixed_table


SQL> SELECT * FROM dba_synonyms where synonym_name='V$FIXED_TABLE'
  2*

OWNER      SYNONYM_NAME         TABLE_OWNE TABLE_NAME                     DB_LINK
---------- -------------------- ---------- ------------------------------ ----------
PUBLIC     V$FIXED_TABLE        SYS        V_$FIXED_TABLE

gv$ 视图基于x$创建, g_v$ 视图基于gv$视图创建,gv$同义词又是基于gv_$视图创建，v$视图又基于gv$视图创建， v_$ view 基于 v$ 视图创建，v$同义词又是基于v_$视图创建,呵呵是不是有点乱….

V_$视图把v$视图 sys与普通用户分开，同时任何人不可以以v$视图授权，可以以v_$视图,这是通过软件限制的而非数据库权限级

fixed object 不会在dba_objects中。

打赏

微信扫一扫，打赏作者吧～