Interested to Buy Any Domain ? << Click Here >> for more details...
What is Row Chaining ?
- 3 Answers
- 12849 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 get count of tables in particular database in Oracle?
What is the sid in oracle?
How can I introduce multiple conditions in like operator?
What are the different approaches used by Optimizer in choosing an execution plan ?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
How to check the oracle tns settings?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
Why is oracle database so popular?
Will you be able to store pictures in the database?explain.
What is Undo Management Advisor in Oracle?
A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
Oracle General 
