Session

How to Resolve ORA-00030: User session ID does not exist.

by Ed Chen
March 14, 2023March 16, 2023

ORA-00030 Tried to kill a session, but it failed with ORA-00030. SQL> ALTER SYSTEM KILL SESSION '1821, 8545, @2'; ALTER SYSTEM KILL SESSION '1821, 8545,… Read More »

How to Resolve ORA-00026: missing or invalid session ID

by Ed Chen
January 16, 2023December 26, 2022

ORA-00026 Tried to kill a session in a database, but it failed with ORA-00026. Case 1 SQL> ALTER SYSTEM KILL SESSION ('391, 9220'); ALTER SYSTEM… Read More »

How to Kill LOCAL=NO Process at OS-Level

by Ed Chen
July 29, 2020February 14, 2023

Unstoppable Sessions In some situation, you might see AP server spawned thousands of sessions for no reason, we should take some actions on the spot.… Read More »

Alter System Kill Session, Disconnect Session

by Ed Chen
August 1, 2014February 13, 2023

Kill Session vs Disconnect Session Oracle SQL provides end_session_clauses syntax to terminate sessions: ALTER SYSTEM { DISCONNECT SESSION 'integer1, integer2' [ POST_TRANSACTION ] | KILL… Read More »

How Oracle Kill Blocking Sessions

by Ed Chen
March 9, 2013February 13, 2023

After the blocking sessions are identified, DBA should notify the session owners and leave them a chance to exit sessions gracefully by themselves. If things… Read More »