Expand my Community achievements bar.

Help: Policy Server consuming Oracle resources with ANALYZE operations

Avatar

Former Community Member
Dear all,

we have a problem with APS 7.0.2 on Win 2003 server R2 that uses an Oracle instance on HP-UX (but I suppose the problem is not related to the specific operating systems).



Apparently, Policy Server periodically produces queries Oracle for statistics but the generated load is so high that the database cannot work for some time and sometimes it is necessary to stop Policy Server and/or the database daemon.



Is it possible to disable statistics collection?

How?

Anybody has the same problem?
0 Replies