Jared.... funny! :)
- Jared.Still_at_radisys.com wrote:
> Subtlety?
>
> Mladen, have you been attending charm school, or
> reading
> Miss Manners perhaps?
>
> Jared
>
>
>
>
>
>
> "Gogala, Mladen" <MGogala_at_oxhp.com>
> Sent by: root_at_fatcity.com
> 06/17/2002 02:04 PM
> 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
>
>
> 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:
>
=== 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: Viktor
INET: stant_98_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 - 23:13:20 CDT
