Hi, Kimberly: Thank you for your guide. I checked Metalink and find that is a bug. Bug No. 1397603. I think I will add the parameter _db_handles_cached to 1 later. I will also patch it to 8.1.7.2 too. Thank all of you. B.R.
> 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). ---------------------------------------------- 国内收费邮箱谁最强,首次权威评测见分晓 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).