| 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: Where is the memory gone?
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
-- 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-LReceived on Sun Dec 09 2001 - 20:42:38 CST
(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).
 |
 |