Everyday is an interesting day in the life of a DBA. Today, I received a request to run in a HUGE script. This script had 125k INSERT statements each in a separate line. Just opening the script was an issue, leave alone running it into a database. You get this error in SSMS just trying … Continue reading SQL Server: Run A Very Large Script By Splitting It Into Pieces Using PowerShell
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