RE: UNIX question(killing a process)

From: Gillian M <zmkj04_at_yahoo.com>
Date: Mon, 13 Nov 2000 08:54:24 -0800 (PST)
Message-Id: <10679.121908@fatcity.com>

You can run /$ORACLE_HOME/rdbms/admin/utllockt.sql - to determine any deadlocks, well any locks in the database.

Then you can use:
alter system kill session 'SID,SERIAL#';

G!
--- Uma Sankara_Sivadanam
<UmaSankara_Sivadanam_at_satyam.com> wrote: > Yes i got it.Let me put it this way:
> how to find the processes which are in hung state
> and wait for 15
> minutes to see if there is any change in the status
> and then kill that
> process?
>
> cheers,
> /uma
>
> > ----------
> > From: Suzy Vordos[SMTP:lvordos_at_datsit.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Friday, November 10, 2000 11:18 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: UNIX question(killing a process)
> >
> >
> > Just because a process is idle, doesn't mean it
> should be killed. If
> > you're trying to manage idle database connections,
> do this by setting
> > IDLE_TIME in the user's PROFILE. Rarely, if ever,
> do I kill an Oracle
> > process at the OS level.
> >
> > Suzy
> >
> > > Uma Sankara_Sivadanam wrote:
> > >
> > > Hi,
> > >
> > > Environment:SUNOS 5.6
> > >
> > > I am working on a script which should check
> for processes using
> > > ps and kill all the processs which are
> IDLE for more than 15
> > > minutes.
> > >
> > > I need the exact syntax of the PS command(i
> mean the command
> > > options).
> > >
> > > cheers
> > > /uma
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Suzy Vordos
> > INET: lvordos_at_datsit.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).
> >
>

---

Do You Yahoo!? Received on Mon Nov 13 2000 - 10:54:24 CST