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 can I convert single byte kana characters into multi byte kana characters and vice-versa.
What privilege is needed for a user to create tables in oracle?
How do you tell what your machine name is and what is its IP address?
How many memory layers are in the oracle shared pool?
How to get execution statistics reports on query statements?
What is blob datatype?
Explain an integrity constrains?
What is the Tune Query
Explain the different normalization forms?
How to write an inner join with the where clause in oracle?
Explain about achiever in sql?
How to get a list of all background sessions in the database?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the four Oracle system processes that must always be up and running for the database to be useable?
1) Does oracle have any table which contain all the exceptions and it's code internally?
