RE: wow lots of changes in sgastat in 11.2 versus 11.1

From: Jorgensen, Finn <Finn.Jorgensen_at_constellation.com>
Date: Wed, 27 Mar 2013 10:18:41 -0400
Message-ID: <9CE162BC5ED2C643956B526A7EDE46FF0390A6F0AAAA_at_EXM-OMF-04.Ceg.Corp.Net>



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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Hurley Sent: Wednesday, March 27, 2013 8:49 AM
To: oracle-l_at_freelists.org
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

--

http://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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 27 2013 - 15:18:41 CET

Original text of this message