Fast Growing Shared Pool
From: Purav Chovatia <puravc_at_gmail.com>
Date: Mon, 9 Jul 2012 20:08:41 +0530
Message-ID: <CADrzpjGOX91CaPEugAb+yHKFAuJ6KkxFxQXw0kwKBqN_Jds=rQ_at_mail.gmail.com>
Hi,
We have a 10205 database on Solaris SPARC with ASMM enabled and sga_target & sga_max_size = 4G. What we observe is that shared_pool has grown from 700MB to 1.6GB in last 3 months whereas buffer cache has shrunk from 3.3G to 2.5G. This inspite of the database having to do physical reads i.e some of the hot objects not fitting in the buffer cache. What could be the reason?
How do I find what is the breakup of the so big shared pool? (There are no bind variable issues)
Date: Mon, 9 Jul 2012 20:08:41 +0530
Message-ID: <CADrzpjGOX91CaPEugAb+yHKFAuJ6KkxFxQXw0kwKBqN_Jds=rQ_at_mail.gmail.com>
Hi,
We have a 10205 database on Solaris SPARC with ASMM enabled and sga_target & sga_max_size = 4G. What we observe is that shared_pool has grown from 700MB to 1.6GB in last 3 months whereas buffer cache has shrunk from 3.3G to 2.5G. This inspite of the database having to do physical reads i.e some of the hot objects not fitting in the buffer cache. What could be the reason?
How do I find what is the breakup of the so big shared pool? (There are no bind variable issues)
Thanks.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 09 2012 - 09:38:41 CDT