Recovery after Process Errors 

A process error occurs when a user process is canceled.

The Oracle instance is not normally affected by the termination.  The Oracle process monitor (PMON) responds by canceling the database changes made by current transactions rollback and releasing the resources that were used by the process.  Work with the database system can then continue normally.

The database administrator does not have to intervene to perform a recovery after a process error.