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 ...

How to Shutdown and Start Oracle Real Application Clusters Database - These 10 Easy Steps

Shutdown and Start Oracle Real Application Clusters Database is any activity, which is performed by DBA for Applying CRS patch, Schedule...

3 Familiar Control file Commands for DBAs

Control file in Oracle is a binary file, which keeps record of physical database structure. Control file has information related to Datab...

5 Secretes to Become a Successful Database Administrator (DBA)

Every body wants to be success, so do I. You might have seen people as very successful Database Administrator (DBA) around you. I have be...