Library cache

BUCKET 179:
  LIBRARY OBJECT HANDLE: handle=3124aee0 mutex=0x3124af94(0)
  name=
select snap_interval, retention,most_recent_snap_time, most_recent_snap_id, status_flag, most_recent_purge_time, most_recent_split_id, most_recent
_split_time, mrct_snap_time_num, mrct_purge_time_num, snapint_num, retention_num, swrf_version, registration_status, mrct_baseline_id, topnsql fro
m wrm$_wr_control where dbid = :dbid
  hash=6d31ce16f375b24a91e1323f36ec00b3 timestamp=01-05-2010 22:50:23
  namespace=CRSR flags=RON/TIM/PN0/LRG/DBN/MTX/[100100c1]
  kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=1 hpc=0000 hlc=0000
  lwt=0x3124af3c[0x3124af3c,0x3124af3c] ltm=0x3124af44[0x3124af44,0x3124af44]
  pwt=0x3124af20[0x3124af20,0x3124af20] ptm=0x3124af28[0x3124af28,0x3124af28]
  ref=0x3124af5c[0x3124af5c,0x3124af5c] lnd=0x3124af68[0x3124af68,0x3124af68]
    LIBRARY OBJECT last freed from HPD addn data CBK
  BUCKET 179 total object count=1
....
BUCKET 3491:
  LIBRARY OBJECT HANDLE: handle=2b71512c mutex=0x2b7151e0(1)
  name=select  FILE# , STATUS , CHANGE# , TIME from GV$BACKUP where inst_id = USERENV('Instance')
  hash=a8ef11a1f5921feca9026512456e0da3 timestamp=01-06-2010 01:00:07
  namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/KST/DBN/MTX/[500100d0]                                 --namspace
  kkkk-dddd-llll=0000-0001-0001 lock=0 pin=0 latch#=1 hpc=0000 hlc=0000
  lwt=0x2b715188[0x2b715188,0x2b715188] ltm=0x2b715190[0x2b715190,0x2b715190]
  pwt=0x2b71516c[0x2b71516c,0x2b71516c] ptm=0x2b715174[0x2b715174,0x2b715174]
  ref=0x2b7151a8[0x2b7151a8,0x2b7151a8] lnd=0x2b7151b4[0x2b710e88,0x2b71560c]
    LIBRARY OBJECT: bject=2c0eb1a8
    type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
    CHILDREN: size=16
    child#    table reference   handle                                                           --child
    ------ -------- --------- --------
         0 2c0eb134  2c0eade8 2b56e55c
  BUCKET 3491 total object count=1
...
BUCKET 4522:
  LIBRARY OBJECT HANDLE: handle=310d31b4 mutex=0x310d3268(0)
  name=SELECT OMS_ID, COUNT(QNAME) NQS_HANDLED FROM MGMT_NOTIFY_QUEUES WHERE OMS_ID <> 0 GROUP BY OMS_ID ORDER BY NQS_HANDLED ASC
  hash=fc030279bbe2e722e371624dff3611aa
  namespace=CRSR flags=RON/KGHP/PN0/MED/DBN/[50010040]
  kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=2 hpc=0000 hlc=0000
  lwt=0x310d3210[0x310d3210,0x310d3210] ltm=0x310d3218[0x310d3218,0x310d3218]
  pwt=0x310d31f4[0x310d31f4,0x310d31f4] ptm=0x310d31fc[0x310d31fc,0x310d31fc]
  ref=0x310d3230[0x310d3230,0x310d3230] lnd=0x310d323c[0x310d3020,0x310d40d0]
  BUCKET 4522 total object count=1
BUCKET 7715:
  LIBRARY OBJECT HANDLE: handle=2b57e70c mutex=0x2b57e7c0(2)
  name=
SELECT source,        (case when time_secs < 1 then 1 else time_secs end) as time_secs,        operation FROM   ( SELECT  1  as source,          
      trunc((sysdate - cast(ll.log_date as date)) * 86400)                   as time_secs,                 decode(ll.operation,                  
     'OPEN',  0                        ,  1 ) as operation,                 ll.log_id as log_id          FROM  DBA_SCHEDULER_WINDOW_LOG ll ,     
           ( SELECT max(l.log_id) as max_log_id                   FROM  DB
  hash=1cd97bc9248ccd0230a823ad235c1e23 timestamp=01-06-2010 00:01:05
  namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/KST/DBN/MTX/[100100d4]
  kkkk-dddd-llll=0001-0001-0001 lock=0 pin=0 latch#=1 hpc=0000 hlc=0000
  lwt=0x2b57e768[0x2b57e768,0x2b57e768] ltm=0x2b57e770[0x2b57e770,0x2b57e770]
  pwt=0x2b57e74c[0x2b57e74c,0x2b57e74c] ptm=0x2b57e754[0x2b57e754,0x2b57e754]
  ref=0x2b57e788[0x2b57e788,0x2b57e788] lnd=0x2b57e794[0x2b57d888,0x2b581ab8]
    LIBRARY OBJECT: bject=2c082dec
    type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
    CHILDREN: size=16
    child#    table reference   handle        
    ------ -------- --------- --------
         0 2c3a3830  2c3a34e4 2b57e628                                                                        --Child cur0
         1 2c3a3830  2c3a36a4 2b57de5c                                                                        --Child cur1
  BUCKET 7715 total object count=1
...

 

LIST OF HANDLES WITH DEPENDENTS:                                                                                 ==BEGIN LIST OF HANDLES WITH DEPENDENT
LATCH=0 unpin_call_count=1564 hd_count=668 hd_unpinned_count=1011                                                            --latch 0
3133e584 -> 31333340 -> 31332a4c -> 31330ec4 -> 31330bc8 -> 31330550 -> 3132883c -> 313272fc -> 3132523c -> 3132317c -> 313226bc -> 31321ccc -> 31
30b258 -> 3130ac68 -> 3130a68c -> 313014a8 -> 313010e8 -> 31306a58 -> 312f606c -> 31307638 -> 31305ef0 -> 312e836c
 -> 312e8130 -> 312acf98 -> 312a9040 -> 312a8d44 -> 312a8690 -> 312a7908 -> 312a5fa8 -> 3129b4dc -> 3129b324 -> 312f6c74 -> 3129ab20 -> 31298f6c -
> 31291a9c -> 3129012c -> 31284494 -> 31284fcc -> 31281120 -> 31280404 -> 3127feec -> 3127eecc -> 3127ebd0 ->
3127e2bc -> 3127d57c -> 3127d280 -> 31279b18 -> 31276718 -> 31274f20 -> 31273600 -> 3126af60 -> 312521d4 -> 3124e110 -> 312417b4 -> 31332750 -> 31
22f35c -> 31228f68 -> 31223e10 -> 3121eb9c -> 31218ac8 -> 3120c00c -> 312049dc -> 311f2638 -> 311f1768 -> 311e4f48
 -> 311e4df0 -> 311e4488 -> 311e4330 -> 311e2f08 -> 311e2448 -> 311e2040 -> 311e1ee8 -> 311e1988 -> 311d33ec -> 311d1288 -> 311cc3a8 -> 311cbfa0 -
> 311c914c -> 311c8af8 -> 311c8088 -> 311c7934 -> 311ab238 -> 311a80dc -> 3119d99c -> 3119ac10 -> 31197394 ->

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

转载于:http://blog.itpub.net/15072844/viewspace-627457/