1 Reply Latest reply: Jun 28, 2011 4:01 AM by Udo RSS

    connect to other session


      I was connected using putty to a server were xe is installed, and sqlplus was running a long query for hours.
      Then I got a power failure on my pc (not on server), I lost my putty connection but my oracle session is still active in v$session.

      I would like to connect to it (as sysdba OR as simple user) to be able to commit it.

        • 1. Re: connect to other session
          Hi Alain,

          as far as I know, this is not possible. All you can do is to kill the session and restart your transaction. I recommend use a screen session that survives a broken shell session or to run is with nohup as script - which should include the commit.