The v$session view If you do not know already, to check who is connected and since when, what their connection status is etc., you would use dynamic view v$session. The view has the following columns: You would kill the required session by issuing Note: The IMMEDIATE option of the above command just returns control … Continue reading Oracle – My KILL’ed Session Continues To Stay On In KILLED Status, Why?
Usually, when you connect to Oracle, you get errors that give you some feedback on what is happening. Today, I ran into an issue where everything just hung. TNSPing, SQLPlus... you name it. The issue had to be connectivity related but what is it? In our case, we use an LDAP server as a directory … Continue reading SQLPlus, TNSPing & everything just hang without errors
Yes. Yesterday was my last day as an application/database Architect. I still love to architect solutions but will not be doing that (only enabling it instead) officially at my job anymore. I want to learn more and so I chose to be a DBA for Oracle and SQL Server as my primary job function. You might be … Continue reading Busy Buffer Waits ….and being a DBA