Oracle Study之--Oracle等待事件（2）
17:05:40 SYS@ test1>select sid,event,p1,p2,p3,WAIT_TIME from v$session_wait where sid in (1,41);SID EVENT P1 P2 P3WAIT_TIME
---------- -------------------------------------------------- ---------- ---------- -----
1 latch: redo allocation 1993106152 182 0 -1
41 latch: cache buffers chains 2011026752 150 0 -1
Elapsed: 00:00:00.01
17:06:11 SYS@ test1>r
1* select sid,event,p1,p2,p3,WAIT_TIME from v$session_wait where sid in (1,41)
SID EVENT P1 P2 P3WAIT_TIME
---------- -------------------------------------------------- ---------- ---------- -------
1 log file switch (checkpoint incomplete) 0 0 0 3
41 buffer busy waits 4 4048 1 94
Elapsed: 00:00:00.01
17:06:16 SYS@ test1>r
1* select sid,event,p1,p2,p3,WAIT_TIME from v$session_wait where sid in (1,41)
SID EVENT P1 P2 P3WAIT_TIME
---------- -------------------------------------------------- ---------- ---------- -----
1 log file switch (checkpoint incomplete) 0 0 0 0
41 log file switch (checkpoint incomplete) 0 0 0 0
Elapsed: 00:00:00.02
17:06:18 SYS@ test1>r
1* select sid,event,p1,p2,p3,WAIT_TIME from v$session_wait where sid in (1,41)
SID EVENT P1 P2 P3WAIT_TIME
---------- -------------------------------------------------- ---------- ---------- ---------- ----------
1 log buffer space 0 0 0 0
41 log buffer space 0 0 0 0
Elapsed: 00:00:00.01
17:06:20 SYS@ test1>r
1* select sid,event,p1,p2,p3,WAIT_TIME from v$session_wait where sid in (1,41)
SID EVENT P1 P2 P3WAIT_TIME
---------- -------------------------------------------------- ---------- ---------- -----
1 log file switch (checkpoint incomplete) 0 0 0 134
41 log file switch (checkpoint incomplete) 0 0 0 3
Elapsed: 00:00:00.01
17:06:22 SYS@ test1>r
1* select sid,event,p1,p2,p3,WAIT_TIME from v$session_wait where sid in (1,41)
SID EVENT P1 P2 P3WAIT_TIME
---------- -------------------------------------------------- ---------- ---------- ---------- ----------
1 latch: cache buffers chains 2011026752 150 0 -1
41 latch: cache buffers chains 2011026752 150 0 -1
Elapsed: 00:00:00.01
页:
[1]