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



Leave a Reply 0

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