Re: awr process memory summary section
- From: Neil Kodner <nkodner@xxxxxxxxx>
- To: Taral Desai <taral.desai@xxxxxxxxx>
- Date: Mon, 29 Mar 2010 22:00:16 -0400
Weird, I have no rows in v$process_memory_detail. Is there something I need
to do in order to enable it? Then again, it's after hours and the main
memory-hogging application in my DB isn't running at the moment.
On Mon, Mar 29, 2010 at 6:04 PM, Taral Desai <taral.desai@xxxxxxxxx> wrote:
> You can use v$process_memory_detail to get this information
>
>
> On Sun, Mar 28, 2010 at 1:47 PM, Neil Kodner <nkodner@xxxxxxxxx> 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@xxxxxxxxx> 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
>
Other related posts:
