How to kill Long Running Query using scripts(Version – 2).

How to kill Long Running Query using scripts(Version – 2). In this article , we will see how to write script to kill running query  on Oracle database. Aim : To kill Long Running Query Step 1 : Create a  table

Step 2 :… Read More

How to kill Long Running Query using scripts.

How to kill  Long Running Sessions using scripts. In this article , we will see how to write script to kill running query  on Oracle database. Aim : To kill Long Running Query Step 1 : Create a  table

Step 2 : Insert huge… Read More

Unix Shell Scripting For DBA’s (PART – 06)

Unix Shell Scripting For DBA’s (PART – 06) reference of this article from : www.orskl.com refer previous article https://www.ktexperts.com/unix-shell-scripting-for-dbas-part-05/   Regular expressions What are regular expressions? A regular expression is a pattern that describes a set of strings. Regular expressions are constructed analogously to arithmetic expressions… Read More