Re: Oracle & Swap?

From: bards <bards1888_at_yahoo.com.au.au>
Date: Tue, 27 Aug 2002 00:28:56 GMT
Message-ID: <3D6AC7C7.9010609@yahoo.com.au.au>

Sybrand Bakker wrote:
> On 26 Aug 2002 14:34:26 -0700, dtate_at_renalcaregroup.com (Daniel Tate)
> wrote:
>
>

>>Quick question regarding oracle and swap - When oracle loads on one of
>>my solaris (8) systems, it consumes physical memory + about 1 GB of
>>swap even though physical memory is plentiful   Is this normal?   What
>>causes it?

>
>
>
> Most likely an incorrect configured O/S
>
> issue the prtmem command and check whether file cache has been setup
> and how much memory it uses. I have to administer a system where a
> third party has made sure 80-90 percent of the physical memory goes to
> filecache and Oracle starts swapping immediately.
> This is NOT an Oracle problem as the cache is configured when the
> drives are mounted, so before Oracle starts.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Absolutely normal,

  solaris 8 immediately grabs the same amount of swap for the process size, so in the eventaulity of it needing to swap it already has the swap allocated.

If your SGA is 1gb, then solaris will 'reserve' 1 gb of swap just in case.

HTH. Received on Mon Aug 26 2002 - 19:28:56 CDT