Re: awr process memory summary section

From: Taral Desai <taral.desai_at_gmail.com>
Date: Mon, 29 Mar 2010 17:04:48 -0500
Message-ID: <2b0cd5cd1003291504i137e97bak634619fb2807bb58_at_mail.gmail.com>

You can use v$process_memory_detail to get this information

On Sun, Mar 28, 2010 at 1:47 PM, Neil Kodner <nkodner_at_gmail.com> wrote:

> Here's an example:
>
> ^LProcess Memory Summary DB/Inst: Snaps: 47895-47896
> -> B: Begin snap E: End snap
> -> All rows below contain absolute values (i.e. not diffed over the
> interval)
> -> Max Alloc is Maximum PGA Allocation size at snapshot time
> -> Hist Max Alloc is the Historical Max Allocation for still-connected
> processes
> -> ordered by Begin/End snapshot, Alloc (MB) desc
>
> Hist
> Avg Std Dev Max Max
> Alloc Used Alloc Alloc Alloc Alloc Num
> Num
> Category (MB) (MB) (MB) (MB) (MB) (MB) Proc
> Alloc
> - -------- --------- --------- -------- -------- ------- ------- ------
> ------
> B Other 9,498.2 N/A 4.7 4.0 76 77 2,010
> 2,010
> Freeable 1,570.2 .0 .9 .3 6 N/A 1,731
> 1,731
> SQL 1,105.8 823.2 .6 1.8 66 271 1,998
> 1,981
> JAVA 1,024.4 1,021.4 1.6 .5 4 9 640
> 638
> PL/SQL 113.4 71.9 .1 .0 0 0 2,008
> 2,008
> E Other 9,785.4 N/A 4.8 4.0 76 77 2,037
> 2,037
> Freeable 1,598.3 .0 .9 .3 6 N/A 1,757
> 1,757
> SQL 1,203.6 913.6 .6 2.4 68 271 2,024
> 2,013
> JAVA 1,018.6 1,015.5 1.6 .5 4 9 636
> 634
> PL/SQL 116.7 73.6 .1 .0 0 0 2,035
> 2,035
> -------------------------------------------------------------
>
>
> On Sun, Mar 28, 2010 at 2:07 PM, Neil Kodner <nkodner_at_gmail.com> wrote:
>
>> Looking at the section titled "Process Memory Summary", we see categories:
>>
>> - Other
>> - Freeable
>> - SQL
>> - JAVA
>> - PL/SQL
>>
>>
>> What constitutes other and how can I examine its contents? Anyone know
>> where to find this?
>>
>>
>>
>

-- 
Thanks & Regards,
Taral Desai

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 29 2010 - 17:04:48 CDT