V$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 »

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-02030: can only select from fixed tables/views

by Ed Chen
March 30, 2022May 12, 2023

ORA-02030 Tried to grant SELECT object privilege of V$SESSION to an user, but it failed with ORA-02030. SQL> grant select on v$session to erpapp; grant… Read More »

Who Cause Library Cache Lock?

by Ed Chen
February 11, 2017October 7, 2021

I found a session waiting for an event of Library Cache Lock. In the first place, I thought there could be blocking sessions that locked… 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 »

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