Interested to Buy Any Domain ? << Click Here >> for more details...
What is Row Chaining ?
- 3 Answers
- 12710 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 |
How to create lov dynamically at runtime & attach to text field?
In what script is snap$ created? In what script is the scott/tiger schema created?
What do you mean by merge in oracle and how can we merge two tables?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
How to retrieve data from an cursor to a record?
How do I spool in oracle?
What is raw datatype?
How to call a sub procedure?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How to assign a table row to a record variable?
What is enter substitution variable in oracle?
What are the trigger associated with image items ?
Oracle General 
