Get started Bring yourself up to speed with our introductory content.

The Oracle Guru Answer #18

Did you guess correctly? Check your answer to this week's quiz.

Were you correct? This week's answer is:
c. row chaining

Row chaining occurs when a VARCHAR2 value is updated and the length of the new value is longer than the old value and won't fit in the remaining block space. This results in the row chaining to another block. It can be reduced by setting the storage parameters on the table to appropriate values. It can be corrected by export and import of the effected table.

For More Information

Expert response: 26 must-know performance tuning solutions

Expert response: Why can't size of primary key exceed one database block?

Do you have an idea for a quiz question topic? Let us know!


Dig Deeper on Oracle DBA jobs, training and certification

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close