Re: awr process memory summary section
- From: Neil Kodner <nkodner@xxxxxxxxx>
- To: Neil Kodner <nkodner@xxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 28 Mar 2010 14:47:02 -0400
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?
>
>
>
Other related posts:
