Querying the DBA_WAITERS view will give us which vital piece of information that we can use to resolve lock contention in an emergency?
A . WAITING_SESSION
B . BLOCKING_SESSION
C. HOLDING_SESSION
D . SESSION_SID
Explanation:
Answer C: The DBA_WAITERS view also indicates the lock mode held, and the mode requested by the WAITING_SESSION. We can use the HOLDING_SESSION along with information from V$SESSION to issue the ALTER SYSTEM KILL SESSION command.
No comments:
Post a Comment