RE: wow lots of changes in sgastat in 11.2 versus 11.1
- From: "Jorgensen, Finn" <Finn.Jorgensen@xxxxxxxxxxxxxxxxx>
- To: "hurleyjohnb@xxxxxxxxx" <hurleyjohnb@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Mar 2013 10:18:41 -0400
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
Other related posts:
