| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: Where is the memory gone?
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: wintersun_zhao_at_21cn.com
>
> 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: ListGuru_at_fatcity.com (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: ksmith2_at_myfirstlink.net
>
> 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: ListGuru_at_fatcity.com (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: WinterSun Zha INET: wintersun_zhao_at_21cn.com 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: ListGuru_at_fatcity.com (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).Received on Sun Dec 09 2001 - 22:42:36 CST
 |
 |