Re: Oracle Tuning

cptkirkh wrote:
> I analyzed my tables and found numerous tables with a large number of
> chained rows. I would like to repair these and was wonderign how many
> i can repoar at one time or better yet how many should i repair at one
> time. I run Oracle 10g on Windows 2003 server.

There is no correct answer.

Have you figured what what is causing it? That is the first step. Look at PCTFREE, PCTUSED, data types, etc.

You fix them as quickly as you can without violating your agreement with your customers (SLA).

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org