exec DBMS_STATS.GATHER_DATABASE_STATS;

[ggnanaraj]

Originally posted by netbar
when you execute this where is the output displayed..

TST: SYS> exec DBMS_STATS.GATHER_DATABASE_STATS;

PL/SQL procedure successfully completed.

TST: SYS>

HTH.