What is Row Chaining ?

Answer Posted / pabitra kumar khatoi

In Row chaining basically it happens on the pctused case.
I.e for row insertion case. IF the insert(required) row
size is greater than the available row size then the value
will go to next row . Similarly again if the next row size
is greater than the available row size then the value will
go to next row in a CHAINED manner.That is called Row-
Chaining.

So there is a view called DBA_tables/USER_tables we can get
the column name avg-row_length and chain_cnt .
In the above cloumn we can get the no of row
chaining........

This is the concept of ROW chaining..

If this happen then we can reorg the object.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by merge in oracle?

570


Explain the different normalization forms?

570


When do you get a .pll extension in oracle?

648


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1786


How to export data to a csv file?

594






How to commit the current transaction in oracle?

551


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2150


Explain the use of tables option in exp command.

575


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1433


How to install oracle odbc drivers?

593


What are the different pseudo commands? Explain in general?

522


How to work with data objects interactively?

531


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1506


What is the difference between alert log file and tarce file ?

1616


How to delete a column in an existing table?

572