What do you infer from the preceding output?

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?

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

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

Justyna

Justyna

V$SESSION_WAIT – When a statement is suspended the session invoking the statement is put into a wait state. A row is inserted into this view for the session with the EVENT column containing “statement suspended, wait error to be cleared”.

Managing Resumable Space Allocation
Using Views to Obtain Information About Suspended Statements

http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm#autoId14

Reply