In various critical situations, Oracle DBA has to decide whether to kill the existing sessions or kill the background process of Oracle.
Then the question is raised that in which type of situation remote dba should need to kill the session and process. We are explaining those situations and incidents here.
When blocking lock occurs and other sessions are waiting to acquire a lock on the same object. But the blocker session doesn’t end the transaction. At this moment, Remote Oracle dba should need to identify blocking sessions and terminate them for clearing resources for other sessions.
When maximum connections are reached, an error occurs. No room is available for any new connection or session. At this time, the Remote Oracle DBA should need to kill some of the idle processes from the Oracle database.
When the database is found in hang status and the shutdown abort command also doesn’t work, at the same time Remote DBA should need to terminate the instance abnormally with murdering background processes.
In the above critical situation, we need to kill or terminate or murder some session or process using the command line or GUI utility like OEM, TOAD, etc. But the command line is easier and more helpful to solve such critical situations in remote DBA support services.
Please find the following new articles on the same topic.
Article explains how to kill session in Oracle using sqlplus utility.
Article explains how to kill session in Oracle 11g using new feature.
Article explains how to kill session in Oracle RAC databases.
Article explains how to kill session using only operating system commands in Unix,Linux & Windows without Sqlplus.
All the best,
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.