Fast Application Notification [FAN] overview

As the Oracle docs say, The Oracle RAC, FAN, Oracle 12c Fast Application Notification (FAN) feature provides a simplified API for accessing FAN events through a callback mechanism. This mechanism enables third-party drivers, connection pools, and containers to subscribe, receive and process FAN events. These APIs are referred to as Oracle RAC FAN APIs. If […]

Read More

Sosreport on Oracle Linux

The “sosreport” is a tool to collect troubleshooting data on an Oracle Linux system. It generates a compressed tarball of debugging information that gives an overview of the most important logs and configuration of a Linux system, to be sent to Oracle Support. Among other things, the sosreport includes information about the installed rpm versions, […]

Read More

TopicWise Interview Question on Oracle Database

Here is some Oracle Listeners Interview Question, hope it will help you. Listener Question: http://clouddba.co/generic-dba/ Here is some Oracle Tablespace  Interview Question, hope it will help you. Tablespace Question: http://clouddba.co/generic-dba/ Here is some Oracle EXPDP IMPDP Datapump Interview Question, hope it will help you. EXPDP IMPDP Datapump Question: http://clouddba.co/expdp-impdp-datapump-interview-questions/ Here is some Oracle Database Architecture Interview Question, hope it will help you. Database Architecture Question: http://clouddba.co/database-architecture-interview-questions/ […]

Read More

Types of Supplemental logging at Database level

Redo log files are generally used for instance recovery and media recovery. The data needed for such operations is automatically recorded in the redo log files. However, a redo-based application may require that additional column be logged in the redo log files. The process of logging these additional columns is called supplemental logging. There are two […]

Read More

Downgrading Grid Infrastructure from 12.1.0.2 to 11.2.0.4

In the last article, we performed downgrade of Oracle RAC Database from 12c to 11gR2. In this article, we are going to downgrade Oracle Grid Infrastructure from 12c (12.1.0.2) to 11gR2 (11.2.0.4) which contains two nodes ( node 1 & node 2). Before doing CRS downgrade we need to take backup of following files : Take tar […]

Read More

Downgrading a RAC database from 12.1.0.2 to 11.2.0.4

In the last article, we performed downgrade of Oracle Standalone Database from 12c to 11gR2. In this article, we can downgrade the 2 node RAC 12.1.0.2 database to 11.2.0.4, downgraded the database only and not the grid home. Assume all commands are being run on node 1, any commands that need to be run on node 2 […]

Read More

Downgrade Oracle Database from 12c to 11gR2

We have already upgraded Oracle Database11gR2 to 12c, the whole process is still relatively smooth, although some of the previous version of the upgrade is not the same, but the overall difficulty is not too large, because of too many different features, greatly extended the upgrade time. But for Oracle 12c back to the previous […]

Read More

Killable Processes in Oracle Database

A multiprocess Oracle database uses some additional processes called background processes. The background processes perform maintenance tasks required to operate the database and to maximize performance for multiple users. Mandatory Background Processes Optional Background Processes Slave Processes There are few processes which we can kill without terminating the instance. Killable: ARCn: Redo log archivers CJQn: Job […]

Read More

Oracle Internals – Fixed Objects – Part 1

Dynamic Performance Views Oracle contains a set of underlying views that are maintained by the database server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open and in use, and their contents relate primarily to performance. Although these views […]

Read More

What happens in the background in Rebuild Index

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. I’ll show you what happens during an online rebuild of an index. Few DBAs realize this, but during this operation an auxiliary index (among other things) is created to store the transient data while the application continues to run normally. Note that for […]

Read More