Re: SGA in memory

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Tue, 16 Mar 1999 20:11:58 +0000
Message-ID: <36EEBB0E.50A344F@rdbms.freeserve.co.uk>

Tay,

You can try pre_page_sga = true, this will try and load all the pages need by the sga into memory.

One interesting point, if you are running on MVS, this doesn't matter as the extended memory that your sga could get paged too is very fast anyway.

Chris

Tay Khoon Guan wrote:
>
> Hi,
>
> How will I know if my SGA is in the main memory but not in the swap space
> so that I can tune the sga to fit into the memory.
>
> Is there any ways to pin my sga to the memory?
>
> Thanks.
Received on Tue Mar 16 1999 - 14:11:58 CST