What is Row Chaining ?
- 3 Answers
- 11421 Views
- Cognizant, CTS, I also Faced
- E-Mail Answers
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 |
Explain oracle instance.
What is the scope of a local variable?
why pl sql doesn't support retrieving multiple records
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
When can Hash Cluster used ?
what is the syntax of SELECT command?
Explain the difference between sap and oracle?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
Differentiate between function and procedure in oracle.
What is the difference between post-database commit and post-form commit?
Why do you create or replace procedures rather that drop and recreate.
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
Oracle General 
