Monitor usage of maxdsiz and maxssiz

[Deb Kauffunger]

We had a situation where a batch oracle report executing caused the server to
hit the limits on these parameters. A question has come up asking if it was
possible to monitor the usage so we would know if we were approaching another
problem. I found nothing in the Technical Knowledge database or in any of the
monitoring functions on the HP-UX level...anyone dealt with this before?? Any
suggestions??

[Dan Hull]

Keep in mind that these parameters are not system-wide limits, but rather
limits on individual processes.
maxssiz = max size of dynamic storage segments, which
is also known as the executing process's
run-time stack

maxdsiz = max size of the static data storage segment
of an executing process.

If you have large processes that hit these limits, they need to be increased.
You might be able to glean something from glance or measureware on how much of
this space a particular process is using at a given moment in time. But once
that process is completed, that number isn't relevant to the system as a whole.

[Tan Sf]

This site might be helpful on "Tuning Oracle on HP"

http://hpbbse.bbn.hp.com/tac/Oracle/html/tuning_oracle_on_hp.html#config