Re: Trying to understand PGA usage (20GB) for ONE process/session
Date: Mon, 13 Nov 2017 11:49:21 -0600
Message-ID: <CAP79kiQQ6gHqSWJoP7JAznLA+CLfJf8Shcx98Psv6fVkp-5tbg_at_mail.gmail.com>
Ah - 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
On Mon, Nov 13, 2017 at 11:43 AM, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:
> Chris,
>
> Use my second script to get details about session memory in Other category.
>
>
> --
> Best regards,
> Sayan Malakshinov
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 13 2017 - 18:49:21 CET