Interested to Buy Any Domain ? << Click Here >> for more details...
What is Row Chaining ?
- 3 Answers
- 12898 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 meant by redo log buffer ?
How to select all columns of all rows from a table in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How can we Update a table with out using UPDATE command?
What is the usage of control file in oracle?
Explain oracle’s server parameter file.
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
waht is the difference between primary key and super key?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to create a server parameter file?
How will you identify oracle database software release?
How to rename an index in oracle?
Oracle General 
