I had a situation where I had to killed the long-running session in my Oracle database. The session does not terminate immediately. It is marked for the kill and the rollback is done in the background. SQL> ALTER SYSTEM KILL SESSION ’12,2233′; ALTER SYSTEM KILL SESSION ’12,2233′ * ERROR at line 1: ORA-00031: session marked […]
Techgoeasy
Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
