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).
