At least in 8.0.x the oracle intelligent agent process are dbsnmp processes. Are you sure that these are oracle processes and not OS related.
Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 4:20 PM > 8.1.7.2.5 under Win2k Server > > I just discovered that my four SNP processes were sitting around, doing no > work, taking up about 500MB of RAM. Is this normal? > > In Task Manager, the Oracle process was showing to be using about 1.4GB. > After I issued "Alter System Set Job_Queue_Processes=0" it shrank to about > 900MB. I then issued "Alter System Set Job_Queue_Processes=4", but the Mem > Usage stayed the same. > > None of those SNP processes had done any work (i.e., run any jobs) for about > 10 hours. I would have expected the SNP processes to release memory when > their jobs finish. > > I've been trying to figure out what processes were chewing up RAM, ramping > up over the course of 3 or 4 days. Some Java processes that we run were > found to be hogs, but after I got the developers to disconnect/reconnect > occasionally, those sessions were OK. > > I finally found the culprits when I was checking sessions' "session pga > memory". A couple of sessions were using about 200MB each. I checked to > see what SQL they'd been running and found it to be dbms_ijob calls, which > lead me to suspect the SNP processes - alas, Win2k doesn't let you look at > individual Oracle processes like UNIX does. > > Anyway, I can't find any mention anywhere that dormant SNP processes can be > memory hogs. Am I missing something? For now I'll set Job_Queue_Processes > to 0 and back to 4 right after the heavy work each night. > > Any init parameters I'm missing? ...other suggestions? > > Thanks. > > Jack > > -------------------------------- > Jack C. Applewhite > Database Administrator/Developer > OCP Oracle8 DBA > iNetProfit, Inc. > Austin, Texas > www.iNetProfit.com > [EMAIL PROTECTED] > (512)327-9068 > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack C. Applewhite > 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: Ruth Gramolini 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).
