Re: awr process memory summary section

From: Neil Kodner <nkodner_at_gmail.com>
Date: Wed, 31 Mar 2010 11:38:09 -0400
Message-ID: <j2hae2c46ba1003310838p7ad40f8cz52adcec7bdb94af2_at_mail.gmail.com>

So what's the trick to getting v$process_memory_detail to populate? I haven't found much in the way of documentation.

On Mon, Mar 29, 2010 at 10:00 PM, Neil Kodner <nkodner_at_gmail.com> wrote:

> 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_at_gmail.com>wrote:
>
>> 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 Wed Mar 31 2010 - 10:38:09 CDT