As I have only just started my journey into the Oracle 10g DBA world, I wanted a site that covers the basics in order for me to gain my OCP and help me in remembering the vast information that comes with learning Oracle. As my journey continues the site will hopefully become more advanced and have more specialized areas such Data Guard, Oracle RAC, etc. I plan on creating cheat sheets that cuts out all the fluff for each area were appropriate but in the mean time a very good site can be located here.

The site has been comprised of reading the following books and real world experience, if you are new to Oracle I highly recommend that you should purchase these books as they contain far more information than this web site contains and of course the Oracle web site contains all the documentation you will ever need.

Please feel free to email me any constructive criticism you have with the site as any additional Oracle knowledge or mistakes that i have made would be most welcomed.


Data Modeling
  Relational Databases (Introduction)
  Normalization (Forms, ER Modeling)

  Database Physical Structure (Data Blocks, Extents, Segments, Tablespace's)
  Oracle Processes (background processes)
  Database Memory Structure (SGA, PGA)
  Oracle Files (Control file, Redo log, pfile, spfile, password, alert log, trace files)
  Oracle OEM (Enterprise Manager)

Transactions Management, Locking and Concurrency
  Transaction Management
  Locking and Concurrency (Isolation, Lock Types, Multicurrent versioning)

Undo and Transaction Management
  Undo (AUM)
  Flashback architecture
  Resumable space allocation

Installing, Creating and Upgrading databases
  Installing Oracle
  Creating a Database (Manually, DCBA)
  Upgrading a Database (Manually, DBCA)

Controlling Oracle
  Starting and Stopping Oracle (startup, shutdown)
  Operation Modes (restrict,quiesce)
  Obtaining Database information (database/instance info, version, etc)
  Oracle Default Port Numbers
  Database Control Agents

Tablespace Management
  Tablespace's (types, creating, altering, dropping)

Schema and User Management
  Schema Management
  Users (creating, altering, dropping, quotas, profiles)
  Data Access (system privileges, object privleges, roles

Tables and Indexes
  Oracle Data Types (char, number, datatime, etc)
  Tables (heap-organized)
  Special Tables (temporary, IOT, clustered, partitioned)
  Indexes (bitmap, reverse-key, function-based, partitioned)
  Integrity Constraints (primary key, not null, check, unique, referential integrity)

View, Materialized Views, Sequences, Synonyms and Triggers
  Materialized Views
  Triggers (DDL, DML, Compound, Instead-of, System Triggers)

  Networking and Connectivity architecture (dedicated, shared server)

  User Management
  Accessing Data (system privileges, object privileges, roles)
  Resource Management (resource plans, resource consumer groups)
  Fine-Grained Data Access (VPD)
  Auditing the Database (standard, FGA)

Data Loading
  Extraction, Transformation and Loading (introduction)
  SQL Loader
  External Tables
  Transforming Data
  Oracle Streams
  Data Pump Export and Import
  Transportable Tablespace's

Backups and Data Recovery
  RMAN backups
  Database Recovery (non-critical/critical files, incomplete recovery, user errors, flash recovery)
  Database Corruption (block corruption)

Operational Management
  Automatic Database Diagnostic Monitor (ADDM)
  Automatic Shared Memory Management (ASMM - SGA)
  Automatic Optimizer Statistics
  Automatic Storage Management (ASM)
  Automatic Segment Space Management (ASSM)

Managing and Monitoring the Database
  Performance Statistics
  Automatic Workload Repository (AWR)
  Server Alerts (ADDM)
  Active Session History (ASH)
  Management Advisory Framework (Oracle Advisors)
  Managing Database Links
  Oracle Scheduler

Performance Tuning
  SQL Optimization
  Join Methods (Natural, Inner and Outer)
  Tuning the Instance
  Performance Tuning Tools

Data Dictionary, Dynamic Views and Supplied Packages
  Oracle Data Dictionary
  Oracle PL/SQL Supplied Packages

  Oracle Data Types (char, number, datetime, etc)
  Object Types (basics, getters and setters, static member methods, comparing objects, inheritance and polymorphism)
  SQL Primer (DDL, DQL, DML and DCL)
  PL/SQL Code Basics (Procedures, Functions, Exceptions, Bind Variables, Variable Types, Variable Scope, Conditional Logic)
  PL/SQL and SQL (Cursors)
  PL/SQL Packages (Variables, scope, definer v invoker rights)
  PL/SQL Advanced Programming (Dynamic SQL - NDS, DBMS_SQL Package)
  Collections (varrays, nested tables, associative arrays, bulk collect, forall)
  Large Objects (CLOB, NCLOB, BLOB and BFILES)
  Intersession Communications (dbms_pipe, dbms_alert)
  External Procedures (C and Java)

OCA & OCP Exam Books
Sybex OCP Oracle 10g Admin I/II Nice easy reading and good books to get you through the exams
Osbourne OCP Certification all-in-one exam guide I always like two books on the same subject, so this book compliments the one above.
Advanced Oracle Books
Oracle Database 11g PL/SQL Programming - Michael McLaughlin This book is more on the development side, it includes lots of the new 11g features and is one of the best books i have read, it explains things clearly without to much waffle (straight to the point).
Apress Expert Oracle Database 10G Administration - Sam.R.Alapati This book is from the view of a Oracle DBA admin, although a heavy going book, I highly recommend it.
Apress Expert Oracle Database Architecture 9i and 10g programming techniques and solutions - Thomas Kyte This book is more from the developer side and compliments the above book, this book is the next version of the excellent 'Expert one-to-one' series.
Osbourne Oracle 10g The Complete Reference - Kevin Loney For a Oracle junior DBA this book is a good book to have on your desktop
Osbourne Oracle database 10g performance tuning Tips and Techniques - Richard Niemiec This is an excellent book for tuning the database, has a excellent chapter on the mysterious x$ tables (advanced Oracle stuff).