Oracle Database Administration (DBA)

Oracle Database Architecture

1. Oracle Server Architecture (Q&A)

2. Oracle Shared vs. Dedicated Server Architecture (Q&A)

3. Oracle Physical Database Structure (Q&A)

4. Oracle Database Listener  (Q&A)

5. XPT Oracle database service

6. PLSExtProc Oracle database service

7. Oracle service name

8. Oracle Heterogeneous Services

Oracle Database Backup & Recovery

1. Backup & Recovery Overview

2. EXP/ IMP utility

3. User-Managed Backups

4. RMAN Overview

5. How to create the RMAN Catalog

6. FULL online database backup using RMAN Recovery Catalog

7. Incremental database backup using RMAN

8. Recovering a file using a cumulative backup (with RMAN) 

9. Testing Media Block Recovery (MBR) using RMAN

10. RMAN Incomplete Recovery (in NOARCHIVELOG mode)

11. RMAN Incomplete Recovery (in ARCHIVELOG mode)

12. RMAN Catalog Maintenance

13. How to validate a backup

14. RMAN configuration

Oracle Database Maintenance

1. Managing Tablespaces and Datafiles

2. Managing Database Tables and Indexes

3. Managing Data Security 

4. Database ARCHIVELOG mode

5. Managing Oracle database jobs

6. Killing Oracle a particular job at the OS level

7. PFILE vs. SPFILE

8. SQL * Loader

9. Table & Index Partitioning

10. Partitioning an online table

11. What Database & OS version I use ?

12. "Strange" behavior: System can change sys password

13. Oracle restart

14. ORA-12514 after service creation with Entreprise Manager 11.2

Oracle 10g New Features

1. Oracle 10g New Features Overview

2. Speed up the schema refresh over a DBlink with Data Pump

3. Oracle Grid Control

4. Oracle Flashback 

5. Virtual Private Database (VPD)

6. Preparing UNIX/ Solaris/ Linux for Oracle 10g Installation

1. Oracle RAC (10g) Architecture Picture

2. Oracle RAC (10g) Architecture Q&A

3. Installing the Real Application Cluster (10g)

4. Adding a node to a 10g RAC

5. Oracle Real Application Cluster (Q&A)

6. Oracle Clusterware components

7. Oracle RAC clusterware OCR and the Voting disk.html

8. 11gR2 Clusterware startup sequence

9. 11gR2 RAC CRSCTL command

10. 11gR2 RAC SRVCTL command

11. 11gR2 RAC Services Administration

12. Oracle 11gR2 Clusterware log files

13. Startup the Oracle 11gR2 clusterware

14. Stop the Oracle 11gR2 clusterware

Oracle Replication 

1. Materialized views  

2. Oracle Streams: How to Replicate a Table

3. How to create a Physical Standby database with RMAN

4. How to create a Physical Standby Database (step-by-step) 

5. How to create a Logical Standby database (step-by-step)

6. Monitor a Standby Database 

7. Failover & Swichover (Basics)

1. Tuning Overview

2. Instance Tuning: SGA Tuning

3. Objects Tuning

4. SQL statement Tuning

5. tkprof utility

6. Statspack utility

7. The "Explain Plan" Command

8. I/O tuning

9. Enable the tracing in the database

10. AUTOTRACE feature

Oracle 11g New Features

1. Oracle Database 11g Step-by-step Installation on Windows

2. The Top New Features for DBAs and Developers

3. Database Replay

4. Partitioning: New Features, Virtual Columns, Invisible Indexes

5. Caching and Pooling

   Other links related to Oracle DBA field:

•    Oracle DBA Certifications

•    Download Oracle database software