KTEXPERTS – Page 52 – KNOWLEDGE SHARING PLATFORM

ORACLE: GET NOTIFIED FOR TOP SQL’s ORDERED BY ELAPSED TIME

7 years ago by Vinod SiramOracle DB Admin

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
);

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 TABLE dbmon.ALL_ELAPSEDTIME_SQLIDS
(
  SQL_ID            VARCHAR2(20 CHAR),
  LASTMODIFIEDDATE  DATE                        DEFAULT SYSDATE               NOT NULL
);

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

7 years ago by Binnary Ajay KumarOracle Dataguard

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

7 years ago by Binnary Ajay KumarOracle 12C New Features

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

7 years ago by Binnary Ajay KumarOracle DB Admin

There is no excerpt because this is a protected post.

INTRODUCTION TO SQL(Article -1)

7 years ago by Ramesh ReddyMySQL

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

7 years ago by Binnary Ajay KumarOracle 12C New Features

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.

7 years ago by Binnary Ajay KumarOracle Datapump (Export & Imports)

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.

7 years ago by Binnary Ajay KumarOracle DB Admin

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

7 years ago by Ramesh ReddySQL

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

Protected: How to kill Long Running Query using scripts.

7 years ago by Binnary Ajay KumarOracle DB Admin

There is no excerpt because this is a protected post.