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 In Oracle time is spent waiting for a lock on the table.
| Description | |
| What to do next | Perform one of the following options: n To extensively tune the object, go to the Tune Object workspace. n 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 which statement is 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 its associated statements. The immediate suspect is the DML statements (and update queries) that are not waiting for locks. |
No comments:
Post a Comment