1) Not necessarily. Those measures can help, however, but there are not just a few statments to
fix fragmentation issues. Segment storage parameters can play a bigger role in keeping
fragmentation down. I suggest reviewing an excellent paper -
http://technet.oracle.com/deploy/availability/pdf/defrag.pdf

2) Review how to use 'analyze table' command. It has various options.

HTH,

- Kirti



--- "Borgoglio, Francesco" <F.[Email Address Removed] wrote:
> Hi all,
> i have two questions to ask you, about database management.
>
> 1) First of all i ask to you if the "alter tablespace coalesce", "alter
> table deallocate unused" and "alter index deallocate unused" are just good
> and sufficient to resolve tables and indexes fragmentation, or there are
> other statements that i ignore.
>
> 2) My second request is about right sql statements to run update statistics
> on my Oracle databases, release 7.3.4 and 8.1.7.
>
> Thank you so much for your help.
>
>
>
>
> Francesco Borgoglio
> CEDACRI S.p.A. - Sede di Castellazzo - 15073 Alessandria
> Tecnologie e Sistemi Distribuiti
> tel: +390131-272457
> fax: +39 0131-270922
> f.[Email Address Removed]
>

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
Oracle LazyDBA home page