Oracle-L: RE: SMON Using Lots of Memory in 9i

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 20 Jun 2002 11:13:28 -0800
Message-ID: <F001.004832FA.20020620111328@fatcity.com>

I have seen smon going upto 127M at which point it starts dumping trace files (one trace file and a core directory for each connected session) as if it's raining. Then instance crashes. All DBAs and Unix Admins panic and bring up the system, unfortunately most important trace file (the smon trace) itself can't be found, because before Oracle finished writing the file the instance crashed, so OWS didn't believe in first place. So we used OEM to capture smon memory leak and sent out the graphs, then they agreed and fixed it as a bug.

We could see this value from OWM, SQL scripts, Spotlight, TOAD, pretty much any tool.

BTW this is all on AIX and 9011/9012 (without the patch to fix this problem).
Raj

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Thursday, June 20, 2002 2:51 PM
To: Multiple recipients of list ORACLE-L

Hello,

how utility/tool said that SMON was using 50M+ ?

regards...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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).



text/plain attachment: InterScan_Disclaimer.txt

Received on Thu Jun 20 2002 - 14:13:28 CDT