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.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How many anonymous blocks can be defined?
How to define default values for formal parameters?
How to retrieve data from an explicit cursor?
What are the uses of a database trigger?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
List out the components of logical database structure of oracle database.
Whether any commands are used for months calculation? If so, what are they?
What is tns name?
How to invoke the original export import utilities?
What is varray?
What are the parameters that we can pass through a stored procedure?
What is Undo Management Advisor in Oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to define an anonymous procedure with variables?
What are triggers in oracle?
