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]Oracle LazyDBA home page