Interested to Buy Any Domain ? << Click Here >> for more details...
What is Row Chaining ?
- 3 Answers
- 12996 Views
- Cognizant, CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / orawhiz
In Circumstances, all of the data for a row in a table may
not be able to fit in the same data block. When this occurs
, the data for the row is stored in a chain of data block
(one or more) reserved for that segment.
| Is This Answer Correct ? | 35 Yes | 0 No |
Answer / 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 |
What is raw datatype?
What is oracle data type?
What is oracle instant client?
what is the difference between oracle enterprise edition and oracle express edition?
How many file formats are supported to export data?
What are the different pseudo commands? Explain in general?
Can a parameter be passed to a cursor?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is a private synonym?
Explain the use of show option in imp command.
Whats the benefit of dbms_stats over analyze?
Oracle General 
