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.
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.