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, SECONDS_IN_WAIT from V$SESSION_EVENT;
select SID, SERIAL#, EVENT, SECONDS_IN_WAIT from V$SESSION_EVENT
*
第 1 行出现错误:
ORA-00904: "SECONDS_IN_WAIT": 标识符无效
SQL> select SID, SERIAL#, EVENT, SECONDS_IN_WAIT from V$waits;
select SID, SERIAL#, EVENT, SECONDS_IN_WAIT from V$waits
*
第 1 行出现错误:
ORA-00942: 表或视图不存在
SQL> select SID, SERIAL#, EVENT, SECONDS_IN_WAIT from V$waitstat;
select SID, SERIAL#, EVENT, SECONDS_IN_WAIT from V$waitstat
*
第 1 行出现错误:
ORA-00904: "SECONDS_IN_WAIT": 标识符无效
SQL> select SID, SERIAL#, EVENT, SECONDS_IN_WAIT from V$sysstat;
select SID, SERIAL#, EVENT, SECONDS_IN_WAIT from V$sysstat
*
第 1 行出现错误:
ORA-00904: "SECONDS_IN_WAIT": 标识符无效
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2126018/ ，如需转载，请注明出处，否则将追究法律责任。
