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

BASIC SQL CLASS (Vimeo Links).

BASIC SQL CLASS (Vimeo Links). S.no Video Vimeo Link Password Topic Description 1 Class-1 https://vimeo.com/285140850 sql Introduction to DBMS. What is SQL? History of SQL? Features of SQL? What are Codd Rules? 2 Class-2 https://vimeo.com/285330531 sql Oracle installation on windows platform. Explanation about codd rules.… Read More

Oracle : Shell script for Health Check in HTML Format

 

Oracle : Script for Sending email for Blocking Sessions