You Don't Have to Be a Geek to Know SCAN NAME, SCAN VIP, SCAN Listener, Node VIP, Local_Listener and Remote_Listener

SCAN NAME concept was introduced in Oracle 11g and it's still unsolved mystery for few of the Database Administrators. The main purpo...

Step by Step Process to Create Single Instance Database using DBCA

Creating Single Instance database using DBCA is easiest way to create database in Oracle. Most of the DBA's prefer this tool for data...

The Lazy DBA's Way to Create Real Application Cluster (RAC) Database using DBCA

Database creation is day to day task for a Database Administrator and DBCA is easiest way to create a Database but when talk about Create ...

See How Easily you can Solve "Log File Sync" Wait Event ?

Log File Sync - I believe every Database Administrator has seen this wait event during his work. Few can solve log file sync wait Event...

This Manual Database Creation Script Works for Me. It Can Work for you, Too !

Manual Database Creation - DBA's are still using this approach for creating databases. The reason is, you need not any GUI access like...

Quick Steps to Configure Tnsnames.ora and Listener.ora file

Tnsnames.ora and Listener.ora are main files for database connection, So Configure Tnsnames.ora and Listener.ora file has become an impor...

Here is a Method to Move Table or Schema Statistics to a Different Database using DBMS_STATS

Usually DBA face issue like unexpected execution plan by sql query. One of the common reason for this could be statistics of the table or ...