I used to work at a shop where Java developers killed
their sessions with ctl+c. This would stack so many
sessions up that it would finally use enough resources
so that no one could log in. We did just what you are
suggesting, playing smack-a-spid.
The conclusion we came to was that the oracle session
was waiting patiently to tell the java session that it
was being killed (when we killed the session on the
DB.) I wonder if disconnect immediate was setup to
handle this type of situation?
jack
- "Gogala, Mladen" <MGogala_at_oxhp.com> wrote:
> One can be subtle about it an tell that to the
> session
> by using very subtle and unnoticable "kill -9"
> command.
> JDBC normally connects as a dedicated server
> session.
> There are v$session and v$process, find SPID and
> execute
> it with extreme prejudice (kill -9). Make sure
> you're not
> killing SMON, PMON or LGWR.
>
> > -----Original Message-----
> > From: Jack Silvey [mailto:jack_silvey_at_yahoo.com]
> > Sent: Monday, June 17, 2002 3:09 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: How to remove Lock on a Table
> >
> >
> > interesting point - anyone know how the 8i "alter
> > system disconnect session immediate" differentates
> > from the "alter system kill session"? read
> something
> > somewhere about it destroying the virtual circuit.
> I
> > always suspected that it ignored the wait period
> that
> > the "kill" command goes through to tell the client
> it
> > is dead (which of course it can't with connection
> > forms like JDBC, so the session never dies).
> >
> > Jack
> >
> >
> > --- Jared.Still_at_radisys.com wrote:
> > > Even better. Kill the OS process first, then
> kill
> > > the Session if still
> > > necessary.
> > >
> > > Using 'Alter system kill session' to remove a
> > > session holding a lock has
> > > always been problematic in Oracle.
> > >
> > > On occasion, PMON will *not* clean up the
> session,
> > > and a bounce of the
> > > database is required to remove the lock.
> > >
> > > I've seen it happen on 3 OS's, and versions
> 7.0.16,
> > > 7.2, 7.3, 8.04. Not
> > > sure
> > > about 8i.
> > >
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > >
> > > "David Marshall" <damarsha_at_cisco.com>
> > > Sent by: root_at_fatcity.com
> > > 06/17/2002 09:23 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list
> ORACLE-L
> > > <ORACLE-L_at_fatcity.com>
> > > cc:
> > > Subject: RE: How to remove Lock
> on a
> > > Table
> > >
> > >
> > > You might also want to get the os pid from
> v$process
> > > before issuing the
> > > alter system kill session statement.
> > > Then you can easily track the os process if
> needed.
> > >
> > > Select p.spid
> > > From v$session s, v$process p
> > > Where s.paddr = p.addr
> > > And s.sid = &sid;
> > >
> > > -----Original Message-----
> > > Sent: 17 June 2002 13:18
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Yeah that will do. But you need to wait as
> Oracle
> > > will Rollback the
> > > changed
> > > data and then rel the lock.
> > >
> > > HTH
> > >
> > > Best Regards,
> > > Ganesh R
> > > Tel : +971 (4) 397 3337 Ext 420
> > > Fax : +971 (4) 397 6262
> > > HP : +971 (50) 745 6019
> > > ============================================
> > > Live to learn... forget... and learn again.
> > > ============================================
> > >
> > >
> > >
> > > -----Original Message-----
> > > Sent: Monday, June 17, 2002 2:13 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hello all,
> > >
> > > I want to remove lock on a Table by using this
> > > command:
> > >
> > > Alter system kill session '&sid,&serial'
> > >
> > > Is this enough or I have to do something else!
> > >
> > > Regards
> > >
> > > Ashraf Salaymeh
> > > System Analyst
> > >
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > LAUNCH - Your Yahoo! Music Experience
> > > http://launch.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: ASHRAF SALAYMEH
> > > INET: ashraf_salaymeh_at_yahoo.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: Ganesh Raja
> > > INET: ganesh_at_gtfs-gulf.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: David Marshall
> > > INET: damarsha_at_cisco.com
> > >
>
=== message truncated ===
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
INET: jack_silvey_at_yahoo.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 Mon Jun 17 2002 - 16:24:53 CDT