Oracle Information                         

Introduction, Installation, and PL/SQL Information

Introduction to Oracle SQL & PL/SQL

Quick Tips for Oracle and UNIX
Oracle PL/SQL Basics (External)
Bind Variables
PL/SQL Functions
Initialization Parameters LINK1
Analytic Functions
WITH Clause
Oracle Silent Installation (External Link) All About Joins and ANSI 99 Joins

Explicit Cursors

Advanced_Cursors - Cursors for Loop - Ref Cursors - Bulk Collection


Composite Datatypes

Native Dynamic SQL Directory Listing with SQL and JAVA
Advanced PL/SQL (Collections and BULK operations, includes 12c) New Features of Oracle 8i
Exercises to Practice with Collections New Features of Oracle 9i
Install 10g Instant Client (External)

10g Specific Docs

New Features of Oracle 10g
Flash Recovery Area
Tuning 10g on Linux using ASM
New Features for Logical Standby
RMAN 10g New Features Auditing in 10g
Migrating NON-ASM to ASM Regular Expressions cheat_sheet(pdf)

11g Specific Docs
Oracle 11g New Features Uninstall Oracle 11g from Windows
Managing Trace and Alert Files - ADRCI Command Automatic Memory Management (AMM)
Clone with 11g RMAN and Active Database Command Oracle - validated Package - easy Linux Installation
Oracle 11g Articles: Installation, Features (Oracle Base, External) Snapshot Standby DB 11g
Oracle Flashback Data Archive (Total Recall)

12c Specific Docs
Oracle 12c New Features Multitenant Management
Transparent Data Encryption (TDE) in PDBs (External) WITH Clause Enhancements
The Oracle Alchemist (External)
Morgans Library (External)
Arrays and Table Operator Multitenant : Disk I/O (IOPS, MBPS) Resource Management for PDBs (External)
Multitenant : Memory Resource Management for PDBs (External) In-Memory Column Store  (External)
Partition Enhancements in in 12.1 and in 12.2 (External)
Relocate a PDB in Zero Down Time (External)
Online Conversion of a Non-Partitioned Table to a Partitioned Table (External)
Real-Time Materialized Views (External)
Interactive Quick Reference (External)
12c Architecture

Backup & Recovery / RMAN

Recovery Manager (RMAN)

Clone with RMAN and Active Database Command

COMPLETE Guide for Recovery Procedures and Scenarios

Recovery Procedure (Graphical)
Recover DB with Missing Arch Redo Logs Manage RMAN Repository
Clone a Database from Hot or Cold Backup (without RMAN)
RMAN Demos for 10.2
RMAN - Restore to Another Server Flashback Database

Data Guard

**** High Availability Solutions*****

Data Guard DB: Concepts and Creation Clone with RMAN and Active Database Command
Data Guard, Quick Setup Open Physical Standby For Read Write and Flashback
Configuring Data Guard with DG Broker
Using RMAN to Create a Logical Standby
Snapshot Standby DB Active Data Guard
Synchronize a Gap On Arch Log Files on the Standby DB Dataguard Missing Archivelog Files
Data Guard Fast Start Fail-over Implementation (pdf)
Data Guard Fast Start Fail-over and Switchover Configuration (pdf)
Graceful Fail-over and Fail-back on Manual Data Guard
Create Manual (non-automatic) Standby DB


Oracle Architecture and Administration

Arquitectura Interna de Oracle (Spanish - pdf)

Memory Configuration and Use

Multiple Buffers Pools
Shared Pool Management
Tune Redo Log Buffer
All about Statistics
Performance Tuning (pdf)

TUNING (install, tune, analyze, UNDO, hints)

EXPLAIN PLAN and Tips for effective queries

Statspack: Configuration
Analyzing an AWR Report All about Wait Events
More information on Waits
All about LATCHES

SQLTrace and TKProf

All about Triggers and Event Attributes

Managing Tablespaces, Datafiles and Oracle Files

Retrieving the Top-N rows


Transportable Tablespaces

Optimize your Network Configuration Using DBMS_Profiler
Histograms ASH Active Session History

Oracle Enterprise Manager (OEM)
Oracle Enterprise Manager / Grid Basis OEM Reinstall: Change Hostname / IP Address
OEM Quick Commands
OEM Define Email Alerts 

Unix Specific Docs

Unix Commands for DBAs Writing_Unix_Scripts and Bash Shell
Oracle-validated RPM, simplify install of Oracle Oracle / Linux Installation Matrix (External)
Oracle Enterprise Linux 6 Installation Installing Cygwin and X Windows System
Oracle 11gr2 Patch 3 Full Installation Process Install and Configure Oracle 11g on Linux
Uninstalling Oracle on Unix VI Quick Reference
Linux Admin Quick Reference (pdf) The One Page Linux Manual (pdf)
Unix Command Translator
Unix porting Commands (External)
MobaXterm Tips

Oracle and Virtual Environments
Virtualization Suggestions Oracle VM (External)


RAC Basic Information
Step by Step 3 node RAC on Linux (pdf File)
Installing RAC on Virtual Machines (External) RAC 11g Install - Step by Step (External) Very good.
RAC Filesystem Options Quick RAC Commands
RAC for Beginners (pdf) RAC Design and Best Practices (pdf)
RAC 10g on Vmware - Step by Step RAC Links and ML Notes
Oracle 11g RAC Survival Guide (External) RAC 11g on Vmware - Step by Step (pdf)

Windows Specific Docs

Managing Oracle on Windows Windows Backup Scripts

Assorted Docs

Create AWR and ADDM Reports and e-mail them All about DBMS_Jobs and Intervals
All about Partitions

All about Oracle Scheduler

Effective Coding Style, Naming Standards and Architectural Tips

Oracle Configuration Standards

Applying Patches to Oracle (Opatch) Secure your database
Create Sample Schemas Encrypt_Data_and_Code

Materialized Views

Send Mail Through Oracle

Parallel Query Tuning Parallel Execution


XML A How-TO Guide for PL/SQL users (pdf)



All about UTL_FILE Package RAID Configuration

Multi-Threaded Server Overview (MTS) or Shared Server

All about Indexes

SQL Loader

Loading Data Faster: Testing different Options

SQL Injection Walkthrough
SQL Injection Example
Oracle Limitations Autonomus Transactions
Using Comma Separated Lists with DBMS_UTILITY
Date and Times in Oracle
Introduccion a Oracle (Spanish) Purge SYSAUX
TOAD Quick Guide TOAD Hidden Performance Secrets (pdf)
TOAD for App Designer (pdf)
TOAD Team Coding (doc)
TOAD for Data Analysts (pdf)
TOAD 11.5 Functional Matrix Product (pdf)
DataPump or Data Pump
Multi Table Insert and Merge
Regular Expressions

Documentation from Oracle's Web Site

Oracle Master Notes Oracle by Example Series
Oracle 12c Official Documentation Site
Oracle 12c Starting Page
Oracle 12c DB High Availability papers (RMAN, Data Guard, RAC, etc)

Great Links

Great Tools

Free SQL Formatters