Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> analyze problems
oracle 7.3.4
HP-UX B.10.20
I ran the analyze table command on a few tables(3 of 300). Over time (1
week) the system degrade to unacceptable levels(slow response times to
database access).
I removed the stats and the application ran well(response times acceptable).
Anyone know why?
rocr Received on Fri Jan 26 2001 - 07:09:46 CST