Re: Fast Growing Shared Pool
- From: joshuasingham <joshuasingham@xxxxxxxxx>
- To: puravc@xxxxxxxxx
- Date: Tue, 10 Jul 2012 00:26:33 +0800
Hi Purav,
You should also check for KGH: NO ACCESS when you use ASMM you can
check metalink note below for more details
Common Cause for ORA-4031 in 10gR2, Excess "KGH: NO ACCESS" Memory
Allocation [Video] [ID 801787.1]
Regards
Joshua
https://twitter.com/joshuasingham
On Mon, Jul 9, 2012 at 10:38 PM, Purav Chovatia <puravc@xxxxxxxxx> wrote:
>
> 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.
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
