Re: When should I reorg?

wardellcastles wrote:
> At what point should a reorganization of a table be considered?
>
> I have a table that has 48 extents, and two indexes of 77 and 23
> extents each. The time required to read this table sequentially has
> dropped significantly recently after many new rows were added.
>
> The table is 334 meg and containst 41,785 blocks. The two indexes are
> 450 meg and 288 meg in size with 60,000 blocks and 36,000 blocks
> respectively.
>
> Thanks for all replies
> Wardell Castles

See also http://www.jlcomp.demon.co.uk/faq/table_frag.html (although it is a bit out of date [modern Oracle databases should use LMT's] and the SAFE link seems broken, try
http://metalink.oracle.com/metalink/plsql/docs/239049.PDF if you have support.) You should find out if you are using Locally Managed Tablespaces, and if not, use them.

jg

--
@home.com is bogus.
http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO1&Sect2=HITOFF&d=PALL&p=1&u=/netahtml/srchnum.htm&r=1&f=G&l=50&s1=6,935,954.WKU.&OS=PN/6,935,954&RS=PN/6,935,954