Answer Posted / 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.

Whats the benefit of dbms_stats over analyze?

2064

---

Explain the use of online redo log files in oracle.

1077

---

Which are the five query types available in oracle?

999

---

How to use regular expression in pattern match conditions in oracle?

1075

---

What is the string concatenation operator in oracle?

1230

---

Does facebook use oracle?

1084

---

ABOUT IDENTITY?

2109

---

Explain a segment?

1131

---

What privilege is needed for a user to insert rows to tables in another schema?

1056

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1803

---

How to use "startup" command to start default instance?

1101

---

Explain the use of ignore option in imp command.

1086

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2956

---

What is a lookup table in oracle?

1024

---

What is ASM (Automatic Storage Management) in Oracle?

1244

---