| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: shared pool memory issue on OPS (non-MTS)
Here is the results of looking at the v$resource table for the node with the
issue.
select * from v$resource;
ADDR TY ID1 ID2
D4F7C2F8 TS 3 692077582
D4F7C340 TS 38 268439158
D4F7C388 RT 2 0
D4F7C3D0 PI 1 0
D4F7C418 RT 2 1
D4F7C460 DM 1 0
D4F7C4A8 MR 1 0
D4F7C4F0 MR 2 0
D4F7C538 MR 3 0
D4F7C580 MR 4 0
D4F7C5C8 MR 5 0
D4F7C610 MR 6 0
D4F7C658 MR 7 0
D4F7C6A0 MR 8 0
D4F7C6E8 MR 9 0
D4F7C730 MR 10 0
D4F7C778 MR 11 0
D4F7C7C0 MR 12 0
D4F7C808 MR 13 0
D4F7C850 MR 14 0
D4F7C898 MR 15 0
D4F7C8E0 MR 16 0
D4F7C928 MR 17 0
D4F7C970 MR 18 0
D4F7C9B8 MR 19 0
D4F7CA00 MR 20 0
D4F7CA48 MR 21 0
D4F7CA90 MR 22 0
D4F7CAD8 MR 23 0 D4F7CB20 MR 24 0
D4F7CB68 MR 25 0
D4F7CBB0 MR 26 0 D4F7CBF8 MR 27 0 D4F7CC40 MR 28 0
D4F7CC88 MR 29 0
D4F7CCD0 MR 30 0 D4F7CD18 MR 31 0
D4F7CD60 MR 32 0
D4F7CDA8 MR 33 0 D4F7CDF0 MR 34 0 D4F7CE38 MR 35 0
D4F7CE80 MR 36 0
D4F7CEC8 MR 37 0 D4F7CF10 MR 38 0
D4F7CF58 MR 39 0
D4F7CFA0 MR 40 0 D4F7CFE8 MR 41 0 ADDR TY ID1 ID2
D4F7D030 MR 42 0
D4F7D078 MR 43 0
D4F7D0C0 MR 44 0
D4F7D108 MR 45 0
D4F7D150 MR 46 0
D4F7D198 MR 47 0
D4F7D1E0 MR 48 0
D4F7D228 MR 49 0
D4F7D270 MR 50 0
D4F7D2B8 MR 51 0
D4F7D300 MR 52 0
D4F7D348 MR 53 0
D4F7D390 MR 54 0
D4F7D3D8 MR 55 0
D4F7D420 MR 56 0
D4F7D468 MR 57 0
D4F7D4B0 MR 58 0
D4F7D4F8 MR 59 0
D4F7D540 MR 60 0
D4F7D588 MR 61 0
D4F7D5D0 MR 62 0
D4F7D618 MR 63 0
D4F7D660 MR 64 0
D4F7D6A8 MR 65 0
D4F7D6F0 MR 66 0
D4F7D738 MR 67 0
D4F7D780 MR 68 0
D4F7D7C8 MR 69 0
D4F7D810 MR 70 0
D4F7D858 MR 71 0
D4F7D8A0 MR 72 0
D4F7D8E8 MR 79 0
D4F7D930 MR 80 0
D4F7D978 MR 81 0
D4F7D9C0 MR 82 0
D4F7DA08 MR 83 0
D4F7DA50 MR 84 0
D4F7DA98 MR 85 0
D4F7DAE0 MR 86 0 D4F7DB28 MR 87 0
D4F7DB70 MR 88 0
D4F7DBB8 MR 89 0 D4F7DC00 MR 90 0
D4F7DC48 MR 91 0
D4F7DC90 MR 92 0
D4F7DCD8 MR 93 0 D4F7DD20 MR 94 0
ADDR TY ID1 ID2
D4F7DD68 MR 95 0
D4F7DDB0 MR 96 0 D4F7DDF8 MR 97 0 D4F7DE40 MR 98 0
D4F7DE88 MR 101 0
D4F7DED0 MR 102 0 D4F7DF18 MR 105 0
D4F7DF60 MR 106 0
D4F7DFA8 MR 107 0 D4F7DFF0 MR 108 0 D4F7E038 MR 109 0
D4F7E080 MR 110 0
D4F7E0C8 MR 111 0
D4F7E110 MR 112 0
D4F7E158 MR 113 0
D4F7E1A0 MR 114 0
D4F7E1E8 MR 115 0
D4F7E230 MR 116 0
D4F7E278 MR 117 0
D4F7E2C0 MR 118 0
D4F7E308 MR 119 0
D4F7E350 MR 120 0
D4F7E398 MR 121 0
D4F7E3E0 MR 122 0
D4F7E428 MR 123 0
D4F7E470 MR 124 0
D4F7E4B8 MR 125 0
D4F7E500 MR 126 0
D4F7E548 MR 127 0
D4F7E590 MR 128 0
D4F7E5D8 MR 129 0
D4F7E620 MR 130 0
D4F7E668 MR 131 0
D4F7E6B0 MR 132 0
D4F7E6F8 MR 133 0
D4F7E740 MR 134 0
D4F7E788 MR 135 0
D4F7E7D0 MR 136 0
D4F7E818 MR 137 0
D4F7E860 MR 138 0
D4F7E8A8 MR 139 0
D4F7E8F0 MR 140 0
D4F7E938 MR 141 0
D4F7E980 MR 142 0
D4F7E9C8 MR 143 0
D4F7EA10 MR 144 0
D4F7EA58 MR 145 0
ADDR TY ID1 ID2
D4F7EAA0 MR 146 0 D4F7EAE8 MR 147 0 D4F7EB30 MR 155 0
D4F7EB78 MR 156 0
D4F7EBC0 MR 157 0 D4F7EC08 MR 158 0
D4F7EC50 MR 159 0
D4F7EC98 MR 160 0
D4F7ECE0 MR 161 0 D4F7ED28 MR 162 0
D4F7ED70 MR 163 0
D4F7EDB8 MR 164 0 D4F7EE00 MR 165 0
D4F7EE48 MR 166 0
D4F7EE90 MR 167 0
D4F7EED8 MR 168 0 D4F7EF20 MR 169 0
D4F7EF68 MR 170 0
D4F7EFB0 MR 171 0 D4F7EFF8 MR 172 0 D4F7F040 MR 173 0
D4F7F088 MR 174 0
D4F7F0D0 MR 175 0
D4F7F118 MR 176 0
D4F7F160 MR 177 0
D4F7F1A8 MR 178 0
D4F7F1F0 MR 179 0
D4F7F238 MR 180 0
D4F7F280 MR 181 0
D4F7F2C8 MR 182 0
D4F7F310 MR 183 0
D4F7F358 MR 184 0
D4F7F3A0 MR 185 0
D4F7F3E8 MR 186 0
D4F7F430 MR 187 0
D4F7F478 MR 188 0
D4F7F4C0 MR 189 0
D4F7F508 MR 190 0
D4F7F550 MR 191 0
D4F7F598 MR 192 0
D4F7F5E0 MR 193 0
D4F7F628 MR 194 0
D4F7F670 MR 195 0
D4F7F6B8 MR 196 0
D4F7F700 MR 197 0
D4F7F748 MR 198 0
D4F7F790 MR 199 0
ADDR TY ID1 ID2
D4F7F7D8 MR 200 0
D4F7F820 MR 201 0
D4F7F868 MR 202 0
D4F7F8B0 MR 203 0
D4F7F8F8 MR 204 0
D4F7F940 MR 205 0
D4F7F988 MR 206 0
D4F7F9D0 MR 207 0
D4F7FA18 MR 208 0
D4F7FA60 MR 209 0
D4F7FAA8 MR 210 0 D4F7FAF0 MR 211 0 D4F7FB38 MR 212 0
D4F7FB80 MR 213 0
D4F7FBC8 MR 214 0 D4F7FC10 MR 215 0
D4F7FC58 MR 216 0
D4F7FCA0 MR 217 0 D4F7FCE8 MR 218 0 D4F7FD30 MR 219 0
D4F7FD78 MR 220 0
D4F7FDC0 MR 221 0 D4F7FE08 MR 222 0
D4F7FE50 MR 223 0
D4F7FE98 MR 224 0
D4F7FEE0 MR 225 0 D4F7FF28 MR 226 0
D4F7FF70 MR 227 0
D4F7FFB8 MR 228 0 D4F80000 MR 229 0
D4F80048 MR 230 0
D4F80090 MR 231 0
D4F800D8 MR 232 0
D4F80120 MR 233 0
D4F80168 MR 234 0
D4F801B0 MR 235 0
D4F801F8 MR 236 0
D4F80240 MR 237 0
D4F80288 MR 238 0
D4F802D0 MR 239 0
D4F80318 RT 2 2
D4F80360 RT 2 3
D4F803A8 TS 36 109075491
D4F80828 TS 130 71305640
D4F80870 TS 45 465568526
233 rows selected.
Please let me know what you see
-----Original Message-----
Sent: Thursday, May 02, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L
What does V$RESOURCE_LIMIT say? You can probably post that as a reply...
> No messages in the alert log about dynamic lock allocation, the node that
is
> having the issue has a small load on it right now and the memory is still
> being used up.
>
> Thanks
>
> -----Original Message-----
> Sent: Thursday, May 02, 2002 3:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Any messages in the alert file, like dynamic lock allocation or resource
> allocation ?
> In Oracle8 locks and resources for OPS are dynamically allocated from the
> shared pool after the initial values of _LM* are used.
> You can monitor that in v$resource_limit.
>
> Anjo.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, May 02, 2002 9:03 PM
>
>
> > Hello,
> > We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non
> mts)
> > on version 8.1.7.2.1 32 bit, we were encountering ora-4031 errors on
one
> of
> > the instances, so we increased the amount of shared pool memory from
100mb
> > to 200mb on both nodes in the cluster. Since the shared pool memory was
> > increased the instance on the node that had the error is no longer
> > encountering it. But now the instance on the other node that was not
> having
> > any issue, is able to keep only 1% of the shared pool memory free and
has
> > hung 2 times. We are working with Oracle, but would appreciate any
ideas.
> We
> > know that we have 'bind variable' issues, but not enough to get us into
> the
> > situation that we now face.
> >
> >
> > Thank you,
> >
> > Paul Sherman
> > DBA Elcom, Inc.
> > voice - 781-501-4143 (direct #)
> > fax - 781-278-8341 (secure)
> > email - psherman_at_elcom.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Sherman, Paul R.
> > INET: PSherman_at_elcom.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anjo Kolk
> INET: anjo_at_oraperf.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rodrigues, Bryan
> INET: BRodrigues_at_elcom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: Tim_at_SageLogix.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: BRodrigues_at_elcom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu May 02 2002 - 16:37:15 CDT
 |
 |