SHELL : EXPORTING DATA FROM REMOTE DATABASE USING NETWORK_LINK In this article , we will how to automate the script for export data from remote database and import in source database. Check below link for previous article on same topic. HOW TO EXPORT DATA FROM REMOTE… Read More
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
|
1 2 |
DBMON>> CREATE TABLE LONG_RUNNING_TABLE(sno number,hiredate date); Table Created. |
Step 2 :… Read More
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
|
1 2 |
DBMON>> CREATE TABLE LONG_RUNNING_TABLE(sno number,hiredate date); Table Created. |
Step 2 : Insert huge… Read More
Shell : Automate killing Blocking Sessions In this article we will learn how to automate killing Blocking sessions using shell script. Please check below video link : Example : AIM : Automate killing user session which is block for more than 15 mins(900 sec).Step 1… Read More
