Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Much of the instance time is spent waiting for a lock on the cluster.
| Description | |
| What to do next | Examine the lock for the statement in the Activity workspace. |
| Advice | To reduce the lock wait for the table, consider the following solutions: n Check if the lock appears in the Current workspace. If so, examine the lock chain to discover the statement holding the lock. n Try to identify the locking statement in the Activity workspace, using narrow time frames that match the lock periods. Focus on the locked table and associated statements. The immediate suspect is the DML statements (and update queries) that are not waiting for locks. |
No comments:
Post a Comment