Oracle

1. Oracle Database and Instance

2. Data Storage

3. Oracle Startup and Shutdown Process

4. Tablespaces and their Management

5. Undo Management

6. Users Management

7. Shared Server and Dedicated Server Architecture

8. Scheduling Jobs

   1. Networking and DB Links

9. Performance Tuning

10. Data Moving

11. Database Recovery Types in progress

12. Recover Manager - RMAN

13. Reading Oracle Statspack Report/ AWR

14. Session Monitoring - Oracle Latches, Locks and Waits

15. Oracle Database Hardening and Best Practises

DBA Activities

Monitoring Scripts

Creating / Dropping Database

Creating Standby Database

Indexes

New Articles

Oracle Database Manual Standby Database - Standard Edition

Oracle 11G

Oracle12c

RAC Oracle Real Application Cluster Windows

RAC Oracle Real Application Cluster Linux x86

ASM (Automatic Storage Management)

Miscellaneous

Corrupted or deleted datafile from production - Restoration from Standby dr server

Diagnostic ADR, DRA ....

Commonly Observed Oracle Error

Generating "create" scripts of database objects through dbms_metadata package

Changing the database name using NID

Oracle Patches CPU and PSU

Shrinking Table,index, Reclaiming Space at OS, HWM

Auditing

Important Views on session

Database block corruption

Flashback Technology

INIT Parameter Details

Oracle Transparent Data Encryption

Oracle Data Pump

PL/SQL For DBA

Commonly Observed ORACLE Errors

As someone says "Error messages and log files are troubleshooter's best friend"

Here we lool at the commonly observed Oracle Errors