when you execute this where is the output displayed..
Thanks
Printable View
when you execute this where is the output displayed..
Thanks
hmm what output, do you know what is used for?!?!?
Quote:
Originally posted by netbar
when you execute this where is the output displayed..
HTH.Quote:
TST: SYS> exec DBMS_STATS.GATHER_DATABASE_STATS;
PL/SQL procedure successfully completed.
TST: SYS>
Hi,Quote:
Originally posted by netbar
when you execute this where is the output displayed..
Thanks
if you want to monitor the progress of sampling statistics then
select the last_analyzed-column in dba_indexes/dba_tables.
Normally the sys-packages do not make an output to console for viewing the progress of an operation;Code:SELECT count(dt.*) from dba_tables dt where dt.last_amalyzed > TRUNC(SYSDATE);
Orca
:cool:
Correction...Quote:
Originally posted by Orca777
Code:SELECT count(dt.*) from dba_tables dt where dt.last_amalyzed > TRUNC(SYSDATE);
HTH.Code:SELECT count(*) from dba_tables dt where dt.last_aNalyzed > TRUNC(SYSDATE);
Hi, thenks for correction!
Orca:cool: :cool: