index_number number y
column_name varchar2(30) y
column_position number y
sql>
例如：
sql> select * from v$indexed_fixed_column where table_name='x$kqfta';
table_name index_number column_name column_position
------------------------------ ------------ ------------------------------ ---------------
x$kqfta 1 addr 0
x$kqfta 2 indx 0
sql>
一般来说，v$视图和gv$视图的定义是一样的，只是gv$视图中包含的实例id的信息，常用于ops或者rac的系统中，也有少数几个v$视图和gv$视图的定义是有区别的，比如gv$px_process和v$px_process：
sql> select * from v$fixed_view_definition where view_name='gv$px_process';
gv$px_process select a.inst_id, a.kxfpdpnam, decode(bitand(a.kxfpdpflg, 16), 0, 'in use', 'available'), b.pid, a.kxfpdpspid, c.sid, c.serial# from x$kxfpdp a, v$process b, v$session c where bitand(kxfpdpflg, 8) != 0 and a.kxfpdpspid = b.spid and a.kxfpdpspid = c.process(+)
sql>
select a.inst_id, a.kxfpdpnam,
decode(bitand(a.kxfpdpflg, 16), 0, 'in use', 'available'),
b.pid, a.kxfpdpspid, c.sid, c.serial#
from x$kxfpdp a, v$process b, v$session c
where bitand(kxfpdpflg, 8) != 0 and a.kxfpdpspid = b.spid and a.kxfpdpspid = c.process(+)
sql> select * from v$fixed_view_definition where view_name='v$px_process';
v$px_process select server_name, status, pid, spid, sid, serial# from gv$px_process where inst_id = userenv('instance')
sql>
select server_name, status, pid, spid, sid, serial#
from gv$px_process
where inst_id = userenv('instance')
二、数据字典的组成
如何得到一个数据字典表的定义呢？
sql> desc dba_views
name type nullable default comments
---------------- -------------- -------- ------- -----------------------------------------------------------
owner varchar2(30) owner of the view
