Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Locks in Oracle 9i

Re: Locks in Oracle 9i

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 1 Oct 2003 05:27:55 -0700
Message-ID: <1efdad5b.0310010427.2b6ef8db@posting.google.com>


"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:<rSneb.7412$Ze7.1401_at_news01.roc.ny>...
> "Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0309300803.60f91f89_at_posting.google.com...
> --snip--
> > your session is still active. just becuase you disconnect, dose not
> > mean the session closes. you have to kill your session. i doubt you
> > will have priviledges to do this on your school computer. Anyway here
> > is how you do it.
> >
> > use v$session view(you probably wont have access to this). find the
> > sid and serial# for your session.
> >
> > alter system kill session 'sid,serial#';
> >
> > easiest way to get around this is to go to otn.oracle.com, download a
> > copy of oracle and install at home. then you can do whatever you want.
>
> Define disconnect. If you type exit in sqlplus, you have disconnected cleanly and the session *will* close.
>
> Show me an example where you disconnect properly and the session does not close.
> I'm not talking about hitting that x button on your sqlplus window!
>
> Anurag

if you read the original posters message he never said he typed 'exit'. He said he closed his session because it was taking too long. the transaction is still ongoing. so the session stays open. Received on Wed Oct 01 2003 - 07:27:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US