Oracle Study之--Oracle等待事件（1）
16:56:47 SYS@ test1>select * from v$latchname where upper(name) like '%BUFFER%';LATCH# NAME HASH
---------- ---------------------------------------------------------------- ----------
33 SGA IO buffer pool latch 2719726273
63 IPC stats buffer allocation latch 1449990452
106 KJC global post event buffer 3098969798
145 cache buffers lru chain 3559635447
146 buffer pool 510014793
150 cache buffers chains 3563305585
151 cache buffer handles 892398878
196 media recovery process out of buffers 2731251867
197 mapped buffers lru chain 93631960
208 lock DBA buffer during media recovery 3620457631
350 virtual circuit buffers 1577520421
378 parallel query alloc buffer 291345605
416 image handles of buffered messages latch 3223585260
441 KWQMN to-be-Stopped Buffer list Latch 3064249245
476 buffer pin latch 3925519355
15 rows selected.
Elapsed: 00:00:00.02
16:57:39 SYS@ test1>desc v$latch
Name Null? Type
----------------------------------------------------------------- -------- --------------------------------------------
ADDR RAW(8)
LATCH# NUMBER
LEVEL# NUMBER
NAME VARCHAR2(64)
HASH NUMBER
GETS NUMBER
MISSES NUMBER
SLEEPS NUMBER
IMMEDIATE_GETS NUMBER
IMMEDIATE_MISSES NUMBER
WAITERS_WOKEN NUMBER
WAITS_HOLDING_LATCH NUMBER
SPIN_GETS NUMBER
SLEEP1 NUMBER
SLEEP2 NUMBER
SLEEP3 NUMBER
SLEEP4 NUMBER
SLEEP5 NUMBER
SLEEP6 NUMBER
SLEEP7 NUMBER
SLEEP8 NUMBER
SLEEP9 NUMBER
SLEEP10 NUMBER
SLEEP11 NUMBER
WAIT_TIME NUMBER
16:58:18 SYS@ test1>select addr,name,hash,gets,misses from v$latch where hash='3559635447';
ADDR NAME HASH GETS MISSES
---------------- ---------------------------------------------------------------- -------
00000000600188A8 cache buffers lru chain 3559635447 359628 36
Elapsed: 00:00:00.03
16:59:03 SYS@ test1>select addr,name,hash,gets,misses from v$latch where hash in ('3559635447','3563305585','892398878');
ADDR NAME HASH GETS MISSES
---------------- ---------------------------------------------------------------- -------
00000000600188A8 cache buffers lru chain 3559635447 359652 36
000000006001A620 cache buffers chains 3563305585 43311894 21
000000006001A6C8 cache buffer handles 892398878 368 0
Elapsed: 00:00:00.03
页:
[1]