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.

Answer / dinesh

yes that's correct

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.

What are the commands youd issue to show the explain plan for select

2 Answers  

---

ABOUT IDENTITY?

0 Answers   HCL,

---

difference between bind variable and variable

1 Answers   Attra,

---

How to call a trigger inside a stored procedure?Give an example.

2 Answers  

---

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

What is a cursor in oracle?

0 Answers  

---

What are advantages fo Stored Procedures?

1 Answers  

---

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

---

What is SQL Tuning Advisor in Oracle?

0 Answers   MCN Solutions,

---

what are the disadvantages of hierarchial database over RDBMS?

1 Answers   TCS,

---

How to define an explicit cursor in oracle?

0 Answers  

---

What are the various constraints used in oracle?

0 Answers  

---