-
exec DBMS_STATS.GATHER_DATABASE_STATS;
when you execute this where is the output displayed..
Thanks
-
hmm what output, do you know what is used for?!?!?
-
Re: exec DBMS_STATS.GATHER_DATABASE_STATS;
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.
-
Re: exec DBMS_STATS.GATHER_DATABASE_STATS;
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
-
Re: Re: exec DBMS_STATS.GATHER_DATABASE_STATS;
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.
-
Hi, thenks for correction!
Orca
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|