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 objects (table and indexes) I/O time is spent waiting for a lock on the object specified in the Object column.
| Description | |
| What to do next | Examine the statement in the Activity workspace. |
| Advice | To reduce the lock wait for the object, perform one of the following: n Check to see if the lock appears in the Current workspace. If so, examine the lock chain to identify which statement is holding the lock. n Try to identify the locking statement in the Activity workspace using smaller time frames that match the lock periods. Focus on the locked table and associated statements. The DML statements (and update queries) that are NOT waiting for locks should be the immediate suspects. |
No comments:
Post a Comment