Index

Grab this widget!

Architecture

1. Background Process in Oracle 10g .
2. Difference Between PFILEand SPFILE In Oracle 10g/11g. - New!
3. Differences between SYSOPER and SYSDBA Privileges: - New!
4. Oracle DBA Interview Questions and Answers- Architecture
5. Oracle Database Complete Internal Architecture
6. Renaming/Relocating a Datafile from original location to new location? - New!

DataGuard

1. Active Dataguard Vs Snapshot Standby Database in Oracle 11g
2. Dataguard Architecture and It's Components in Oracle 11g.
3. How to Convert a Physical Standby to Snapshot Standby with SQL*Plus
4. How to Convert a Snapshot Standby back to Physical Standby with SQL Plus ?
5. Physical Standby Database Creation in Step by Step in Oracle ?
6. Recovering a Standby database from a missing archivelog
7. Steps to recover the primary database's datafile using a copy of a standby database's datafile.
8. What is snapshot Standby Database? What are benefits?

Datapump

1. Datapump Export Parameters in Oracle 11g - New!
2. Datapump Import Parameters in Oracle 11g - New!

Flashback DB Concepts

1. Flash Backing Oracle Database Concepts
2. Oracle Database 10g Flashback Technology.

Interview Questions and Answers

1. Active Dataguard Vs Snapshot Standby Database in Oracle 11g
2. Changing DB ID for the Oracle Database 10g&11g
3. Dataguard Architecture and It's Components in Oracle 11g.
4. Difference Between PFILEand SPFILE In Oracle 10g/11g. - New!
5. Differences between SYSOPER and SYSDBA Privileges: - New!
6. Oracle DBA Interview Questions And Answers-Set-3 - New!
7. Oracle DBA Interview Questions and Answers-Architecture - 1
8. Oracle DBA Interview Questions and Answers-Set-4 - New!
9. Oracle DBA Interview Questions with Answers-Set-1
10. Oracle DBA Interview Questions with Answers-Set-2
11. Oracle RAC DBA Interview Questions and Answers-2 - New!

Oracle DBA Scripts

1. How To Find and Resolve Database Blocking In Oracle ?
2. How to Find The Main Database Wait Events In A Particular Time Interval ??
3. How to Find Top Wait Events Since Instance Startup in Oracle Database?
4. How to find List Of Users Currently Waiting in Oracle Database?
5. How to find Top Recent Wait Events in Oracle Database ?
6. How to find the Total Size of The Oracle Database ?

Oracle Export and Import

1. Oracle Export and Import Overview. - New!

PATCHING

1. How to Apply Critical Patch Updates in Oracle Database?

RAC (10G/11G)

1. How to enable archive mode in the RAC System?
2. Oracle RAC 11gR2 Background Processes
3. Oracle Local Registry (OLR) in RAC 11gR2
4. Adding a New Node to 11g R2 RAC
5. Clusterware Startup Process Step By Step.
6. Clusterware daemons in Oracle 10g/11g R2 RAC
7. How to move OCR and Voting disk to new storage device?
8. Oracle RAC Architecture 10g and 11g
9. Oracle RAC DBA Interview Questions and Answers-2 - New!
10. Steps for how to start RAC Database ?
11. Steps to Shutdown RAC Database
12. Steps to change SCAN IP address in 11gR2 RAC

RMAN

1. Active database Duplication using RMAN 11gR2
2. Changing DB ID for the Oracle Database 10g&11g
3. How to Create a Recovery Catalog Database Using RMAN
4. How to recover datafile block corruption using RMAN?

TROUBLESHOOTING

1. How to view locked objects in a Oracle Database ?
2. Blocking Sessions in oracle database
3. How To Find and Resolve Database Blocking In Oracle ?
4. How to Find The Main Database Wait Events In A Particular Time Interval ??
5. How to Find Top Wait Events Since Instance Startup in Oracle Database?
6. How to check current active sessions in a Oracle Database ?
7. How to find List Of Users Currently Waiting in Oracle Database?
8. How to find Top Recent Wait Events in Oracle Database ?
9. How to find user's current running sql query ? - New!
10. ORA-00845: MEMORY_TARGET not supported on this system

UPGRADE

1. How to Upgrade Oracle 10gR2 to Oracle 11gR1 Step by Step ?