limit memory utilization per session

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 10 May 2007 13:11:57 -0400
Message-ID: <b3k643tp0iohv7s8lsuuf1urvh3l7h9bh8@4ax.com>

I looked at profiles, and you can only limit CPU/reads and 'private sga', which only applies to MTS.

We have a customer whose database crashes the whole box (kernel panic). They think it's due to memory overconsumption. None of the sar logs, or even 'pga snapshots' that we take indicate that.

Unfortunately, they're a bit reluctant to upgrade to the latest redhat version (they're on RH3U2). We want them to get to at least the latest redhat update on RH3 so that we could get crash dumps.

.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu May 10 2007 - 12:11:57 CDT