Oracle has broken the instrumentation further down, as a cursor/libcache object consists of multiple different chunks in shared pool: KGLHD = library cache object handle (a handle is the entry point into any libcache object) KGLH0 = HEAP0 (object metadata heap) SQLA = SQL Area (cursor execution plan) -- *Tanel Poder* Enkitec (The Exadata Experts) Training <http://blog.tanelpoder.com/seminar/> | Troubleshooting<http://blog.tanelpoder.com/> | Exadata<http://www.amazon.com/Expert-Oracle-Exadata-Apress/dp/1430233923> | Voicee App <http://voic.ee/> On Wed, Mar 27, 2013 at 4:18 PM, Jorgensen, Finn < Finn.Jorgensen@xxxxxxxxxxxxxxxxx> wrote: > John, > > Looks like you hitting this bug: > > Bug 13250244 Shared pool leak of "KGLHD" memory when using multiple > subpools > > Thanks, > Finn > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of John Hurley > Sent: Wednesday, March 27, 2013 8:49 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: wow lots of changes in sgastat in 11.2 versus 11.1 > > Some people are always late to the party ... we have been working on an > 11.2 migration for a long time and just recently cut over. > My OLTP system just cutover from 11.1.0.7.x to 11.2.0.3.5 and a bunch of > my custom monitoring stuff now looks a whole lot different. > > I had some custom slicing and dicing of the contents of sgastat ( I query > it once an hour ) so I can keep an eye on stuff. Not a big believer in > Oracle changing stuff so everything is fixed size and my 11.2 shared pool > is a fair amount larger than my 11.1. > > To guard against 4031's my system monitors free memory and will force > shared pool flush when running low. No one at least on medium sized systems > should be absolutely petrified of a flush of the shared pool ... no you > don't want to do it often. > > Anyways there are so many different things now showing up in my 11.2 > sgastat areas ... what the heck is KGLHD and KGLH0? Why are KGLHD and KGLH0 > so large? > > Where is my PCursor and CCursor? 11.1 "sql area" not appears to be renamed > to "SQLA". > > Lots of things to learn here about what has changed in 11.2! > > Information below is just showing things that were larger than 50 meg ... > > *** 11.1.0.7.12 > > SUBPOOL NAME MB > shared pool (0 - Unused): free memory 224 shared pool (1): free memory > 757.25 shared pool (1): sql area 602.08 shared pool (1): CCursor 208.43 > shared pool (1): private strands 78.58 shared pool (1): event statistics > per sess 59.98 shared pool (1): PCursor 59.56 > > *** 11.2.0.3.5 ... > > SUBPOOL NAME MB > shared pool (0 - Unused): free memory 512 shared pool (1): KGLHD 972.88 > shared pool (1): SQLA 893.1 shared pool (1): free memory 591.51 shared pool > (1): KGLH0 505.61 shared pool (1): kkslLoadParentOnLock:lite 289.42 shared > pool (1): db_block_hash_buckets 178 shared pool (1): private strands 107.41 > shared pool (1): event statistics per sess 93.91 shared pool (1): ksunfy : > SSO free list 87.54 shared pool (1): kglhdusr 81.57 shared pool (1): dbktb: > trace buffer 78.13 shared pool (1): kkslBind_value 60.77 shared pool (1): > FileOpenBlock 55.83 shared pool (1): KTI-UNDO 55.55 shared pool (1): KGLS > 53.61 shared pool (1): KKSSP 51.18 > > > -- > //www.freelists.org/webpage/oracle-l > > > This e-mail and any attachments are confidential, may contain legal, > professional or other privileged information, and are intended solely for > the > addressee. If you are not the intended recipient, do not use the > information > in this e-mail in any way, delete this e-mail and notify the sender. -EXCIP > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l