Automating drop partitions for set of Partition tables(Retention based on Selected Dates) We care for your speed. Below is an easy way to perform Automating drop partitions for set of Partition tables(Retention based on Selected Dates). To Automate the script follow below steps Step 1 :… Read More
Shell script to EXPDP / SCP and IMPDP We care for your speed. Below is an easy way to perform Shell script to EXPDP / SCP and IMPDP. To Automate the script follow below steps Export script : The below script will export only few data… Read More
Automating drop partitions for set of Partition tables(Retention based on No OF DAYS) We care for your speed. Below is an easy way to perform Automating drop partitions for set of Partition tables(Retention based on No OF DAYS) To Automate the script follow below steps Step… Read More
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
