Re: limit oracle memory

From: NetComrade <>
Date: Sun, 26 Jul 2009 15:19:38 GMT
Message-ID: <>

On Sat, 25 Jul 2009 07:37:17 -0700 (PDT), Mark D Powell <> wrote:

>How much real memory does the server have?

>What memory settings have you used for each database instance?
16G ram, 16G swap

>Where do your applications run?

on other servers.

>What type of applications are these databases supporting?
mostly jboss.

>Any applications other than databases and normal OS processes running
>on the server?

no, but there are tons of scripts/"batch jobs"

>Have the administrator take a look at the sar data history. This
>should help determine if this was a one time issue caused by something
>running or if you have had a trend where spare capacity was declining.

It was a one time issue. It happens once every few months and very quickly, if it was a trend swap monitors would've caught it.

SGA max is under 2G
PGA target is 2G
sessions are limited to 555, but normally hovers around 100. total processes hover around 140-150

We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc) We use RMAN and remote catalog for backups Received on Sun Jul 26 2009 - 10:19:38 CDT

Original text of this message