ORACLE: GET NOTIFIED FOR TOP SQL’s ORDERED BY ELAPSED TIME

TOP SQL’s In this article,we will get notified for TOP SQL’s ORDERED BY ELAPSED TIME Step 1 : Create temporary tables to store  TOP SQL’s

Another table to store ALL SQL’s.

Step 2 : Create the below scripts to capture TOP SQL’s in tables… Read More

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

INTRODUCTION TO SQL(Article -1)

INTRODUCTION TO SQL Overview : SQL is a language of database, it includes database creation, deletion, fetching rows and modifying rows etc. What is SQL? SQL is Structured/Syntax/Sequential Query Language, which is a language for storing, manipulating and retrieving data stored in relational database. SQL… Read More

RECOVERY MANAGER BASIC COMMANDS.

RECOVERY MANAGER(RMAN)  COMMANDS. In this article , we will see all the best practices of RMAN commands. Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats. RMAN provides a common interface, via command line… Read More