• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle database
  • Oracle Ebusiness Suite
  • Oracle weblogic
  • Oracle Performance Tuning
  • Oracle Hyperion
  • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads

undo kill

How to monitor transaction Rollback Progress

August 21, 2021 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database Tagged With: undo kill

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to clone Oracle Home in 10g/11g/12c/19c/23c
  • How to find the FND_FILE output of the running concurrent request
  • srvctl commands in Oracle
  • Top SQL Patch Queries in Oracle Database
  • how to find if the sql is using the SQL Patch

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us