Search SSWUG.ORG:



DATABASES

'The Chain Gang', a Riveting Tale of Chained and Migrated Rows in Oracle This is an off-site link.  Please review our Terms of Service for additional information.


(David Fitzjarrell) Chained and migrated rows in an Oracle database can seriously impact I/O performance, especially with Exadata. In a 'normal' Oracle database [read that as "non-Exadata, non-ASM" database] chained rows, in small numbers where that usually means 1% or less of the total rows in a table, are generally a nuisance.

Read this article..







comments powered by Disqus