Saturday, March 30, 2013

what happens to transactions when sqlplus program is closed or db crashes?


sql>quit (gracefull close of session)
the transaction automatically get implicit commit;

sql> close the window (ungracefully close the session)
the transaction gets rollback
what happens to transactions when during transaction oracle database crashes?
it automatically rollback those transactions during the recovery

No comments: