本文分析了通过SQL查询v$session_wait视图得到的输出结果，解释了SID为18的会话处于可恢复等待状态，对于理解Oracle数据库会话等待及错误清除过程有指导意义。
191
You observed the following output for a user session:
SQL > SELECT sid, event, seconds _in _wait FROM v$session _wait WHERE sid = 18;
SID EVENT SECONDS_IN_WAIT
- --------------- -----
18 statement suspended, wait error to be cleared 648
What do you infer from the preceding output?
A. Resumable set for session with sid 18
B. The user session has entered into a deadlock
C. The database instance is enabled to use asynchronous commit
You observed the following output for a user session:
SQL > SELECT sid, event, seconds _in _wait FROM v$session _wait WHERE sid = 18;
SID EVENT SECONDS_IN_WAIT
- --------------- -----
18 statement suspended, wait error to be cleared 648
What do you infer from the preceding output?
A. Resumable set for session with sid 18
B. The user session has entered into a deadlock
C. The database instance is enabled to use asynchronous commit
D. The threshold warning limit is exceeded for the tablespace that is used by the user session
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
