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

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Thu, 28 Mar 2013 10:51:57 +0200
Message-ID: <CAMHX9JJthmS_A6mfMtvT9R=4Y5wtp2vHWqBdMbYEFzitQ90-Pw_at_mail.gmail.com>

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_at_constellation.com> 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_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

>

>

>



--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 28 2013 - 09:51:57 CET