Re: Monitoring shared pool in 11g
Date: Thu, 10 Oct 2013 16:20:28 -0700 (PDT)
Message-ID: <1be6bed9-9a02-439b-a4e1-ef768e8bcb7c_at_googlegroups.com>
On Thursday, October 10, 2013 2:31:21 AM UTC-4, vsevolod afanassiev wrote:
> In 9i it was possible to predict ORA-04031 errors by monitoring size of 'sql area' in the shared pool using V$SGASTAT( SELECT bytes FROM V$SGASTAT WHERE pool = 'shared pool' and name = 'sql area'). One had to take into account subpools - Tanel Poder came up with query against x$ksmss that allows to see this information for individual subpools. 9i has bugs that may cause size of 'miscellaneous' bucket to grow and 'sql area' to shink, once size of 'sql area' falls below certain threshold one gets ORA-04031.
>
>
>
> However in 11g (11.2.0.3 to be precise) shared pool components visible through V$SGASTAT have different names and there are more of them. Is there equivalent of 'sql area'? Or I am looking for something that no longer exists?
One of these days I a going to get around to taking a serious look at all the scripts Tanel has posted.
- Mark D Powell --