RE: URGENT: Why are there so many Oracle (LOCAL=NO) processes?

Are you running OEM, by chance? I've had some sporadic problems with pre-2.2 versions looping failed jobs, causing several spurious connections to either the target or repository DB.

If you can kill off those puppies in one window, try executing this SQL-Plus script (e.g. "sqlplus -s / @sessions.sql") in another until it gets a connection (converted from an original script by Brian P. Mac Lean):

	set verify off pagesize 66 linesize 150 feedback off
	set showmode off echo off heading off

	col bb format a15
	col cc format a15
	col ee format a7
	col gg format a50
	col kk format a14

	select vs.osuser bb,
	       vs.username cc,
	       vp.spid ee,
	       vs.program gg,
	       trunc(LAST_CALL_ET/86400) || '::' ||
	       trunc(mod(LAST_CALL_ET,86400)/3600) || ':' ||
	       trunc(mod(mod(LAST_CALL_ET,86400),3600)/60) || ':' ||
	       mod(mod(mod(LAST_CALL_ET,86400),3600),60)  kk
	  from v$process vp, v$session vs
	  where vs.paddr = vp.addr
	       and vs.type <> 'BACKGROUND'
	       and not exists ( select 'x'
	                        from v$bgprocess vbg
	                        where vbg.paddr != '00'
	                        and vbg.paddr  = vp.addr)
	  order by 1, 2;

	exit

Good luck! :)

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             Quad/Tech International, Sussex, WI USA

Disclaimer: Use the above code at your own risk! Neither QTI nor myself will be responsible for any icky stuff that might happen if you run it.

> -----Original Message-----
> From: Larry Taylor [mailto:ltaylor_at_iq.com]
> Sent: Thursday, January 04, 2001 13:27
> To: Multiple recipients of list ORACLE-L
> Subject: URGENT: Why are there so many Oracle (LOCAL=NO) processes?
>
>
> Does anyone know why so many of these Oracle processes named
> (LOCAL=NO)
> have suddenly shown up? So many in fact, I can't bring up SVRMGR
> until I kill them, but they keep coming back!
>
>
> oracle 9739 1 0 10:09:24 ? 0:00 oracleshark (LOCAL=NO)
> oracle 9687 1 0 09:59:15 ? 0:08 oracleshark (LOCAL=NO)
> oracle 9691 1 0 09:59:16 ? 1:09 oracleshark (LOCAL=NO)
> oracle 9695 1 0 09:59:19 ? 0:00 oracleshark (LOCAL=NO)
...
> Thanks in Advance
> larry

This message has been scanned for viruses with Trend Micro's Interscan VirusWall. Received on Thu Jan 04 2001 - 15:33:47 CST