Ç°ÑÔ£ºÔÚoracleÔËάµÄ¹ý³ÌÖУ¬¾­³£»áʹÓõ½Ò»Ð©ÒÔV$¿ªÍ·µÄ¶¯Ì¬ÊÓͼ£¬±ÈÈçV$session, ÓÐÒ»´ÎżȻ¿´µ½ÓÐÈËÓÃV_$session, ³õÒÔΪ±ðÈËд´íÁË£¬Ã»Ïëµ½desc v_$sessionÒÔºóÄÜ¿´µ½ºÍv$sessionÒ»ÑùµÄ½á¹¹£¬ÔÙÒÔºóÓÖ·¢ÏÖÒÔgv$¿ªÍ·µÄÊÓͼµÈµÈ¡£³ÃÕâ´ÎÔÚһ̨LinuxϵͳÉÏ×°oracleµÄ»ú»á£¬ÖÕÓÚŪÇå³þÁËÕâЩ¶¯Ì¬ÊÓͼÓëÏàÓ¦±íÖ®¼äµÄ¹Øϵ¡£
ÕâЩ¶¼ÊÇÓÉoracle×Ô¼º¹ÜÀíµÄÊý¾Ý½á¹¹£¬µÃ´Óv$fixed_tableÈëÊÖ£º
[oracle@3857 admin]$ sqlplus sys/sys@archdw as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 14 11:27:20 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 ¨C Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> desc v$fixed_table;
Name Null Type
¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¨C ¡ª¡ª¨C ¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª-
NAME VARCHAR2(30)
OBJECT_ID NUMBER
TYPE VARCHAR2(5)
TABLE_NUM NUMBER
SQL> select * from v$fixed_table
NAME OBJECT_ID TYPE TABLE_NUM
¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª ¡ª¡ª¡ª- ¡ª¨C ¡ª¡ª¡ª-
X$KQFTA 4294950912 TABLE 0
X$KQFVI 4294950913 TABLE 1
GV$PROCESS 4294951256 VIEW 65537
V$PROCESS 4294950917 VIEW 65537
GV$BGPROCESS 4294951257 VIEW 65537
¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­
´ÓÉÏÃæ¿ÉÒÔ¿´µ½GV$ÓëV$ÊÇÊÓͼ£¬X$ÊÇ±í¡£ÄÇËüÃÇÖ®¼äÊÇʲô¹ØϵÄØ£¿´ÓÁíÒ»¸öÊÓͼv$fixed_view_definitionÖеõ½ÈçÏÂÐÅÏ¢(ÒÔv$fixed_tableΪÀý)£º
SQL> set linesize 100
SQL> col view_name for a15
SQL> col view_definition for a80
SQL> select * from v$fixed_view_definition where view_name=¡¯V$FIXED_TABLE¡¯;
VIEW_NAME VIEW_DEFINITION
¡ª¡ª¡ª¡ª¡ª¡ª¡ª- ¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¨C
V$FIXED_TABLE select NAME , OBJECT_ID , TYPE , TABLE_NUM from GV$FIXED_TABLE where inst_id =
USERENV(¡¯Instance¡¯)
SQL> select * from v$fixed_view_definition where view_name=¡¯GV$FIXED_TABLE¡¯;
VIEW_NAME VIEW_DEFINITION
¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª- ¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¨C
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
Ô­À´gv$ÊÇÈ«¾ÖÊÓͼ£¬¶øv$ÊÇÕë¶Ôij¸öʵÀýµÄÊÓͼ£¬$XÊÇËùÓÐgv$µÄÊý¾ÝÀ´Ô´£¬´Ógv$µ½v$ÐèÒª¼ÓÉÏwhere inst_id = USERENV(¡¯Instance¡¯)¡£Ò»°ãÀ´ËµÒ»¸öoracleÊý¾Ý¿âÖ»»áÓÐÒ»¸öʵÀý¶ÔÆä²Ù×÷£¬µ«ÔÚRACÉÏ¿ÉÒÔÓжą̀ʵÀýͬʱװÔز¢´ò¿ªÒ»¸öÊý¾Ý¿â£¬ÔÚRACÉϵõ½µÄ½á¹ûÊÇ£º
etl@ALIDW> select distinct inst_id from gv$session;
INST_ID
¡ª¡ª¡ª-
1
2
4
3
ÕâracÉÏÓÐËĸöʵÀý¡£àÅ£¬ÔٴμÓÉîÁ˶ÔʵÀýÓëÊý¾Ý¿âµÄÀí½â¡£
ÄÇgv_$Óëv_$µÄ¶¨ÒåÓÖÔÚʲôµØ·½ÄØ£¿Ô­À´ÔÚ$ORACLE_HOME/rdbms/admin´æ·Å×Åϵͳ¹ÜÀí½Å±¾£¬ÔÚcatalog.sqlÖз¢ÏÖ£º
¨CCATCTL -S Initial scripts single process
@@cdstrt
@@cdfixed.sql
@@cdcore.sql
¨CCATCTL -M
@@cdplsql.sql
@@cdsqlddl.sql
¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­.
½øÒ»²½ÔÚcdfixed.sqlÖÐÕÒµ½
create or replace view v_$fixed_table as select * from v$fixed_table;
create or replace public synonym v$fixed_table for v_$fixed_table;
grant select on v_$fixed_table to select_catalog_role;
create or replace view gv_$fixed_table as select * from gv$fixed_table;
create or replace public synonym gv$fixed_table for gv_$fixed_table;
grant select on gv_$fixed_table to select_catalog_role;
¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­.
[oracle@3857 admin]$ sqlplus sys/sys@archdw as sysdba
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª ¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª ¡ª ¡ª ¡ª
SYS SELECT_CATALOG_ROLE YES YES NO
Òò´ËÎÒÃdz£ÓõÄv$ ÊÇv_$µÄͬÒå´Ê£¬v_$ÊÇ»ùÓÚÕæÕýµÄÊÓͼv$£¬¶øÕæÕýµÄv$ÊÓͼÊÇÔÚgv$µÄ»ù´¡ÉÏÏÞÖÆinst_idµÃµ½;
ÎÒÃdz£ÓõÄgv$ÊÇgv_$µÄͬÒå´Ê£¬gv_$»ùÓÚÕæÕýµÄÊÓͼgv$£¬¶øÕæÕýµÄgv$ÊÓͼ»ùÓÚϵͳ±íX$¡£