Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: limit memory utilization per session
On May 10, 1:11 pm, NetComrade <netcomradeNS..._at_bookexchange.net>
wrote:
> 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
"database crashes the whole box " sounds like an H/W or O/S problem to me. I have experienced similar behavior on a RH3U3 box. Eventually the sys admin discovered that one of the HBAs was at fault. Received on Thu May 10 2007 - 12:42:54 CDT
![]() |
![]() |