V$RESOURCE_LIMIT not V$RESOURCE... ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 3:37 PM
> 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... > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 2:27 PM > > > > 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" <[EMAIL PROTECTED]> > > 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 - [EMAIL PROTECTED] > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Sherman, Paul R. > > > INET: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
