exec DBMS_STATS.GATHER_DATABASE_STATS;

**netbar** · 03-19-2003 04:32 AM

when you execute this where is the output displayed..

Thanks

**pando** · 03-19-2003 04:34 AM

hmm what output, do you know what is used for?!?!?

**ggnanaraj** · 03-19-2003 05:00 AM

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.

**Orca777** · 03-19-2003 05:08 AM

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

Thanks

Hi,
if you want to monitor the progress of sampling statistics then
select the last_analyzed-column in dba_indexes/dba_tables.

Code:

SELECT count(dt.*) from dba_tables dt where dt.last_amalyzed > TRUNC(SYSDATE);

Normally the sys-packages do not make an output to console for viewing the progress of an operation;

Orca

**ggnanaraj** · 03-19-2003 05:16 AM

Originally posted by Orca777

Code:

SELECT count(dt.*) from dba_tables dt where dt.last_amalyzed > TRUNC(SYSDATE);

Correction...

Code:

SELECT count(*) from dba_tables dt where dt.last_aNalyzed > TRUNC(SYSDATE);

HTH.

**Orca777** · 03-19-2003 05:17 AM

Hi, thenks for correction!
Orca

Thread: exec DBMS_STATS.GATHER_DATABASE_STATS;