Interested to Buy Any Domain ? << Click Here >> for more details...
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
When do we use group by clause in a sql query?
Explain an integrity constrains?
What is the difference between Delete, Truncate and Drop in Oracle?
What happens to the indexes if a table is recovered?
What is ASM (Automatic Storage Management) in Oracle?
What are nested tables?
What is backup in Oracle?
What is meant by recursive hints in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How to convert times to characters in oracle?
Which is better Oracle or MS SQL? Why?
What happens to indexes if you drop a table?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to grant create session privilege to a user in oracle?
How many data types are supported?
