Re: LOCK_SGA on Oracle 8.1.7 (win2000)

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Fri, 8 Jul 2005 20:00:48 +0200
Message-ID: <42cebf51$0$11125$ba620e4c@news.skynet.be>

"Heini Nolsøe" <HNO_at_dlg.dk> wrote in message news:42ce3f3f$0$59778$edfadb0f_at_dread14.news.tele.dk...
> As mentioned before I have set up an Oracle 10G database to test LOCK_SGA.
> Just for the record ... there is no activitiy on this database, its just
> sitting there with no users connected and no batch jobs running.
>
> The system:
> Windows 2000 SP4
> 512 MB RAM
>
> I've watched the memory usage on the computer using Task Manager and
> Performance counters (Start>Settings>Control Panel>Administrative
> Tools>Performance). The Task Manager reports that the total memory usage
> on the system is about 450MB, wich in theory means that no swapping to
> the pagefile is needed. I have conducted a test by watching the memory
> usage on oracle.exe when changing LOCK_SGA from false to true:
<snip>

I believe Windows always uses the pagefile, even if you have plenty of RAM available ... Received on Fri Jul 08 2005 - 13:00:48 CDT