ITPub博客

首页 > Linux操作系统 > Linux操作系统 > [20120306]访问v$access 视图.txt

[20120306]访问v$access 视图.txt

原创 Linux操作系统 作者:lfree 时间:2012-03-07 09:13:11 0 删除 编辑
SQL> select * from v$version ;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


SQL> select * from v$mystat where rownum<=1;
       SID STATISTIC#      VALUE
---------- ---------- ----------
       201          0          0


SQL> alter session set statistics_level=all;
SQL> select /*+ rule */ * from v$access where sid=72;

SQL> @dpc
PLAN_TABLE_OUTPUT
-------------------------------------
SQL_ID  20ncdkfht396j, child number 0
-------------------------------------
select /*+ rule */ * from v$access where sid=72
Plan hash value: 1832884590
--------------------------------------------------------------------------------------------------------
| Id  | Operation                | Name      | Starts | A-Rows |   A-Time   |  OMem |  1Mem | Used-Mem |
--------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT         |           |      1 |    100 |00:00:00.12 |       |       |          |
|   1 |  VIEW                    | GV$ACCESS |      1 |    100 |00:00:00.12 |       |       |          |
|   2 |   SORT UNIQUE            |           |      1 |    100 |00:00:00.12 |  9216 |  9216 | 8192  (0)|
|   3 |    MERGE JOIN            |           |      1 |    153 |00:00:00.12 |       |       |          |
|   4 |     SORT JOIN            |           |      1 |    159 |00:00:00.12 | 22528 | 22528 |20480  (0)|
|   5 |      MERGE JOIN          |           |      1 |    255 |00:00:00.12 |       |       |          |
|   6 |       SORT JOIN          |           |      1 |    255 |00:00:00.05 | 36864 | 36864 |32768  (0)|
|   7 |        MERGE JOIN        |           |      1 |    255 |00:00:00.05 |       |       |          |
|   8 |         SORT JOIN        |           |      1 |    173 |00:00:00.01 | 22528 | 22528 |20480  (0)|
|   9 |          FIXED TABLE FULL| X$KGLLK   |      1 |    173 |00:00:00.01 |       |       |          |
|* 10 |         SORT JOIN        |           |    173 |    255 |00:00:00.04 |   619K|   472K|  550K (0)|
|  11 |          FIXED TABLE FULL| X$KGLDP   |      1 |   8996 |00:00:00.03 |       |       |          |
|* 12 |       SORT JOIN          |           |    255 |    255 |00:00:00.07 |  1257K|   577K| 1117K (0)|
|  13 |        FIXED TABLE FULL  | X$KGLOB   |      1 |   7059 |00:00:00.05 |       |       |          |
|* 14 |     SORT JOIN            |           |    159 |    153 |00:00:00.01 |  2048 |  2048 | 2048  (0)|
|* 15 |      FIXED TABLE FULL    | X$KSUSE   |      1 |      1 |00:00:00.01 |       |       |          |
--------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

  10 - access("L"."KGLLKHDL"="D"."KGLHDADR" AND "L"."KGLNAHSH"="D"."KGLNAHSH")
       filter(("L"."KGLNAHSH"="D"."KGLNAHSH" AND "L"."KGLLKHDL"="D"."KGLHDADR"))
  12 - access("O"."KGLNAHSH"="D"."KGLRFHSH" AND "O"."KGLHDADR"="D"."KGLRFHDL")
       filter(("O"."KGLHDADR"="D"."KGLRFHDL" AND "O"."KGLNAHSH"="D"."KGLRFHSH"))
  14 - access("L"."KGLLKUSE"="S"."ADDR")
       filter("L"."KGLLKUSE"="S"."ADDR")
  15 - filter(("S"."INST_ID"=USERENV('INSTANCE') AND "S"."KSUSENUM"=72))

Note
-----
   - rule based optimizer used (consider using cbo)

42 rows selected.


--如果删除提示rule,执行计划如下:

SQL> Select * from v$access where sid=72;

SQL> @dpc
PLAN_TABLE_OUTPUT
-------------------------------------
SQL_ID  gpht00n8kfgad, child number 0
-------------------------------------
Select * from v$access where sid=72

Plan hash value: 3335709282

---------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                   | Name            | Starts | E-Rows | Cost (%CPU)| A-Rows |   A-Time   |  OMem |  1Mem | Used-Mem |
---------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                 |      1 |        |     1 (100)|    100 |00:00:00.41 |       |       |          |
|   1 |  VIEW                       | GV$ACCESS       |      1 |      1 |     1 (100)|    100 |00:00:00.41 |       |       |          |
|   2 |   HASH UNIQUE               |                 |      1 |      1 |     1 (100)|    100 |00:00:00.41 |   852K|   852K| 1344K (0)|
|   3 |    NESTED LOOPS             |                 |      1 |      1 |     0   (0)|    153 |00:00:00.41 |       |       |          |
|   4 |     NESTED LOOPS            |                 |      1 |      1 |     0   (0)|   9047 |00:00:00.24 |       |       |          |
|   5 |      MERGE JOIN CARTESIAN   |                 |      1 |      1 |     0   (0)|   9047 |00:00:00.07 |       |       |          |
|*  6 |       FIXED TABLE FULL      | X$KSUSE         |      1 |      1 |     0   (0)|      1 |00:00:00.01 |       |       |          |
|   7 |       BUFFER SORT           |                 |      1 |    100 |     0   (0)|   9047 |00:00:00.05 |   690K|   486K|  613K (0)|
|   8 |        FIXED TABLE FULL     | X$KGLDP         |      1 |    100 |     0   (0)|   9047 |00:00:00.03 |       |       |          |
|*  9 |      FIXED TABLE FIXED INDEX| X$KGLOB (ind:1) |   9047 |      1 |     0   (0)|   9047 |00:00:00.12 |       |       |          |
|* 10 |     FIXED TABLE FIXED INDEX | X$KGLLK (ind:1) |   9047 |      1 |     0   (0)|    153 |00:00:00.14 |       |       |          |
---------------------------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   6 - filter(("S"."KSUSENUM"=72 AND "S"."INST_ID"=USERENV('INSTANCE')))
   9 - filter(("O"."KGLNAHSH"="D"."KGLRFHSH" AND "O"."KGLHDADR"="D"."KGLRFHDL"))
  10 - filter(("L"."KGLLKUSE"="S"."ADDR" AND "L"."KGLLKHDL"="D"."KGLHDADR" AND "L"."KGLNAHSH"="D"."KGLNAHSH"))

