Geek Answers Handbook

Oracle user disconnected without committing / rolling back, can no longer modify database

The user registered in the Oracle database, I work with the disconnected one without committing or rolling back, and now my database cannot be changed, it seems to be locked.

I tried

 rollback

but it didn’t work.

Any thoughts? Thank.

+5
source share
2 answers

You cannot exit an Oracle database without committing or rolling back. It is possible that the client application crashed or was forced to terminate, and it was not possible to exit the session on the server where the locks are stored. If so, the DBA will have to kill this session.

, , , , , .

SELECT ses.sid, ses.serial#, ses.username, ses.program, ses.osuser, ses.machine
  FROM v$session ses,
       dba_blockers blk
 WHERE blk.holding_session = ses.sid

,

ALTER SYSTEM KILL SESSION '<<sid>>, <<serial#>>'
+9

, , , .

, . , SQLNET.EXPIRE_TIME - . , , , . , , , .

, . , . , ,

+3

More articles:


All Articles