What is Row Chaining ?
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 |
What are synonyms used for ?
How to divide query output into groups in oracle?
can u call user defined functions in select statements
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the Extension of Oracle Database? As extension of Access Database is .mdb
What is a Data Dictionary ?
State the various uses of dbcc command?
What is a public synonym?
What is different bet native dynamic sql and Dbms_Sql?
What is merge statement used for?
What is snapshot is too old? Give and example for better understand.