Re: SGA, miscellaneous keeps growing...
Hi! Vadim Gorbounov writes: > Thank you, Kimberly, > I've doublechecked the bug (did you mean this one "8171 [BUG:1240484] > Shared server memory leak on repeated connect/disconnect" ?), it doesn't > seem applicable to my case - I dont use MTS, dedicated only. > Thank you anyway, I feel more confidence to iTAR now, this is very likely > some bug. Have a look at bugs #1727717 and #1649372. -- Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Moeding 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).
RE: SGA, miscellaneous keeps growing...
Alex, Full link is http://metalink.oracle.com/metalink/plsql/ml2_documents.showFOR?p_id=115437. 996&p_showHeader=1&p_showHelp=1 It was wrapped over in the original posting. Also, I found many references to this bug searching ML for "1397604". Gonna set _db_handles_cached = 0 for now. And patch ASAP Thanks Kimberly and Waleed. -Original Message- Sent: Tuesday, July 03, 2001 4:26 PM To: Multiple recipients of list ORACLE-L I was told by Metalink that I do not have access to this section on Metalink. How did you searched for it? Alex Hillman -Original Message- Sent: Tuesday, July 03, 2001 3:35 PM To: Multiple recipients of list ORACLE-L I found this in the metalink today since we plan to upgrade to 8.1.7.1: Try this thread: http://metalink.oracle.com/metalink/plsql/ml2_documents.showFOR?p_id=115437. 996&p_showHeader=1&p_showHelp=1 -Original Message- Sent: Tuesday, July 03, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Thank you, Kimberly, I've doublechecked the bug (did you mean this one "8171 [BUG:1240484] Shared server memory leak on repeated connect/disconnect" ?), it doesn't seem applicable to my case - I dont use MTS, dedicated only. Thank you anyway, I feel more confidence to iTAR now, this is very likely some bug. Have a good day, Vadim -Original Message- Sent: Tuesday, July 03, 2001 2:23 PM To: Multiple recipients of list ORACLE-L It's a bug. The bug fix is out there. It seems to come from connect/disconnect. -Original Message- Sent: Tuesday, July 03, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Hello, dear listers, I've got 8.1.7.1 installation on RH6.2 here. Runs smoothly, but I noted strange trend - SGA shared pool miscellaneous permanently keeps growing, approx rate 1MB per day. No suspicious messages in alert.log, no udumps. I've to bounce database to free this memory. Fortunately, now I can schedule this every weekend, but the fact itself troubles me. Nothing on Metalink. What looks specific about this database, I've got job using UTL_HTTP many times per day ... Did anybody experience this problem? Any idea where to look at? Thank you Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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: Kimberly Smith 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: Vadim Gorbounov 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: Khedr, Waleed 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX
RE: SGA, miscellaneous keeps growing...
I was told by Metalink that I do not have access to this section on Metalink. How did you searched for it? Alex Hillman -Original Message- Sent: Tuesday, July 03, 2001 3:35 PM To: Multiple recipients of list ORACLE-L I found this in the metalink today since we plan to upgrade to 8.1.7.1: Try this thread: http://metalink.oracle.com/metalink/plsql/ml2_documents.showFOR?p_id=115437. 996&p_showHeader=1&p_showHelp=1 -Original Message- Sent: Tuesday, July 03, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Thank you, Kimberly, I've doublechecked the bug (did you mean this one "8171 [BUG:1240484] Shared server memory leak on repeated connect/disconnect" ?), it doesn't seem applicable to my case - I dont use MTS, dedicated only. Thank you anyway, I feel more confidence to iTAR now, this is very likely some bug. Have a good day, Vadim -Original Message- Sent: Tuesday, July 03, 2001 2:23 PM To: Multiple recipients of list ORACLE-L It's a bug. The bug fix is out there. It seems to come from connect/disconnect. -Original Message- Sent: Tuesday, July 03, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Hello, dear listers, I've got 8.1.7.1 installation on RH6.2 here. Runs smoothly, but I noted strange trend - SGA shared pool miscellaneous permanently keeps growing, approx rate 1MB per day. No suspicious messages in alert.log, no udumps. I've to bounce database to free this memory. Fortunately, now I can schedule this every weekend, but the fact itself troubles me. Nothing on Metalink. What looks specific about this database, I've got job using UTL_HTTP many times per day ... Did anybody experience this problem? Any idea where to look at? Thank you Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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: Kimberly Smith 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: Vadim Gorbounov 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: Khedr, Waleed 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: Hillman, Alex 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
RE: SGA, miscellaneous keeps growing...
Actually its bug 1397604 -Original Message- Sent: Tuesday, July 03, 2001 12:11 PM To: Multiple recipients of list ORACLE-L Thank you, Kimberly, I've doublechecked the bug (did you mean this one "8171 [BUG:1240484] Shared server memory leak on repeated connect/disconnect" ?), it doesn't seem applicable to my case - I dont use MTS, dedicated only. Thank you anyway, I feel more confidence to iTAR now, this is very likely some bug. Have a good day, Vadim -Original Message- Sent: Tuesday, July 03, 2001 2:23 PM To: Multiple recipients of list ORACLE-L It's a bug. The bug fix is out there. It seems to come from connect/disconnect. -Original Message- Sent: Tuesday, July 03, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Hello, dear listers, I've got 8.1.7.1 installation on RH6.2 here. Runs smoothly, but I noted strange trend - SGA shared pool miscellaneous permanently keeps growing, approx rate 1MB per day. No suspicious messages in alert.log, no udumps. I've to bounce database to free this memory. Fortunately, now I can schedule this every weekend, but the fact itself troubles me. Nothing on Metalink. What looks specific about this database, I've got job using UTL_HTTP many times per day ... Did anybody experience this problem? Any idea where to look at? Thank you Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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: Kimberly Smith 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: Vadim Gorbounov 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: Kimberly Smith 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).
RE: SGA, miscellaneous keeps growing...
I found this in the metalink today since we plan to upgrade to 8.1.7.1: Try this thread: http://metalink.oracle.com/metalink/plsql/ml2_documents.showFOR?p_id=115437. 996&p_showHeader=1&p_showHelp=1 -Original Message- Sent: Tuesday, July 03, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Thank you, Kimberly, I've doublechecked the bug (did you mean this one "8171 [BUG:1240484] Shared server memory leak on repeated connect/disconnect" ?), it doesn't seem applicable to my case - I dont use MTS, dedicated only. Thank you anyway, I feel more confidence to iTAR now, this is very likely some bug. Have a good day, Vadim -Original Message- Sent: Tuesday, July 03, 2001 2:23 PM To: Multiple recipients of list ORACLE-L It's a bug. The bug fix is out there. It seems to come from connect/disconnect. -Original Message- Sent: Tuesday, July 03, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Hello, dear listers, I've got 8.1.7.1 installation on RH6.2 here. Runs smoothly, but I noted strange trend - SGA shared pool miscellaneous permanently keeps growing, approx rate 1MB per day. No suspicious messages in alert.log, no udumps. I've to bounce database to free this memory. Fortunately, now I can schedule this every weekend, but the fact itself troubles me. Nothing on Metalink. What looks specific about this database, I've got job using UTL_HTTP many times per day ... Did anybody experience this problem? Any idea where to look at? Thank you Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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: Kimberly Smith 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: Vadim Gorbounov 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: Khedr, Waleed 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).
RE: SGA, miscellaneous keeps growing...
Thank you, Kimberly, I've doublechecked the bug (did you mean this one "8171 [BUG:1240484] Shared server memory leak on repeated connect/disconnect" ?), it doesn't seem applicable to my case - I dont use MTS, dedicated only. Thank you anyway, I feel more confidence to iTAR now, this is very likely some bug. Have a good day, Vadim -Original Message- Sent: Tuesday, July 03, 2001 2:23 PM To: Multiple recipients of list ORACLE-L It's a bug. The bug fix is out there. It seems to come from connect/disconnect. -Original Message- Sent: Tuesday, July 03, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Hello, dear listers, I've got 8.1.7.1 installation on RH6.2 here. Runs smoothly, but I noted strange trend - SGA shared pool miscellaneous permanently keeps growing, approx rate 1MB per day. No suspicious messages in alert.log, no udumps. I've to bounce database to free this memory. Fortunately, now I can schedule this every weekend, but the fact itself troubles me. Nothing on Metalink. What looks specific about this database, I've got job using UTL_HTTP many times per day ... Did anybody experience this problem? Any idea where to look at? Thank you Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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: Kimberly Smith 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: Vadim Gorbounov 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).
RE: SGA, miscellaneous keeps growing...
It's a bug. The bug fix is out there. It seems to come from connect/disconnect. -Original Message- Sent: Tuesday, July 03, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Hello, dear listers, I've got 8.1.7.1 installation on RH6.2 here. Runs smoothly, but I noted strange trend - SGA shared pool miscellaneous permanently keeps growing, approx rate 1MB per day. No suspicious messages in alert.log, no udumps. I've to bounce database to free this memory. Fortunately, now I can schedule this every weekend, but the fact itself troubles me. Nothing on Metalink. What looks specific about this database, I've got job using UTL_HTTP many times per day ... Did anybody experience this problem? Any idea where to look at? Thank you Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov 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: Kimberly Smith 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).