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?!?!?

Quote:

---

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

---

Quote:

---

TST: SYS> exec DBMS_STATS.GATHER_DATABASE_STATS;

PL/SQL procedure successfully completed.

TST: SYS>

---

HTH.

Quote:

---

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
:cool:

Quote:

---

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:cool: :cool: