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
What do you mean by merge in oracle?
Explain the different normalization forms?
When do you get a .pll extension in oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to export data to a csv file?
How to commit the current transaction in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Explain the use of tables option in exp command.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How to install oracle odbc drivers?
What are the different pseudo commands? Explain in general?
How to work with data objects interactively?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is the difference between alert log file and tarce file ?
How to delete a column in an existing table?