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