Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SGA, miscellaneous keeps growing...

RE: SGA, miscellaneous keeps growing...

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Tue, 03 Jul 2001 12:43:37 -0700
Message-ID: <F001.00340997.20010703124551@fatcity.com>

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: vgorbounov_at_simplyengineering.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: Kimberly Smith
  INET: kimberly.smith_at_gmd.fujitsu.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: Vadim Gorbounov
  INET: vgorbounov_at_simplyengineering.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: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.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: Hillman, Alex
  INET: Alex.Hillman_at_usmint.treas.gov
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: Vadim Gorbounov
  INET: vgorbounov_at_simplyengineering.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 Tue Jul 03 2001 - 14:43:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US