This sound pretty much like the same problem I had with 8.1.7 on HP.
They have a memory leak when you connect/disconnect and it you have
a lot of those you start to see it in your SGA. I had to patch to
8.1.7.1 plus an additional bug fix. Check on Metalink to see if there
is the same problem with Windows. It also could be that you really
do need more then 50M. Pin in the bigger packages you use (including
Oracle's) right after startup and see where you are memory wise.
-----Original Message-----
Zhao
Sent: Sunday, December 09, 2001 5:30 PM
To: Multiple recipients of list ORACLE-L
Hi, DBAs:
I find that one of our database's Shared Pool's memory decreased every
day.
It is Oracle 8.1.7 on Windows 2K, with 512M Physical memory.
When I check v$sgastat, I find the "miscellaneous" part of "shared pool"
increased every day, it begans with 500K, then, after two days, it increased
to 5586228 bytes, after about 10 days, it increased to 40M, and because I
had allocated 50M to the Shared Pool, So the memory available became less
and less. And I had to shutdown and restart the database when the available
memory of shared pool is below 5M.
I want to know why the memory occupied by "miscellaneous" part is
increased? The other database on solaris did not increased. How can I find
out what is it? How to prevent it or resolve it without shutdown and restart
the database? ( alter system flush shared pool only flush the sql and
library cache, and it didn't decrease the miscellaneous part's memory
usage. )
Thank you very much!
WinterSun
----------------------------------------------
国内收费邮箱谁最强，首次权威评测见分晓
http://news.21cn.com/domestic/21CN/2001-11-19/550568.html
买企业邮箱，获赠域名
http://mail.21cn.com/corporation/010.html
收费邮箱真能大行其道，给我一个理由
http://mail.21cn.com/bijiao/index2-7.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: WinterSun Zha
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
