OCP-1Z0-053-V12.02-344题
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
答案解析：
参考以下：
select SID,SERIAL#,EVENT,SECONDS_IN_WAIT from V$SESSION;rom V$SESSION;
SID SERIAL# EVENT SECONDS_IN_WAIT
---------- ---------- ---------------------------------------------------------------- ---------------
1 1 DIAG idle wait 0
2 1 rdbms ipc message 0
3 85 rdbms ipc message 59
7 2723 wait for unread message on broadcast channel 1
9 205 SQL*Net message to client 0
32 1 rdbms ipc message 2
33 5 rdbms ipc message 179
35 1 Streams AQ: qmn slave idle wait 28
37 1 SQL*Net message from client 226
38 1899 jobq slave wait 0
63 1 pmon timer 3
64 1 rdbms ipc message 3
65 3 rdbms ipc message 179
66 1 Streams AQ: waiting for time management or cleanup tasks 628
67 13 SQL*Net message from client 4
69 1143 jobq slave wait 0
94 1 rdbms ipc message 1
95 1 rdbms ipc message 1
96 9 SQL*Net message from client 9
98 3 Streams AQ: qmn coordinator idle wait 28
99 17 SQL*Net message from client 6
100 175 SQL*Net message from client 44
125 1 VKTM Logical Idle Wait 2404
126 1 rdbms ipc message 3
127 3 SQL*Net message from client 1
128 63 rdbms ipc message 1
129 23 Streams AQ: waiting for messages in the queue 2
156 49 RMAN backup & recovery I/O 0
157 1 rdbms ipc message 2
158 1 smon timer 298
159 21 rdbms ipc message 1
161 7 SQL*Net message from client 2169
162 85 Space Manager: slave idle wait 2
187 1 DIAG idle wait 1
188 1 rdbms ipc message 421
189 7 RMAN backup & recovery I/O 0
190 5 SQL*Net message from client 6
218 1 rdbms ipc message 2
219 1 rdbms ipc message 0
221 3 RMAN backup & recovery I/O 2
222 7 rdbms ipc message 180
224 7 SQL*Net message from client 2166
225 9 SQL*Net message from client 2030
43 rows selected.
版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]