ALTER SYSTEM KILL SESSION

How to Resolve ORA-01940: cannot drop a user that is currently connected

by Ed Chen
September 9, 2022July 27, 2022

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, 2021April 6, 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 »

KILL SESSION vs DISCONNECT SESSION

by Ed Chen
August 1, 2014May 1, 2022

Oracle SQL provides end_session_clauses syntax to terminate sessions: ALTER SYSTEM { DISCONNECT SESSION 'integer1, integer2' [ POST_TRANSACTION ] | KILL SESSION 'integer1, integer2 [,@integer3]' }… Read More »

How Oracle Kill Blocking Sessions

by Ed Chen
March 9, 2013December 21, 2021

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 »