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

DIFFERENCE BETWEEN ORACLE AND MySQL -05

DIFFERENCE BETWEEN ORACLE AND MySQL -05 Please refer my previous articles. DIFFERENCE BETWEEN ORACLE AND MySQL -04 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 In Oracle ,we need to write Parameters to set (or)… Read More

DIFFERENCE BETWEEN ORACLE AND MySQL -04

DIFFERENCE BETWEEN ORACLE AND MySQL. Please refer previous article . DIFFERENCE BETWEEN ORACLE AND MySQL -03 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 How to check metadata of table ? SYS>> desc <objectname> “;”… Read More