Re: 804 Memory Usage on NT

From: David Sisk <davesisk_at_ipass.net>
Date: Wed, 7 Jul 1999 22:47:49 -0400
Message-ID: <dbUg3.28$w3.106@news.ipass.net>

Hmmm. I think you're SHARED_POOL looks a bit large in comparison to the DB_BLOCK_BUFFERS. Depends on your performance metrics, though. See my site for a script (CheckTuning.sql) that will give you some suggested numbers for SHARED_POOL_SIZE. Good luck,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

djbecker_at_my-deja.com wrote in message <7lvso4$g30$1_at_nnrp1.deja.com>...
>My Oracle server seems to be using much more memory than I think it
>should. The server has 256MB of RAM, and I am dedicating 96MB to
>DB_BLOCK_BUFFERS and 96MB to SHARED_POOL (192MB total). I currently
>have 111 logins and the total PGA/UGA for them is apprx 38MB. The V$SGA
>and V$SGASTAT views seem to pretty much agree with the above figures.
>
>However, NT is reporting that the Oracle process "Mem Usage" is
>231164 K, and the "VM Size" is 269040 K. I have been having a problem
>running out of virtual memory. Is there someone who can tell me what
>I'm missing?
>
>Thanks
>Dean Becker
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Jul 07 1999 - 21:47:49 CDT