Tuesday, June 14, 2011

Many Chained Rows Wait

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


 Access to table deteriorated as a result of chained rows.
Many Chained Rows findings

Description
What to do next
Examine table dictionary information.
Advice
The object is suffering because it is accessing an object that suffers from chained rows. Chained rows are typically caused by the Insert operation. To solve the problem, perform one of the following:
n   Increase the PCTFREE parameter (can be by alter or move table).
n   Reorganize table (export/import or manually reorganize table).
n   Move table to tablespace with higher block size.



Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: