Hi All,
11.2.0.1
I am still resolving the locking issues in our database
Often the delete is blocked by some transaction.
The operations said that it is intermittent. Last night they were able to delete the 1M transactions without the locking.
But the past days lock often occurred, and they have to bounced the database to release the locks.
I there a way I can compare what happened last night why the batch was able to delete smoothly , and compare it against the other night where the delete was blocked?
By using ASH, AWR, ADDM?
I also run now this procedure, to identify the blocking sql statement:
SQL> exec dbms_workload_repository.add_colored_sql(sql_id => 'fn3qv2dhsu3nb');
PL/SQL procedure successfully completed.
Can I now run AWR,ASH,ADDM, to identify/capture the sql being run? Or I need to wait 1 hr? or more?
Thanks a lot,
zxy