Re: Information on Reorganizing Large Tables on 8i and 9i

basis_consultant_at_hotmail.com (SAP BASIS Consultant) wrote in message news:<dd2036f3.0404051052.2d0f3a9a_at_posting.google.com>...
> Hello,
>
> Thanks to all those who took the time to answer my previous question
> regarding the rebuilding of online indexes.
>
> I have reorganized small and medium sized tables (Say, up to 500MS or
> so) in Oracle 7.x, 8.0.x, and 8.i.
>
> Now, it looks like I will be doing so with larger tables (Say, 1GB to
> 10GB+) on AIX. The tables will likely be composed mainly (Or all) of
> VARCHAR fields; Few, if any, will have LOBs.
>
> (Yes, I understand that my artibrary concept of small, medium-sized,
> and large tables my be differ from other peoples'....)
>
> I tried to find some documentation, both online and in a bookstore,
> regarding issues associated with reorganizing large tables (How to
> improve performance, prevent potential problems, etc..), but I did
> not find much.
>
> Does anybody recommend any Website, article, or book dealing with
> these issues?

asktom.oracle.com, and any book by Tom Kyte. http://www.jlcomp.demon.co.uk/ and Practical Oracle 8i by Lewis Partitioning in the concepts manual and performance guides from Oracle.

http://www.psoug.org/reference/partitions.html
http://www.peasland.net/page3.html
http://www.kevinloney.com/freebies.htm
http://www.dbazine.com/ensor1.html

Just off the top of my head.

jg

--
@home.com is bogus.
Now here's someone who likes baseball: 
http://www.signonsandiego.com/uniontrib/20040405/news_mz1c5seasons.html