Automated stats gathering

10g has our auto stats collection. But how do you know if it running. Is there a table to check apart from last_analyzed from user/dba_tables?

thanks

Enterprise Manager-> Administration-> Statistics Management-> Manage Optimizer Statistics
:rolleyes:

Quote:

---

Originally Posted by LKBrwn_DBA

Enterprise Manager-> Administration-> Statistics Management-> Manage Optimizer Statistics
:rolleyes:

---

Thanks...but this is assuming you have EM. Is there any table/feature to check right off the database/sqlplus?

you already said it yourself, user/dba_tables

Check dba_scheduler_jobs

Regards

Quote:

---

Originally Posted by Tuma

Thanks...but this is assuming you have EM. Is there any table/feature to check right off the database/sqlplus?

---

EM is included in all 10g+ databases, just install it:

Code:

---

$ emca -config dbcontrol db -repos create

---

:rolleyes:

[QUOTE=LKBrwn_DBA;260701]EM is included in all 10g+ databases, just install it:

Code:

---

$ emca -config dbcontrol db -repos create

---

QUOTE]
Does this need to be licensed?

Quote:

---

Originally Posted by Tuma

Does this need to be licensed?

---

Did you check Oracle Licensing? -guess not, here http://www.oracle.com/corporate/pricing/pricelists.html