Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Locks in Oracle 9i
"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