Hi


One of my table has got 3lakhs rows affected by row chaining.I have
browsed net for the steps that involes to remove the row chaining.They
have advised to move the table to the new segment.i.e:alter table move;
After that its showing no rows affted by row chaining.I have tested this
on the Test DB.

Consider the live database,every time we cant move the tables to remove
the row chaining ,its not advisable also.Because one cant permanantly
avoid RM/RC issues.If this is the case,how could I remove the row
chaining?
Also if we move the table from one segment to an another new segment,it
will create more undo data and more archive logs.

I have run a DB health check report on my live DB,it shows the Buffer
Cache Hit Rate as 55% . Iam suspecting the row chaining issues for this
low Buffer Cache Hit Rate,am I right ?please clear my doubt.
If row chaining is not the reason for low Buffer Cache Hit Rate,how do I
increase the Buffer Cache Hit Rate?
Help needed.



Oracle LazyDBA home page