Re: Trying to understand PGA usage (20GB) for ONE process/session
Date: Mon, 13 Nov 2017 19:01:19 +0100 (CET)
Message-ID: <2105300473.142780.1510596079523_at_ox.hosteurope.de>
Hey Chris,
this looks like an application issue with LOBs (and/or possibly bug #16562669).
SYS_at_T122DB:340> oradebug doc component
...
Components in library GENERIC:
--------------------------
LOB LOB (koll, kola)
LOB_Refcount LOB Refcount (kolr)
LOB_Default LOB Default (koll, kole, kokl, koxs)
LOB_DBLINK LOB DBLink (koll, kokl, kpolobr, kkxlr)
...
Now you can use DTrace or SystemTap (depending on your OS platform) to capture these memory allocations and find the corresponding PL/SQL code lines :-)
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: _at_OracleSK
Chris Taylor <christopherdtaylor1994_at_gmail.com> hat am 13. November 2017 um 18:49 geschrieben:-- http://www.freelists.org/webpage/oracle-l Received on Mon Nov 13 2017 - 19:01:19 CETAh - interesting.Here's the top 5 results from v$process_memory_detail for the session in question:
PID
SERIAL#
CATEGORY
NAME
HEAP_NAME
BYTES
ALLOCATION_COUNT
HEAP_DESCRIPTOR
PARENT_HEAP_DESCRIPTOR
CON_ID
805
172
Other
permanent memory
kokltcr: creat
14992660744
5421390
00007FEAAFAE8A08
00007FF121AE41B0
0
805
172
Other
kollrsz
koh-kghu sessi
9835595392
602376
00007FF121C94408
00007FF12449CF60
0
805
172
Other
free memory
session heap
736917640
293250
00007FF12449CF60
00007FF128D1ADC0
0
805
172
Other
kokltcr: create clob
koh dur heap d
669923552
3614260
00007FF121AE41B0
00007FF12449CF60
0
805
172
Other
pl/sql vc2
koh-kghu sessi
208002392
12739
00007FF121C94408
00007FF12449CF60
0