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