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

$ cat elapsed_query_details.sql

Note :

Step 3 :

Execute the below script

Output : Once we executed the script the output will follow as below.

The a

Step 4 :

Check the tables for SQL Id’s

Try to delete few records in temporary table and execute above script.

Then check the new SQL Id’s in temporary table.

 

 

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment