Protected: Introduction to Salesforce
There is no excerpt because this is a protected post.
Page 50
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 DataGuard Switchover and Switchback
Oracle 12c DataGuard 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 altered… Read More
Database Archiving in Oracle Database 12c
Dear Readers, In this article, we will see the following Database Archiving in Oracle Database 12c. In this article, We will see how we can implement In-Database Archiving. As an oracle DBA we have biggest challenge is how to deal with historical vast quantities of… Read More
Protected: Shell :EXPORTING DATA FROM REMOTE DATABASE USING NETWORK_LINK
There is no excerpt because this is a protected post.
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
RMAN Commands in Oracle 12c
Dear Readers, In this article, we will see the following RMAN Commands in Oracle 12c. 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… Read More
HOW TO EXPORT DATA FROM REMOTE DATABASE USING DATAPUMP.
HOW TO EXPORT DATA FROM REMOTE DATABASE USING DATAPUMP. In this article, we will see how to export data from remote database and import in source database. Source Database : iP address : 192.168.0.51 Instance Name : primary Remote Database : iP address : 192.168.0.61… Read More
Oracle: Scheduling Rman backup jobs through DBMS_SCHEDULER.
Oracle: Scheduling Rman backup jobs through DBMS_SCHEDULER. In this article we will learn how to schedule RMAN backup jobs through DBMS_SCHEDULER. Before reading this article Please check previous article on DBMS_SCHEDULER. Oracle: Scheduler Jobs in Oracle Database Step 1 : Create the Script That Invokes RMAN Create… Read More
ORACLE ANALYTICAL FUNCTIONS – 1
ORACLE ANALYTICAL FUNCTIONS – 1 In this article, we will see how Analytical functions works in Oracle. Analytical Function : Analytical function is used to compute the aggregate values and perform aggregate operations it returns more than value in each group In sql we have… Read More
