| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Deleting statistics
Has anyone had a problem in the past deleting statistics? I analyzed my
production database and performance suffered dramatically. We are running
8.0.5 on SunOS 5.6. The sar command shows lots of user time and wait i/o
that was not there prior to analyzing. I ran analyze <table> delete
statistics, but performance has not returned. Am I missing something? Is
there some bug in deleting statistics that I don't know about? I also
flushed the shared pool just in case some bad sqls where hanging out there
and I rebooted over the weekend, but performance is still poor.
I tried looking at Metalink, but it is unavailable at this time (shocking, I know...)
Thanks in advance for any suggestions.
Steve
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you are not the intended recipient, please do not read, copy, use or disclose the contents of this communication to others. Please notify the sender that you have received this e-mail in error by replying to the e-mail. Please then delete the e-mail and destroy any Received on Tue Nov 07 2000 - 10:38:56 CST
 |
 |