OCP CBT Question 587

Please solve the following question.

You are troubleshooting a performance issue where users report their updates are hanging. You suspect a blocking session. Which two views would you typically query together to identify sessions waiting for a lock held by another session?

Scenario A database administrator observes that several user sessions are experiencing significant delays when attempting DML operations on the `EMPLOYEES` table. The administrator suspects a blocking scenario is occurring.

V$LOCKED_OBJECT and V$SQL

V$SESSION and V$LOCK

V$TRANSACTION and V$ROLLSTAT

DBA_BLOCKERS and DBA_WAITERS

Scenario A database administrator observes that several user sessions are experiencing significant delays when attempting DML operations on the EMPLOYEES table. The administrator suspects a blocking scenario is occurring.

Scenario A database administrator observes that several user sessions are experiencing significant delays when attempting DML operations on the `EMPLOYEES` table. The administrator suspects a blocking scenario is occurring.