Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What is Row Chaining ?

Answers were Sorted based on User's Feedback

What is Row Chaining ?..

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

What is Row Chaining ?..

Answer / dinesh

yes that's correct

Is This Answer Correct ?    7 Yes 0 No

What is Row Chaining ?..

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-

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

This is the concept of ROW chaining..

If this happen then we can reorg the object.

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Oracle General Interview Questions

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

0 Answers   CGI,

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

0 Answers  

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

0 Answers  

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

0 Answers  

What is autonomous transaction?

6 Answers  

What is oracle host variable?

0 Answers  

What is materialized view in Oracle?

0 Answers   MCN Solutions,

Explain what are the characteristics of data files?

0 Answers  

State the difference between a primary key and foreign key?

0 Answers  

How to create a new view in oracle?

0 Answers  

What is ceil and floor in oracle?

0 Answers  

How to export data with a field delimiter?

0 Answers  

  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)