Can I delete some statisitcs table(s) from Oracle to tune it?

[Jason]

Does anyone know? Thanks so much.

[Daniel Roy]

Re: Can I delete some statisitcs table(s) from Oracle to tune it?

Your question isn't clear, please provide more details as to what you
want to achieve.

Daniel

[G M]

Re: Can I delete some statisitcs table(s) from Oracle to tune it?

To tune database? You probably want to know what the problems are
before trying to tune it. Usually people would analyze tables
periodically so the oracle optimizer would work properly.

HTH.

Guang


blueice1977@hot mail.com (Jason) wrote in message news:<f58b30d0. 0309231842.5f82 28c7@posting.go ogle.com>...

Does anyone know? Thanks so much.

[Michael Willer]

Re: Can I delete some statisitcs table(s) from Oracle to tune it?

Jason wrote:

Does anyone know? Thanks so much.

analyze table .... delete statistics, will delete the statistics.

But that wil not tune anything.


--
------------------------------------------------------------------------

*Michael Willer*
*Oracle & J2EE architect*