How to Change Session Time Zone
TIME_ZONE In the previous post, we have checked the time zone in the current session. Now the question is, how to change it? if it… Read More »How to Change Session Time Zone
Session
How to Resolve ORA-00030: User session ID does not exist.
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-00030: User session ID does not exist.
How to Resolve ORA-00026: missing or invalid session ID
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 Resolve ORA-00026: missing or invalid session ID
How to Kill LOCAL=NO Process at OS-Level
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 »How to Kill LOCAL=NO Process at OS-Level
Alter System Kill Session, Disconnect Session
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 »Alter System Kill Session, Disconnect Session
How Oracle Kill Blocking Sessions
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 »How Oracle Kill Blocking Sessions