Re: Trying to understand PGA usage (20GB) for ONE process/session

  • From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
  • To: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • Date: Mon, 13 Nov 2017 11:49:21 -0600

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@xxxxxxxxx>
wrote:

Chris,

Use my second script to get details about session memory in Other category.


--
Best regards,
Sayan Malakshinov

Other related posts: