---------------------------------------
"KGH: NO ACCESS " 3822 MB 71%
"free memory " 343 MB 6%
"SQLA " 223 MB 4%
"gcs dynamic r " 146 MB 3%
"KGLH0 " 126 MB 2%
"gcs dynamic s " 98 MB 2%
"gc name table " 96 MB 2%
"ges resource " 78 MB 1%
"PRTMV " 68 MB 1%
"gcs resources " 65 MB 1%
-----------------------------------------
free memory 343 MB
memory alloc. 5033 MB
Sub total 5376 MB
==============================================
TOP 10 MEMORY USES FOR SGA HEAP SUB POOL 3
----------------------------------------------
"KGH: NO ACCESS " 3812 MB 80%
"free memory " 215 MB 5%
"SQLA " 112 MB 2%
"KGLH0 " 97 MB 2%
"ges resource " 80 MB 2%
"gcs resources " 66 MB 1%
"gcs shadows " 46 MB 1%
"PRTMV " 45 MB 1%
"KQR X PO " 44 MB 1%
"ges enqueues " 22 MB 0%
-----------------------------------------
free memory 215 MB
memory alloc. 4521 MB
Sub total 4736 MB
==============================================
TOP 10 MEMORY USES FOR SGA HEAP SUB POOL 4
----------------------------------------------
"KGH: NO ACCESS " 3557 MB 79%
"free memory " 367 MB 8%
"KQR L PO " 79 MB 2%
"KGLH0 " 76 MB 2%
"gcs resources " 66 MB 1%
"SQLA " 61 MB 1%
"gcs shadows " 45 MB 1%
"PRTMV " 39 MB 1%
"ges enqueues " 16 MB 0%
"KGLHD " 12 MB 0%
-----------------------------------------
free memory 367 MB
memory alloc. 4113 MB
Sub total 4480 MB
==============================================
TOP 10 MEMORY USES FOR SGA HEAP SUB POOL 5
----------------------------------------------
"KGH: NO ACCESS " 3689 MB 85%
"free memory " 215 MB 5%
"KGLH0 " 74 MB 2%
"gcs resources " 65 MB 2%
"gcs shadows " 44 MB 1%
"PRTMV " 40 MB 1%
"SQLA " 32 MB 1%
"ges enqueues " 24 MB 1%
"db_block_hash_buckets " 21 MB 0%
"KGLHD " 12 MB 0%
-----------------------------------------
free memory 215 MB
memory alloc. 4137 MB
Sub total 4352 MB
==============================================
TOP 10 MEMORY USES FOR SGA HEAP SUB POOL 6
----------------------------------------------
"KGH: NO ACCESS " 3685 MB 76%
"free memory " 240 MB 5%
"gcs dynamic s " 138 MB 3%
"flashback generation buff " 122 MB 2%
"SQLA " 116 MB 2%
"gcs dynamic r " 106 MB 2%
"KGLH0 " 91 MB 2%
"gcs resources " 64 MB 1%
"gcs shadows " 44 MB 1%
"PRTMV " 41 MB 1%
-----------------------------------------
free memory 240 MB
memory alloc. 4624 MB
Sub total 4864 MB
TOTALS ---------------------------------------
Total free memory 2005 MB
Total memory alloc. 28 GB
Grand total 30 GB
==============================================
There are 6 subpools created in the SGA and a high amount of memory is allocated to "KGH: NO ACCESS "
There are multiple bugs open on the same but on 11gR2 there is no actual fix.
SOLUTION
As a solution for the issue you can disable the use of durations.
The shared pool can have subpools with 4 durations. These durations are "instance", "session", "cur