high pga usage by mmon
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 06 Jan 2011 08:57:54 -0500
In our 11.1.0.7 databases I am noticing a high amount of memory being
used by mmon as compared to 10.2.0.4. Is this allocation normal in
11G?
SID PROGRAM PGA_USED_MEM PGA_ALLOC_MEM
PGA_MAX_MEM B
---- ------------------------------ -------------- -------------
----------- -
168 ORACLE.EXE (VKTM) 681,756 842,988
842988 1
156 ORACLE.EXE (DIAG) 682,220 842,988
842988 1
135 ORACLE.EXE (SMCO) 684,164 842,988
842988 1
166 ORACLE.EXE (PSP0) 685,500 842,988
842988 1
164 ORACLE.EXE (MMAN) 685,500 842,988
842988 1
169 ORACLE.EXE (PMON) 686,316 842,988
842988 1
147 ORACLE.EXE (QMNC) 693,836 842,988
842988 1
157 ORACLE.EXE (MMNL) 695,636 974,060
974060 1
161 ORACLE.EXE (CKPT) 750,684 3,216,028
5182108 1
123 sqlplus.exe 782,932 1,039,596
1039596
125 ORACLE.EXE (W000) 793,284 1,039,596
1039596 1
167 ORACLE.EXE (DBRM) 827,340 1,236,204
1432812 1
107 emagent.exe 952,540 2,546,924
2546924
165 ORACLE.EXE (DIA0) 1,021,236 1,677,900
1743436 1
159 ORACLE.EXE (RECO) 1,022,796 1,694,956
1694956 1
170 ORACLE.EXE (q001) 1,341,724 1,694,956
1694956 1
160 ORACLE.EXE (SMON) 1,358,884 5,364,972
5430508 1
141 ORACLE.EXE (q000) 1,619,404 2,546,924
2612460 1
140 emagent.exe 2,105,582 3,595,500
8248556
137 emagent.exe 2,335,982 3,988,716
18406636
138 emagent.exe 2,342,990 3,988,716
43620940
132 emagent.exe 2,484,494 4,447,468
45079788
145 ORACLE.EXE (FBDA) 3,238,788 5,937,740
6396492 1
163 ORACLE.EXE (DBW0) 3,418,788 3,710,044
8052476 1
162 ORACLE.EXE (LGWR) 4,916,756 9,886,956
13688044 1
154 ORACLE.EXE (ARC0) 4,916,836 10,280,172
10280172 1
150 ORACLE.EXE (ARC2) 4,916,836 10,280,172
10280172 1
148 ORACLE.EXE (ARC3) 4,916,836 10,280,172
10280172 1
149 ORACLE.EXE (ARC1) 4,959,180 10,280,172
10280172 1
158 ORACLE.EXE (MMON) 42,721,516 43,817,548
43817548 1
--------------
sum 99,240,336
30 rows selected.
Other related posts:
- » high pga usage by mmon - Jeffrey Beckstrom