29 rows selected.

SQL> @dpc
PLAN_TABLE_OUTPUT
-------------------------------------
SQL_ID  gpht00n8kfgad, child number 1
-------------------------------------
Select * from v$access where sid=72

Plan hash value: 3335709282

---------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                   | Name            | Starts | E-Rows | Cost (%CPU)| A-Rows |   A-Time   |  OMem |  1Mem | Used-Mem |
---------------------------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                 |      1 |        |     1 (100)|    100 |00:00:00.42 |       |       |          |
|   1 |  VIEW                       | GV$ACCESS       |      1 |    100 |     1 (100)|    100 |00:00:00.42 |       |       |          |
|   2 |   HASH UNIQUE               |                 |      1 |    100 |     1 (100)|    100 |00:00:00.42 |   852K|   852K| 1336K (0)|
|   3 |    NESTED LOOPS             |                 |      1 |      1 |     0   (0)|    153 |00:00:00.42 |       |       |          |
|   4 |     NESTED LOOPS            |                 |      1 |      1 |     0   (0)|   9068 |00:00:00.24 |       |       |          |
|   5 |      MERGE JOIN CARTESIAN   |                 |      1 |      1 |     0   (0)|   9068 |00:00:00.07 |       |       |          |
|*  6 |       FIXED TABLE FULL      | X$KSUSE         |      1 |      1 |     0   (0)|      1 |00:00:00.01 |       |       |          |
|   7 |       BUFFER SORT           |                 |      1 |    100 |     0   (0)|   9068 |00:00:00.05 |   690K|   486K|  613K (0)|
|   8 |        FIXED TABLE FULL     | X$KGLDP         |      1 |    100 |     0   (0)|   9068 |00:00:00.03 |       |       |          |
|*  9 |      FIXED TABLE FIXED INDEX| X$KGLOB (ind:1) |   9068 |      1 |     0   (0)|   9068 |00:00:00.12 |       |       |          |
|* 10 |     FIXED TABLE FIXED INDEX | X$KGLLK (ind:1) |   9068 |      1 |     0   (0)|    153 |00:00:00.14 |       |       |          |
---------------------------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   6 - filter(("S"."KSUSENUM"=72 AND "S"."INST_ID"=USERENV('INSTANCE')))
   9 - filter(("O"."KGLNAHSH"="D"."KGLRFHSH" AND "O"."KGLHDADR"="D"."KGLRFHDL"))
  10 - filter(("L"."KGLLKUSE"="S"."ADDR" AND "L"."KGLLKHDL"="D"."KGLHDADR" AND "L"."KGLNAHSH"="D"."KGLNAHSH"))

Note
-----
   - cardinality feedback used for this statement
33 rows selected.

--第2次执行出现如下cardinality feedback used for this statement。

注意如果在cbo下使用MERGE JOIN CARTESIAN ,如果会话很多,这个连接会很大,很久结果也不会出来!导致系统执行缓慢。这个就是今天生产系统遇到的问题。
--注:生产系统是10.2.0.3。

按照这个链接的提示,按照lbs1988的指点:
http://www.itpub.net/thread-1587279-1-1.html

分析收集fixed table信息。
exec dbms_stats.gather_fixed_objects_stats;

执行再看执行计划如下:
SQL> select * from table(dbms_xplan.display_cursor(NULL,NULL,'allstats last cost'));
PLAN_TABLE_OUTPUT
-------------------------------------
SQL_ID  5b3bwymb8yptb, child number 0
-------------------------------------
select * from v$access where sid=399

Plan hash value: 1019812077

--------------------------------------------------------------------------------------------------------
| Id  | Operation                   | Name            | E-Rows | Cost (%CPU)|  OMem |  1Mem | Used-Mem |
--------------------------------------------------------------------------------------------------------
|*  1 |  VIEW                       | GV$ACCESS       |     40 |     5 (100)|       |       |          |
|   2 |   HASH UNIQUE               |                 |     40 |     5 (100)|       |       |          |
|   3 |    NESTED LOOPS             |                 |     40 |     4 (100)|       |       |          |
|   4 |     NESTED LOOPS            |                 |     40 |     4 (100)|       |       |          |
|*  5 |      HASH JOIN              |                 |     40 |     4 (100)|   899K|   899K|  316K (0)|
|*  6 |       FIXED TABLE FULL      | X$KSUSE         |      1 |     0   (0)|       |       |          |
|   7 |       FIXED TABLE FULL      | X$KGLLK         |  13899 |     3 (100)|       |       |          |
|*  8 |      FIXED TABLE FIXED INDEX| X$KGLDP (ind:1) |      1 |     0   (0)|       |       |          |
|*  9 |     FIXED TABLE FIXED INDEX | X$KGLOB (ind:1) |      1 |     0   (0)|       |       |          |
--------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter("INST_ID"=USERENV('INSTANCE'))
   5 - access("L"."KGLLKUSE"="S"."ADDR")
   6 - filter("S"."KSUSENUM"=399)
   8 - filter(("L"."KGLLKHDL"="D"."KGLHDADR" AND "L"."KGLNAHSH"="D"."KGLNAHSH"))
   9 - filter(("O"."KGLNAHSH"="D"."KGLRFHSH" AND "O"."KGLHDADR"="D"."KGLRFHDL"))

Note
-----
   - Warning: basic plan statistics not available. These are only collected when:
       * hint 'gather_plan_statistics' is used for the statement or
       * parameter 'statistics_level' is set to 'ALL', at session or system level

35 rows selected.


--可以发现执行计划已经发生了改变,而且很快完成了。

4.看看分析了哪些对象
SQL> column operation format a30
SQL> column start_time format a30
SQL> column end_time format a30
SQL> select operation,start_time,end_time from sys.WRI$_OPTSTAT_OPR where start_time>=trunc(sysdate);
OPERATION                      START_TIME                     END_TIME
------------------------------ ------------------------------ ------------------------------
gather_fixed_objects_stats     2012-03-07 08:11:35.360467     2012-03-07 08:14:16.565636

SQL> SELECT * FROM v$fixed_table
WHERE object_id IN (SELECT obj# FROM SYS.wri$_optstat_tab_history WHERE savtime >= TRUNC (SYSDATE));

NAME,OBJECT_ID,TYPE,TABLE_NUM
X$KQFTA,4294950912,TABLE,0,
X$KQFVI,4294950913,TABLE,1,
X$KQFVT,4294951149,TABLE,2,
X$KQFDT,4294950914,TABLE,3,
X$KQFCO,4294951036,TABLE,4,
X$KQFOPT,4294952712,TABLE,5,
X$KSLLT,4294950993,TABLE,6,
X$KSLHOT,4294952169,TABLE,7,
X$KSLLCLASS,4294951813,TABLE,8,
X$KSLECLASS,4294951830,TABLE,9,
X$KSLEMAP,4294951831,TABLE,10,
X$KSLLD,4294950994,TABLE,11,
X$KSLED,4294951094,TABLE,12,
X$KSLCS,4294952078,TABLE,13,
X$KSLSCS,4294952079,TABLE,14,
X$KSLES,4294951095,TABLE,15,
X$KSLSESHIST,4294951973,TABLE,16,
X$KSLEI,4294951102,TABLE,17,
X$KSLLW,4294951183,TABLE,18,
X$KSLPO,4294951184,TABLE,19,
X$KSLWSC,4294951185,TABLE,20,
X$KSQEQTYP,4294951983,TABLE,21,
X$KSQRS,4294950999,TABLE,22,
X$KSQDN,4294951001,TABLE,23,
X$KSQST,4294951085,TABLE,24,
X$KSUSE,4294951004,TABLE,25,
X$KSUSEX,4294951428,TABLE,26,
X$KSUPR,4294951005,TABLE,27,
X$KSUPRLAT,4294951006,TABLE,28,
X$KSURLMT,4294951396,TABLE,29,
X$KSUSD,4294951007,TABLE,30,
X$KSUSGSTA,4294951008,TABLE,31,
X$KSUTM,4294951067,TABLE,32,
X$KSUSGIF,4294951930,TABLE,33,
X$KSUSESTA,4294951009,TABLE,34,
X$KSUMYSTA,4294951106,TABLE,35,
X$KSUSIO,4294951079,TABLE,36,
X$KSUSEH,4294952007,TABLE,37,
X$KSUSECST,4294951096,TABLE,38,
X$KSULOP,4294951244,TABLE,39,
X$KSUPGP,4294951577,TABLE,40,
X$KSUPGS,4294951578,TABLE,41,
X$KSURU,4294951010,TABLE,42,
X$KSUPL,4294951011,TABLE,43,
X$KSUCF,4294951012,TABLE,44,
X$KSULL,4294951082,TABLE,45,
X$KSUCPUSTAT,4294952112,TABLE,46,
X$KSUVMSTAT,4294952113,TABLE,47,
X$KSUSM,4294952182,TABLE,48,
X$KSIRESTYP,4294951982,TABLE,49,
X$KSIMSI,4294951178,TABLE,50,
X$KSIMAV,4294951179,TABLE,51,
X$KSIMAT,4294951180,TABLE,52,
X$KSMSD,4294950995,TABLE,53,
X$KSMSS,4294950997,TABLE,54,
X$KSMNS,4294951493,TABLE,55,
X$KSMNIM,4294951494,TABLE,56,
X$KSMLS,4294951383,TABLE,57,
X$KSMFS,4294951384,TABLE,58,
X$KSMJS,4294951595,TABLE,59,
X$KSMSTRS,4294952000,TABLE,60,
X$KSMFSV,4294951146,TABLE,62,
X$KSMLRU,4294951099,TABLE,63,
X$KGHLU,4294951105,TABLE,64,
X$KSMSPR,4294951170,TABLE,66,
X$KSMPP,4294951191,TABLE,67,
X$KSMUP,4294951192,TABLE,68,
X$KSMHP,4294951193,TABLE,69,
X$KSMJCH,4294951609,TABLE,70,
X$KSMSST,4294952688,TABLE,71,
X$KSMSP_DSNEW,4294951768,TABLE,72,
X$KSMSP_NWEX,4294951769,TABLE,73,
X$KGLSIM,4294951882,TABLE,74,
X$KGLJSIM,4294951994,TABLE,75,
X$KGLMEM,4294951885,TABLE,76,
X$KGLJMEM,4294951997,TABLE,77,
X$KSMSGMEM,4294952475,TABLE,78,
X$KSMPGST,4294952646,TABLE,79,
X$KSMPGDST,4294952673,TABLE,80,
X$KSMPGDP,4294952674,TABLE,81,
X$KSPPI,4294950998,TABLE,82,
X$KSPPCV,4294951198,TABLE,83,
X$KSPPSV,4294951199,TABLE,84,
X$KSPPCV2,4294951587,TABLE,85,
X$KSPPSV2,4294951588,TABLE,86,
X$KSPSPFILE,4294951746,TABLE,87,
X$KSPSPFH,4294951933,TABLE,88,
X$KSPVLD_VALUES,4294952694,TABLE,89,
X$KSPPO,4294951486,TABLE,90,
X$KSBDP,4294950990,TABLE,91,
X$KSBDD,4294950991,TABLE,92,
X$MESSAGES,4294950992,TABLE,93,
X$KSBFT,4294952690,TABLE,94,
X$KSBTABACT,4294952582,TABLE,95,
X$KSQEQ,4294951000,TABLE,96,
X$TRACE,4294951002,TABLE,97,
X$TRACE_EVENTS,4294951003,TABLE,98,
X$KSTEX,4294951145,TABLE,99,
X$NLS_PARAMETERS,4294951043,TABLE,100,
X$KSULV,4294951130,TABLE,101,
X$TIMEZONE_NAMES,4294951704,TABLE,102,
X$TIMEZONE_FILE,4294952589,TABLE,103,
X$KSUXSINST,4294951046,TABLE,104,
X$KSUSECON,4294951158,TABLE,105,
X$KSFQP,4294951563,TABLE,106,
X$KSFQDVNT,4294951380,TABLE,107,
X$KSFVQST,4294951441,TABLE,108,
X$KSFVSTA,4294951427,TABLE,109,
X$KSFVSL,4294951426,TABLE,110,
X$KGSKTE,4294951465,TABLE,111,
X$KGSKTO,4294951466,TABLE,112,
X$KGSKCP,4294951467,TABLE,113,
X$KGSKPP,4294951468,TABLE,114,
X$KGSKASP,4294951571,TABLE,115,
X$KGSKDOPP,4294951572,TABLE,116,
X$KGSKQUEP,4294951701,TABLE,117,
X$KGSKVFT,4294952667,TABLE,118,
X$KGSKCFT,4294951469,TABLE,119,
X$KGSKPFT,4294951470,TABLE,120,
X$KSKPLW,4294952188,TABLE,121,
X$KGSKSCS,4294952189,TABLE,122,
X$KSRCDES,4294951579,TABLE,123,
X$KSRCCTX,4294951580,TABLE,124,
X$KSRMSGDES,4294951581,TABLE,125,
X$KSRMPCTX,4294951582,TABLE,126,
X$KSRCHDL,4294951583,TABLE,127,
X$KSRMSGO,4294951584,TABLE,128,
X$KSXPIA,4294952165,TABLE,129,
X$SKGXPIA,4294952166,TABLE,130,
X$KSMDD,4294951622,TABLE,131,
X$KSMDUT1,4294952607,TABLE,132,
X$KSMGE,4294951733,TABLE,133,
X$KSXRMSG,4294951728,TABLE,134,
X$KSXRREPQ,4294951729,TABLE,135,
X$KSXRCONQ,4294951730,TABLE,136,
X$KSXRCH,4294951731,TABLE,137,
X$KSXRSG,4294951732,TABLE,138,
X$KSFMLIB,4294951910,TABLE,139,
X$KSFMIOST,4294951817,TABLE,140,
X$KSFMFILE,4294951818,TABLE,141,
X$KSFMFILEEXT,4294951819,TABLE,142,
X$KSFMSUBELEM,4294951820,TABLE,143,
X$KSFMELEM,4294951821,TABLE,144,
X$KSFMEXTELEM,4294951822,TABLE,145,
X$KSFMCOMPL,4294951823,TABLE,146,
X$KSOLSSTAT,4294951842,TABLE,147,
X$KSOLSFTS,4294951841,TABLE,148,
X$KSWSCLSTAB,4294952155,TABLE,149,
X$KSWSEVTAB,4294952154,TABLE,150,
X$KSWSASTAB,4294952091,TABLE,151,
X$KSIRGD,4294952708,TABLE,152,
X$KJREQFP,4294952613,TABLE,153,
X$KJLEQFP,4294952612,TABLE,154,
X$KJISFT,4294951415,TABLE,155,
X$KJILFT,4294951416,TABLE,156,
X$KJICVT,4294951421,TABLE,157,
X$KJILKFT,4294951430,TABLE,158,
X$KJIRFT,4294951433,TABLE,159,
X$KJITRFT,4294951603,TABLE,160,
X$KJXM,4294951770,TABLE,161,
X$KJCTFS,4294951927,TABLE,162,
X$KJCTFR,4294951928,TABLE,163,
X$KJCTFRI,4294951929,TABLE,164,
X$KJBR,4294951616,TABLE,165,
X$KJBRFX,4294951617,TABLE,166,
X$KJBL,4294951614,TABLE,167,
X$KJBLFX,4294951615,TABLE,168,
X$KJMSDP,4294951693,TABLE,169,
X$KJMDDP,4294951694,TABLE,170,
X$KJDRHV,4294951781,TABLE,171,
X$KJDRPCMHV,4294951784,TABLE,172,
X$KJDRPCMPF,4294951787,TABLE,173,
X$KJDRMAFNSTATS,4294952142,TABLE,174,
X$KJDRMHVSTATS,4294952143,TABLE,175,
X$KJDRMREQ,4294952144,TABLE,176,
X$KMGSCT,4294951662,TABLE,177,
X$KMGSTFR,4294952192,TABLE,178,
X$KMGSOP,4294951663,TABLE,179,
X$KMGSBSADV,4294952614,TABLE,180,
X$KCCCF,4294951110,TABLE,181,
X$KCCRS,4294951217,TABLE,182,
X$KCCDI,4294951038,TABLE,183,
X$KCCDI2,4294951840,TABLE,184,
X$KCCRT,4294951041,TABLE,185,
X$KCCTIR,4294952471,TABLE,186,
X$KCCLE,4294951040,TABLE,187,
X$KCCSL,4294951665,TABLE,188,
X$KCCFE,4294951039,TABLE,189,
X$KCCTF,4294951460,TABLE,190,
X$KCCFN,4294951037,TABLE,191,
X$KCCTS,4294951206,TABLE,192,
X$KCCRM,4294951669,TABLE,193,
X$KCCLH,4294951042,TABLE,194,
X$KCCOR,4294951207,TABLE,195,
X$KCCAL,4294951208,TABLE,196,
X$KCCBS,4294951209,TABLE,197,
X$KCCBP,4294951210,TABLE,198,
X$KCCBF,4294951211,TABLE,199,
X$KCCBL,4294951212,TABLE,200,
X$KCCDC,4294951213,TABLE,201,
X$KCCFC,4294951214,TABLE,202,
X$KCCCC,4294951215,TABLE,203,
X$KCCDL,4294951216,TABLE,204,
X$KCCPD,4294951557,TABLE,205,
X$KCCPA,4294951560,TABLE,206,
X$KCCBI,4294951810,TABLE,207,
X$KCCIC,4294951906,TABLE,208,
X$KCCRDI,4294952047,TABLE,209,
X$KCCIRT,4294952048,TABLE,210,
X$KCCAGF,4294952049,TABLE,211,
X$KCCFLE,4294952037,TABLE,212,
X$KCCRSP,4294952655,TABLE,213,
X$KCCNRS,4294952659,TABLE,214,
X$KCCRSR,4294952064,TABLE,215,
X$KCCDFHIST,4294952133,TABLE,216,
X$KCBWDS,4294951172,TABLE,217,
X$KCBWBPD,4294951394,TABLE,218,
X$KCBBHS,4294951429,TABLE,219,
X$KCBBES,4294951503,TABLE,220,
X$ACTIVECKPT,4294951387,TABLE,221,
X$CKPTBUF,4294951388,TABLE,222,
X$KCBKWRL,4294951613,TABLE,223,
X$KCBKPFS,4294951775,TABLE,224,
X$BH,4294950954,TABLE,225,
X$KCBBF,4294951246,TABLE,226,
X$KCBWH,4294951247,TABLE,227,
X$KCBSW,4294951248,TABLE,228,
X$KCBWAIT,4294950955,TABLE,229,
X$KCBFWAIT,4294951081,TABLE,230,
X$KCBSC,4294951626,TABLE,231,
X$KCBSH,4294951629,TABLE,232,
X$KCBSDS,4294951630,TABLE,233,
X$KCBMMAV,4294951824,TABLE,234,
X$KCBOBH,4294952086,TABLE,235,
X$KCBOQH,4294952087,TABLE,236,
X$KCKCE,4294951122,TABLE,237,
X$KCKTY,4294951123,TABLE,238,
X$KCKFM,4294951124,TABLE,239,
X$KCRMF,4294951160,TABLE,240,
X$KCRMT,4294951161,TABLE,241,
X$KCRMX,4294951163,TABLE,242,
X$KCRRDSTAT,4294951650,TABLE,243,
X$KCRRDGC,4294951963,TABLE,244,
X$KCRRDEST,4294951242,TABLE,245,
X$KCRRALG,4294951814,TABLE,246,
X$KCRRMS,4294951618,TABLE,247,
X$KCRRARCH,4294951556,TABLE,248,
X$KCRRLNS,4294951903,TABLE,249,
X$KCRRNHG,4294952209,TABLE,250,
X$KCRRASTATS,4294952210,TABLE,251,
X$KRFSTHRD,4294952193,TABLE,252,
X$KCRRPVRS,4294952201,TABLE,253,
X$KCRRPTDGSTATS,4294952206,TABLE,254,
X$KCRFWS,4294951809,TABLE,255,
X$KCRFSTRAND,4294952164,TABLE,256,
X$KCRFDEBUG,4294952088,TABLE,257,
X$KCRFX,4294951162,TABLE,258,
X$KCFIOHIST,4294951974,TABLE,259,
X$KCFTIOHIST,4294952121,TABLE,260,
X$KCFIO,4294950957,TABLE,261,
X$KCFTIO,4294951521,TABLE,262,
X$KCLFX,4294951174,TABLE,263,
X$KCLQN,4294951175,TABLE,264,
X$KCLFH,4294951141,TABLE,265,
X$KCLFI,4294951142,TABLE,266,
X$LE,4294950958,TABLE,267,
X$KCLLS,4294951173,TABLE,268,
X$KCLCRST,4294951504,TABLE,269,
X$INSTANCE_CACHE_TRANSFER,4294952150,TABLE,270,
X$KCLCURST,4294951774,TABLE,271,
X$KCLRCVST,4294952020,TABLE,272,
X$OBJECT_AFFINITY_STATISTICS,4294952185,TABLE,273,
X$KCBLDRHIST,4294951707,TABLE,274,
X$KCBLSC,4294951612,TABLE,275,
X$KCCCP,4294951392,TABLE,276,
X$ESTIMATED_MTTR,4294951668,TABLE,277,
X$KCTLAX,4294952474,TABLE,278,
X$KCTICW,4294952476,TABLE,279,
X$TARGETRBA,4294951551,TABLE,280,
X$KCVFH,4294951072,TABLE,281,
X$KCVFHTMP,4294951522,TABLE,282,
X$KRBAFF,4294951455,TABLE,283,
X$KRBMSFT,4294952008,TABLE,284,
X$KRBMRST,4294952063,TABLE,285,
X$KRBMROT,4294952067,TABLE,286,
X$LOGMNR_LOGS,4294951536,TABLE,287,
X$LOGMNR_PARAMETERS,4294951538,TABLE,288,
X$LOGMNR_DICTIONARY,4294951537,TABLE,289,
X$LOGMNR_ROOT$,4294951751,TABLE,291,
X$LOGMNR_COL$,4294951752,TABLE,292,
X$LOGMNR_TAB$,4294951753,TABLE,293,
X$LOGMNR_OBJ$,4294951754,TABLE,294,
X$LOGMNR_DICT$,4294951755,TABLE,295,
X$LOGMNR_TS$,4294951756,TABLE,296,
X$LOGMNR_IND$,4294951757,TABLE,297,
X$LOGMNR_USER$,4294951758,TABLE,298,
X$LOGMNR_TABPART$,4294951759,TABLE,299,
X$LOGMNR_TABSUBPART$,4294951760,TABLE,300,
X$LOGMNR_TABCOMPART$,4294951761,TABLE,301,
X$LOGMNR_INDPART$,4294951762,TABLE,302,
X$LOGMNR_TYPE$,4294951763,TABLE,303,
X$LOGMNR_COLTYPE$,4294951764,TABLE,304,
X$LOGMNR_ATTRIBUTE$,4294951765,TABLE,305,
X$LOGMNR_ENCRYPTION_PROFILE$,4294951766,TABLE,306,
X$LOGMNR_ENCRYPTED_OBJ$,4294951767,TABLE,307,
X$KRVXDKA,4294952132,TABLE,308,
X$LOGMNR_SESSION,4294951638,TABLE,309,
X$LOGMNR_LATCH,4294952583,TABLE,310,
X$LOGMNR_DICTIONARY_LOAD,4294952586,TABLE,311,
X$LOGMNR_LOGFILE,4294951641,TABLE,312,
X$LOGMNR_PROCESS,4294951644,TABLE,313,
X$KRVXTX,4294951647,TABLE,314,
X$LOGMNR_CALLBACK,4294951634,TABLE,316,
X$KRVXSV,4294951832,TABLE,318,
X$KRVXTHRD,4294952195,TABLE,319,
X$LOGMNR_LOG,4294952199,TABLE,320,
X$KRVXWNMESG,4294952203,TABLE,321,
X$KCPXPL,4294951988,TABLE,322,
X$KRVSLV,4294951709,TABLE,323,
X$KRVSLVS,4294951712,TABLE,324,
X$KRVSLVPG,4294952172,TABLE,325,
X$KRVSLVST,4294952175,TABLE,326,
X$KRVSLVAS,4294952200,TABLE,327,
X$KRVSLVTHRD,4294952205,TABLE,328,
X$QUIESCE,4294951708,TABLE,329,
X$KCBVBL,4294951931,TABLE,330,
X$KRCFH,4294952009,TABLE,331,
X$KRCEXT,4294952010,TABLE,332,
X$KRCCDE,4294952011,TABLE,333,
X$KRCCDS,4294952012,TABLE,334,
X$KRCCDR,4294952131,TABLE,335,
X$KRCGFE,4294952013,TABLE,336,
X$KRCFDE,4294952014,TABLE,337,
X$KRCFBH,4294952015,TABLE,338,
X$KRCBIT,4294952016,TABLE,339,
X$KRCSTAT,4294952109,TABLE,340,
X$KRASGA,4294952214,TABLE,341,
X$KRFBLOG,4294952040,TABLE,342,
X$KRFGSTAT,4294952106,TABLE,343,
X$KRBZA,4294952709,TABLE,344,
X$KTADM,4294951013,TABLE,345,
X$KTATRFIL,4294952592,TABLE,346,
X$KTATRFSL,4294952593,TABLE,347,
X$KTATL,4294952594,TABLE,348,
X$KTCXB,4294951014,TABLE,349,
X$KTCSP,4294951984,TABLE,350,
X$KTSTSSD,4294951176,TABLE,351,
X$KTSSO,4294951251,TABLE,352,
X$KTSTFC,4294951520,TABLE,353,
X$KTSTUSC,4294952595,TABLE,354,
X$KTSTUSS,4294952596,TABLE,355,
X$KTSTUSG,4294952597,TABLE,356,
X$KTSPSTAT,4294951779,TABLE,357,
X$KTSKSTAT,4294951985,TABLE,358,
X$KTTEFINFO,4294952465,TABLE,359,
X$KTUGD,4294951683,TABLE,360,
X$KTURD,4294951022,TABLE,361,
X$KTUXE,4294951205,TABLE,362,
X$KTUSMST,4294951684,TABLE,363,
X$KTUSMST2,4294952111,TABLE,364,
X$KTUSUS,4294952619,TABLE,365,
X$KTURHIST,4294951986,TABLE,366,
X$KTTVS,4294951062,TABLE,367,
X$KTPRXRS,4294951457,TABLE,368,
X$KTPRXRT,4294951459,TABLE,369,
X$KTPRHIST,4294951987,TABLE,370,
X$KTFBFE,4294951515,TABLE,371,
X$KTFBHC,4294951516,TABLE,372,
X$KTFTHC,4294951518,TABLE,374,
X$KTFTME,4294951519,TABLE,375,
X$KTRSO,4294951688,TABLE,376,
X$KTIFP,4294952160,TABLE,377,
X$KTIFF,4294952161,TABLE,378,
X$KTIFB,4294952162,TABLE,379,
X$KTIFV,4294952163,TABLE,380,
X$KTCNREG,4294952202,TABLE,382,
X$KDNSSF,4294950965,TABLE,383,
X$KDXST,4294950966,TABLE,384,
X$KDXHS,4294950967,TABLE,385,
X$KDLT,4294951512,TABLE,386,
X$KQRST,4294950989,TABLE,387,
X$KQRPD,4294951155,TABLE,388,
X$KQRSD,4294951156,TABLE,389,
X$KQRFP,4294951449,TABLE,390,
X$KQRFS,4294951450,TABLE,391,
X$KQDPG,4294951098,TABLE,392,
X$KGLOB,4294950985,TABLE,393,
X$KGLLK,4294950986,TABLE,394,
X$KGLPN,4294950987,TABLE,395,
X$KGLST,4294950988,TABLE,396,
X$KGLAU,4294951112,TABLE,397,
X$KGLSN,4294951379,TABLE,398,
X$KGLTR,4294951033,TABLE,399,
X$KGLXS,4294951034,TABLE,400,
X$KGLRD,4294951187,TABLE,401,
X$KGLDP,4294951035,TABLE,402,
X$KGLNA,4294951064,TABLE,403,
X$KGLNA1,4294951150,TABLE,404,
X$KKSBV,4294951063,TABLE,405,
X$KKSSRD,4294951776,TABLE,406,
X$KGICC,4294951086,TABLE,407,
X$KQLSET,4294951230,TABLE,408,
X$KGICS,4294951087,TABLE,409,
X$KGLLC,4294951108,TABLE,410,
X$KQLFXPL,4294951672,TABLE,411,
X$KQLFSQCE,4294952031,TABLE,412,
X$KQLFBC,4294952034,TABLE,413,
X$MUTEX_SLEEP_HISTORY,4294952691,TABLE,414,
X$MUTEX_SLEEP,4294952692,TABLE,415,
X$VERSION,4294951029,TABLE,416,
X$KQFSZ,4294951069,TABLE,417,
X$KQFP,4294951240,TABLE,418,
X$DUAL,4294951241,TABLE,419,
X$KKSSQLSTAT,4294952660,TABLE,420,
X$KZDOS,4294951023,TABLE,421,
X$KZSRO,4294951024,TABLE,422,
X$KZSPR,4294951025,TABLE,423,
X$KZSRT,4294951115,TABLE,424,
X$KZRTPD,4294951771,TABLE,425,
X$CONTEXT,4294951495,TABLE,426,
X$GLOBALCONTEXT,4294951685,TABLE,428,
X$XML_AUDIT_TRAIL,4294952598,TABLE,429,
X$K2GTE2,4294951052,TABLE,430,
X$K2GTE,4294951032,TABLE,431,
X$KMMSI,4294950972,TABLE,432,
X$KMMDI,4294950973,TABLE,433,
X$KMMSG,4294950974,TABLE,434,
X$KMMDP,4294950975,TABLE,435,
X$KMMRD,4294950976,TABLE,436,
X$KMCQS,4294950970,TABLE,437,
X$KMCVC,4294950971,TABLE,438,
X$KKSAI,4294951197,TABLE,439,
X$KKSCS,4294951623,TABLE,440,
X$KXSCC,4294951188,TABLE,443,
X$KXSBD,4294951196,TABLE,444,
X$KXFPCST,4294951113,TABLE,445,
X$KXFPCMS,4294951117,TABLE,446,
X$KXFPSMS,4294951118,TABLE,447,
X$KXFPCDS,4294951119,TABLE,448,
X$KXFPSDS,4294951120,TABLE,449,
X$KXFPDP,4294951134,TABLE,450,
X$KXFPSST,4294951114,TABLE,451,
X$KXFPYS,4294951135,TABLE,452,
X$KXFPNS,4294951497,TABLE,453,
X$KXFPPFT,4294951661,TABLE,454,
X$KXFPBS,4294952167,TABLE,455,
X$KXFQSROW,4294951189,TABLE,456,
X$KSXAFA,4294951204,TABLE,457,
X$QESMMSGA,4294951737,TABLE,458,
X$QESMMIWT,4294951738,TABLE,459,
X$QESMMIWH,4294951829,TABLE,460,
X$QKSMMWDS,4294951739,TABLE,461,
X$QESMMAHIST,4294951847,TABLE,462,
X$QESMMAPADV,4294951850,TABLE,463,
X$QESRSTAT,4294951853,TABLE,464,
X$QESRSTATALL,4294951856,TABLE,465,
X$QKSCESYS,4294952029,TABLE,466,
X$QKSCESES,4294952030,TABLE,467,
X$KAUVRSTAT,4294952130,TABLE,468,
X$QESBLSTAT,4294952620,TABLE,469,
X$QKSBGSYS,4294952713,TABLE,470,
X$QKSBGSES,4294952714,TABLE,471,
X$KLPT,4294951232,TABLE,472,
X$KLCIE,4294951600,TABLE,473,
X$KVII,4294951127,TABLE,474,
X$KVIS,4294951128,TABLE,475,
X$KVIT,4294951129,TABLE,476,
X$KUPVJ,4294951945,TABLE,477,
X$KUPVA,4294951946,TABLE,478,
X$KNSTACR,4294951653,TABLE,479,
X$KNSTASL,4294951656,TABLE,480,
X$KNSTRPP,4294951721,TABLE,481,
X$KNSTMVR,4294951715,TABLE,482,
X$KNSTCAP,4294951837,TABLE,483,
X$KNSTRQU,4294951718,TABLE,484,
X$KNGFL,4294952119,TABLE,485,
X$KNGFLE,4294952668,TABLE,486,
X$KNSTTXN,4294952698,TABLE,487,
X$KNLAROW,4294951991,TABLE,488,
X$KNLASG,4294952701,TABLE,489,
X$TEMPORARY_LOB_REFCNT,4294951961,TABLE,490,
X$ABSTRACT_LOB,4294952581,TABLE,491,
X$KOCST,4294951374,TABLE,492,
X$UGANCO,4294951109,TABLE,493,
X$PRMSLTYX,4294951900,TABLE,494,
X$OPTION,4294951132,TABLE,495,
X$KWDDEF,4294951568,TABLE,496,
X$OPERATORS,4294952697,TABLE,497,
X$KWQPS,4294951907,TABLE,498,
X$KWQPD,4294951908,TABLE,499,
X$KWRSNV,4294951953,TABLE,501,
X$RULE_SET,4294952207,TABLE,502,
X$RULE,4294952208,TABLE,503,
X$BUFFERED_QUEUES,4294952070,TABLE,504,
X$BUFFERED_SUBSCRIBERS,4294952071,TABLE,505,
X$BUFFERED_PUBLISHERS,4294952072,TABLE,506,
X$BUFFER2,4294952679,TABLE,507,
X$BUFFER,4294952073,TABLE,508,
X$KWQBPMT,4294952159,TABLE,509,
X$HS_SESSION,4294951479,TABLE,510,
X$HOFP,4294951606,TABLE,511,
X$RFMP,4294951679,TABLE,512,
X$RFMTE,4294951680,TABLE,513,
X$VINST,4294951698,TABLE,514,
X$NSV,4294951808,TABLE,515,
X$XSAGGR,4294951891,TABLE,516,
X$XSSINFO,4294951894,TABLE,517,
X$XSAGOP,4294951888,TABLE,518,
X$XSOBJECT,4294951889,TABLE,519,
X$XSLONGOPS,4294952060,TABLE,520,
X$XSOQSEHI,4294952051,TABLE,521,
X$XSOQOJHI,4294952054,TABLE,522,
X$XSOQOPHI,4294952055,TABLE,523,
X$XSOQMEHI,4294952056,TABLE,524,
X$XSOQOPLU,4294952057,TABLE,525,
X$XSAWSO,4294951897,TABLE,526,
X$KFALS,4294951863,TABLE,527,
X$KFCBH,4294952608,TABLE,528,
X$KFCCE,4294952610,TABLE,529,
X$KFBH,4294952611,TABLE,530,
X$KFDSK,4294951879,TABLE,531,
X$KFDSK_STAT,4294952649,TABLE,532,
X$KFDAT,4294951859,TABLE,533,
X$KFGRP,4294951876,TABLE,534,
X$KFGRP_STAT,4294952650,TABLE,535,
X$KFGMG,4294951966,TABLE,536,
X$KFKID,4294951870,TABLE,537,
X$KFKLIB,4294952168,TABLE,538,
X$KFNCL,4294951871,TABLE,539,
X$KFTMTA,4294951860,TABLE,540,
X$KFFIL,4294951866,TABLE,541,
X$KFFXP,4294951869,TABLE,542,
X$KFDPARTNER,4294951979,TABLE,543,
X$KFCLLE,4294952609,TABLE,544,
X$KELTOSD,4294952097,TABLE,545,
X$KELTSD,4294952098,TABLE,546,
X$KELTGSD,4294952099,TABLE,547,
X$KEWEFXT,4294952100,TABLE,548,
X$KEWECLS,4294952568,TABLE,549,
X$KEWESMS,4294952569,TABLE,550,
X$KEWESMAS,4294952572,TABLE,551,
X$KEWRTB,4294951956,TABLE,552,
X$KEWX_SEGMENTS,4294952146,TABLE,554,
X$KEWX_LOBS,4294952147,TABLE,555,
X$KEWRSQLCRIT,4294952431,TABLE,559,
X$KEWRATTRSTALE,4294952427,TABLE,561,
X$ASH,4294952043,TABLE,564,
X$KEWASH,4294952044,TABLE,565,
X$KEWAM,4294952045,TABLE,566,
X$KEAOBJT,4294952021,TABLE,567,
X$KEACMDN,4294952022,TABLE,568,
X$KEWSSMAP,4294952564,TABLE,569,
X$KEWSSYSV,4294952565,TABLE,570,
X$KEWSSESV,4294952566,TABLE,571,
X$KEWSSVCV,4294952567,TABLE,572,
X$KEWMRWMV,4294952412,TABLE,573,
X$KEWMDRMV,4294952413,TABLE,574,
X$KEWMSEMV,4294952419,TABLE,575,
X$KEWMSVCMV,4294952425,TABLE,576,
X$KEWMFLMV,4294952420,TABLE,577,
X$KEWMEVMV,4294952421,TABLE,578,
X$KEWMRSM,4294952416,TABLE,579,
X$KEWMDSM,4294952417,TABLE,580,
X$KEWMGSM,4294952418,TABLE,581,
X$KEWMAFMV,4294952422,TABLE,582,
X$KEWMSMDV,4294952423,TABLE,583,
X$KELRTD,4294952602,TABLE,584,
X$KELRXMR,4294952702,TABLE,585,
X$KELRSGA,4294952703,TABLE,586,
X$KEHR,4294952512,TABLE,587,
X$KEHR_CHILD,4294952513,TABLE,588,
X$KEHRP,4294952514,TABLE,589,
X$KEHF,4294952515,TABLE,590,
X$KEHSQT,4294952521,TABLE,591,
X$KEHEVTMAP,4294952516,TABLE,592,
X$KEHECLMAP,4294952517,TABLE,593,
X$KEHSYSMAP,4294952518,TABLE,594,
X$KEHOSMAP,4294952522,TABLE,595,
X$KEHTIMMAP,4294952519,TABLE,596,
X$KEHPRMMAP,4294952520,TABLE,597,
X$JSKJOBQ,4294952128,TABLE,598,
X$JSKSLV,4294952116,TABLE,599,

--可以发现v$access涉及的对象都分析了。







来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-717912/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    2285
  • 访问量
    6025111