X-Received: by 10.182.22.107 with SMTP id c11mr3311656obf.46.1381386681845;
        Wed, 09 Oct 2013 23:31:21 -0700 (PDT)
X-Received: by 10.50.83.6 with SMTP id m6mr1182309igy.1.1381386681654; Wed, 09
 Oct 2013 23:31:21 -0700 (PDT)
Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!212.27.60.9.MISMATCH!proxad.net!feeder2-2.proxad.net!nx02.iad01.newshosting.com!newshosting.com!69.16.185.11.MISMATCH!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!a6no7864810qak.0!news-out.google.com!9ni24092qaf.0!nntp.google.com!i2no3792691qav.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.oracle.server
Date: Wed, 9 Oct 2013 23:31:21 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=203.13.128.104;
 posting-account=h2bfjgoAAAB8OxqMUJkSqT-KE-FeFQmL
NNTP-Posting-Host: 203.13.128.104
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <69ce7ca2-e6bc-41e6-abb5-29d1135be030@googlegroups.com>
Subject: Monitoring shared pool in 11g
From: vsevolod afanassiev <vsevolod.afanassiev@gmail.com>
Injection-Date: Thu, 10 Oct 2013 06:31:21 +0000
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 1810
Xref:  news.cambrium.nl

In 9i it was possible to predict ORA-04031 errors by monitoring size of 'sq=
l area' in the shared pool using V$SGASTAT( SELECT bytes FROM V$SGASTAT WHE=
RE pool =3D 'shared pool' and name =3D 'sql area'). One had to take into ac=
count subpools - Tanel Poder came up with query against x$ksmss that allows=
 to see this information for individual subpools. 9i has bugs that may caus=
e 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 thro=
ugh V$SGASTAT have different names and there are more of them. Is there equ=
ivalent of 'sql area'? Or I am looking for something that no longer exists?