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.

How to put more than 1000 values into an oracle in clause?

1029

---

What is clustered table in Oracle?

1196

---

Name the various constraints used in oracle?

1019

---

what is the scenario where you take the database to NoArchivelog mode?

2330

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2324

---

Explain an index?

1134

---

How to retrieve the count of updated rows?

1126

---

How remove data files before opening a database?

1072

---

Define oracle database

1043

---

Explain the use of full option in exp command.

1116

---

How to create a table interactively?

1088

---

How to start instance with a minimal initialization parameter file?

1040

---

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1840

---

defination of bitmap index

2124

---

Explain the use of analyse option in exp command.

1127

---