Interested to Buy Any Domain ? << Click Here >> for more details...
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
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How do you bind variables in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What are the roles of dba?
How to create a table interactively?
How would you change old and new values in an insert, delete and update triggers?
How to do paging with oracle?
What is data file?
How to use "in" parameter properly?
How to select all columns of all rows from a table in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is user managed backup in Oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What are internal user account in oracle?
