ALTER SYSTEM KILL SESSION

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

by Ed Chen
March 14, 2023June 6, 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 »

SQL Statement Hang? Why?

by Ed Chen
February 6, 2023June 6, 2023

SQL Statement Hang Statements hanging or waiting always has a reason, lock release. Let's see some cases. UPDATE TABLE Hangs You may saw something is… 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 Resolve ORA-01940: cannot drop a user that is currently connected

by Ed Chen
September 9, 2022July 12, 2023

ORA-01940 Tried to drop an user with all its contents cascadingly, but it failed with ORA-01940. SQL> drop user hr cascade; drop user hr cascade… Read More »

How to Resolve ORA-03135: connection lost contact

by Ed Chen
November 13, 2021June 8, 2022

ORA-03135 ORA-03135 is also a server process problem. As I said in solving ORA-03113: No matter the database is down or session is lost, for… Read More »

How to Resolve ORA-03113: end-of-file on communication channel

by Ed Chen
November 12, 2021October 23, 2022

ORA-03113 Found ORA-03113 when we try to operate with the database. Let's see the case. First of all, we performed a query, meanwhile, the database… Read More »

How to Kill Session in Logon Trigger

by Ed Chen
April 2, 2018April 3, 2018

Here I introduce a trigger which can log logon information on specific schemas. It will kill their sessions if they are not from specific subnet.… 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 »

How to Monitor Unix Memory Usage by Processes

by Ed Chen
October 14, 2012May 4, 2021

Monitor Memory Usage In Unix, you have many tools to monitor the overall memory usage, such as vmstat, sar, top and free. Using vmstat Command… Read More »

JavaScript is not enabled. Please enable it and reload the page.