Protected: Introduction to Salesforce
There is no excerpt because this is a protected post.
Articles
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 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. SYS>>CREATE… 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
Oracle : In-Database Archiving in Oracle Database 12c Release 1
Oracle : In-Database Archiving in Oracle Database 12c Release 1 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 data? As an Oracle DBA we… Read More
Shell :EXPORTING DATA FROM REMOTE DATABASE USING NETWORK_LINK
SHELL : EXPORTING DATA FROM REMOTE DATABASE USING NETWORK_LINK In this article , we will how to automate the script for export data from remote database and import in source database. Check below link for previous article on same topic. HOW TO EXPORT DATA FROM REMOTE… 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 DBMON>> CREATE TABLE LONG_RUNNING_TABLE(sno… 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
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
