344.In what view are you likely to see the following output?
SID SERIAL# EVENT SECONDS_IN_WAIT
121 269 RMAN backup & recovery I/O 2
129 415 SQL*Net message from client 63 130 270 SQL*Net message from client
A. V$SESSION_EVENT
B. V$SESSION
C. V$WAITS
D. V$WAITSTAT
E. V$SYSSTAT
Answer: B
SQL> select sid, serial#, event from v$session;
SID SERIAL# EVENT
---------- ---------- --------------------
1 1 pmon timer
2 1 VKTM Logical Idle Wa
it
3 1 DIAG idle wait
4 1 DIAG idle wait
5 1 rdbms ipc message
6 1 rdbms ipc message
7 1 rdbms ipc message
8 1 rdbms ipc message
9 5 rdbms ipc message
........
SQL> select sid, serial#, event, seconds_in_wait from v$session
2 /
SID SERIAL# EVENT SECONDS_IN_WAIT
---------- ---------- -------------------- ---------------
1 1 pmon timer 1
2 1 VKTM Logical Idle Wa 80508
it
3 1 DIAG idle wait 1
4 1 DIAG idle wait 1
5 1 rdbms ipc message 1
6 1 rdbms ipc message 1
7 1 rdbms ipc message 1232
8 1 rdbms ipc message 0
9 5 rdbms ipc message 89
SID SERIAL# EVENT SECONDS_IN_WAIT
---------- ---------- -------------------- ---------------
10 1 rdbms ipc message 27
12 1 Streams AQ: qmn coor 13
dinator idle wait
14 3 rdbms ipc message 4
16 1227 SQL*Net message from 10226
client
17 567 Space Manager: slave 2
idle wait
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2074516/
,如需转载,请注明出处,否则将追究法律责任。