Re: Oracle Tuning

On Jul 24, 10:30 am, cptkirkh <kh..._at_scic.com> 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.

What is your db_block_size? How big are the objects? Have you searched the docs for the phrase "chained rows"?

If you have a 2K block size you probably want to start over with a new db.

jg

--
@home.com is bogus.
http://www.boeing.com/news/releases/2007/q3/070723a_nr.html