Protected: Introduction to Salesforce
There is no excerpt because this is a protected post.
Month: April 2019
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
|
1 2 3 4 5 |
SYS>>CREATE TABLE dbmon.TOP_ELAPSEDTIME_SQLIDS ( SQL_ID VARCHAR2(20 CHAR), LASTMODIFIEDDATE DATE DEFAULT SYSDATE NOT NULL ); |
Another table to store ALL SQL’s.
|
1 2 3 4 5 |
SYS>>CREATE TABLE dbmon.ALL_ELAPSEDTIME_SQLIDS ( SQL_ID VARCHAR2(20 CHAR), LASTMODIFIEDDATE DATE DEFAULT SYSDATE NOT NULL ); |
Step 2 : Create the below scripts to capture TOP SQL’s in tables… Read More
Oracle 12c Data Guard Switchover and Switchback
Oracle 12c Data Guard Switchover and Switchback Please check my previous article on Active standby database. How to build ACTIVE STANDBY DATABASE using RMAN DUPLICATE command in 12c.(Video included) After configuring data guard, databases would be either primary and standby database role, and we can… Read More
