Oracle Information

RAC

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)

RAC 11g on Oracle VM and Enterpsie Linux - Step by Step (External) RAC 11g Install - Step by Step (External) Very good.

Oracle 11g Release 2 RAC On Linux Using VMware Server 2 (External) Step by Step 3 node RAC on Linux (pdf File)

Replication

Oracle Replication Survival Guide (External)	Resolving Replication Problems
Replication: Creation in 8i and Tune (doc version)	Replication: Creation in 8i (txt version)
Encirq Replication Environment

Windows Specific Docs

Managing Oracle on Windows

Oracle on Win2000 for OLTP Tuning Guide

Windows Backup Scripts

Assorted Docs

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

Effective Coding Style, Naming Standards and Architectural Tips

Oracle Configuration Standards

Applying Patches to Oracle Secure your database

Create Sample Schemas Encrypt_Data_and_Code

All about Oracle Scheduler

Oracle 10g on Linux vs. Windows (pdf)

OEM

Oracle Datatypes

Audit Options

Oracle Limitations

Parallel Query Tuning Parallel Execution

XML

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

DBMS_Output

Deadlocks

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

Oracle Locking Survival Guide (External)
Send Mail Through Oracle

SQL Injection Walkthrough
SQL Injection Example

Materialized Views
Autonomus Transactions

Using Comma Separated Lists with DBMS_UTILITY
Date and Times in Oracle

Cheat Sheets (external) Introduccion a Oracle (Spanish)

TOAD Quick Guide TOAD Hidden Performance Secrets (pdf)

TOAD for App Designer (pdf)
TOAD Team Coding (doc)

TOAD for Data Analysts (pdf)

Documentation from Oracle's Web Site

Oracle 10g Official Documentation Site	Oracle 10g Product Family (pdf)
Oracle 10g Price List (pdf)	Oracle Master Notes
Oracle 11g Official Documentation Site	Oracle 11g Editions
Oracle 11g Starting Page	Oracle DB High Availability papers (RMAN, Dataguard, RAC, etc)
Oracle by Example Series	Oracle 11g Product Family (pdf)
Understanding Oracle Database Licensing Policies

Great Links

Great Tools

Free SQL Formatters

SQLinForm No download necessary. Feature rich
Online SQL Formatter No download necessary.
SQL Review. Requires a client download and installation.

Introduction to Oracle SQL & PL/SQL	Quick Tips for Oracle and UNIX
Oracle PL/SQL Basics (External)	Oracle Programming/SQL Cheatsheet (External)
PL/SQL Functions	Initialization Parameters LINK1 and LINK2
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
Exceptions	Composite Datatypes
Native Dynamic SQL	New Features of Oracle 8i
Oracle Architecture and Administration

New Features of Oracle 9i	Dynamic_SGA
All on Partitions	Oracle 9i Articles (Oracle Base, External)
Advanced PL/SQL (Collections and BULK operations)	Exercises to Practice with Collections

New Features of Oracle 10g	Flash Recovery Area
Tuning 10g on Linux using ASM	New Features in Data Guard
Upgrade from 10.2.0.1 to 10.2.0.4	Install 10g Instant Client (External)
RMAN 10g New Features	Auditing in 10g
Migrating NON-ASM to ASM	Regular Expressions cheat_sheet(pdf)
Upgrading to 10g (External)	Oracle 10g Articles (Oracle Base, External)
10g Top New Features for DBAs by Arup Nanda (External)	How to Install and Deinstall DBconsole (External)
How to Build a Grid Control Environment (External)

Managing Trace and Alert Files - ADRCI Command	Memory Management Auto (MMA)
Oracle Data Guard	Oracle - validated Package - easy Linux Installation
Oracle 11g Articles: Installation, Features (Oracle Base, External)	11g New Features by Bureleson (External)
11g Top New Features for DBAs by Arup Nanda (External)	11g New Features by Virag Sharma (External)
Installing 11g on Windows (External)	How to Build a Grid Control Environment (External)
How to Upgrade Grid Control 10g to Grid Control 11g (External)	Using RMAN 11g to create Physical Standby
Clone with 11g RMAN and Active Database Command	Clone an 11gr2 DB with RMAN without Target Connection
Standby Physical Standby 11g2 (External)	OEM Cloud Control 12c Release 1 Installation on Oracle Linux 5.7 and 6.1 (External)
Oracle 11gR2 on Windows 7 (External)	Uninstall Oracle 11g from Windows

Oracle-validated RPM, simplify install of Oracle
Install Oracle Linux 5.6 (Step by Step Guide - External)	Oracle Enterprise Linux 5 Installation (External)
Installing Oracle 10g on Linux x86	Installing Cygwin and X Windows System
Oracle 10g and 11g and Linux Articles (External, Great Matrix)	Installing Oracle 10g on SUN
Tuning Linux for Oracle (GREAT PAPER!!)	Large SGA on UNIX
Linux Benchmark (Secuity_over_Linux, pdf)	Uninstalling Oracle on Unix
Unix Commands for DBAs	The One Page Linux Manual (pdf)
Writing_Unix_Scripts and Bash Shell	Linux Admin Quick Reference (pdf)
VI Quick Reference	Red Hat Enterprise Linux Manuals (External)
Unix Command Translator	Unix porting Commands (External)
Linux Quick Reference Note 341782.1	Great oraToolKit Tool and Install Docs of Oracle on Unix Systems (External)

Recovery Manager (RMAN)	Manage RMAN Repository
RMAN Demos for 10.2	RMAN Quick Start Guide (pdf)
Backup Information	Recovery Procedure (Graphical)
COMPLETE Guide for Recovery Procedures and Scenarios	Recover DB with Missing Arch Redo Logs
Clone a Database from Hot or Cold Backup (without RMAN)
RMAN Duplicate Database (10g)	Clone with RMAN and Active Database Command (11g)
Using RMAN 11g to create Physical Standby	Clone an 11gr2 DB with RMAN without Target Connection

Standby DB: Concepts and Manual Creation	Standby Physical Standby 11g2 (External)
Using RMAN 11g to Create a Physical Standby	Using RMAN 11g to Create a Logical Standby
Synchronize a Gap On Arch Log Files on the Standby DB	Oracle 10g DataGuard Summary Sheets v2.0 (pdf)
Data Guard Fast Start Failover Implementation (pdf)	Data Guard Fast Start Failover and Switchover Configuration (pdf)
Graceful Failover and Failback on Manual (non-automatic) Data Guard DB's	Information and Commands (external)
Create Manual (non-automatic) Standby DB	Activate Manual (non-automatic) Standby
Oracle Dataguard Docs (External with Cases, Demonstration, Best Practices)

Oracle Internal Architecture - SGA and Background Process explained	Arquitectura Interna de Oracle (Spanish - pdf)
Oracle Server Architecture (doc)	CheckPoint Tuning and Redo Logs
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)	Tips for effective queries (Driving Table, CBO and EXPLAIN PLAN)
Statspack: Configuration	ANALYZE A STATSPACK Report
Analyzing an AWR Report	Wait Interface and Events
Wait Interface	All about Wait_Events
All about LATCHES	SQLTrace and TKProf
Managing Tablespaces, Datafiles and Oracle Files	Retrieving the Top-N rows
TUNING METHODOLOGY OR CHECKLIST	Transportable Tablespaces
Optimize your Network Configuration	Using DBMS_Profiler
Oracle Performance Diagnostic Guide (External ML Note: 390374.1	All about Triggers and Event Attributes

Oracle Enterprise Manager / Grid Basis	OEM_11g_Grid_Control_Installation
OEM Reinstall: Change Hostname / IP Address	OEM 11g Grid Install on Linux (pdf)
OEM Quick Commands	OEM Define Email Alerts

VMware and Oracle Setup Examples (External)	VMware ESX Server 3.5 Update 2 Installation (External)
Vmware Install, Centos and Oracle 10gr Installation (external)	Virtualization Suggestions

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)
RAC 11g on Oracle VM and Enterpsie Linux - Step by Step (External)	RAC 11g Install - Step by Step (External) Very good.
Oracle 11g Release 2 RAC On Linux Using VMware Server 2 (External)	Step by Step 3 node RAC on Linux (pdf File)

Managing Oracle on Windows
Oracle on Win2000 for OLTP Tuning Guide	Windows Backup Scripts

Create AWR and ADDM Reports and e-mail them	All about DBMS_Jobs and Intervals
Effective Coding Style, Naming Standards and Architectural Tips	Oracle Configuration Standards
Applying Patches to Oracle	Secure your database
Create Sample Schemas	Encrypt_Data_and_Code
All about Oracle Scheduler	Oracle 10g on Linux vs. Windows (pdf)
OEM	Oracle Datatypes
Audit Options	Oracle Limitations
Parallel Query	Tuning Parallel Execution
XML	XML A How-TO Guide for PL/SQL users (pdf)
DBMS_Output	Deadlocks
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
Oracle Locking Survival Guide (External)	Send Mail Through Oracle
SQL Injection Walkthrough	SQL Injection Example
Materialized Views	Autonomus Transactions
Using Comma Separated Lists with DBMS_UTILITY	Date and Times in Oracle
Cheat Sheets (external)	Introduccion a Oracle (Spanish)
TOAD Quick Guide	TOAD Hidden Performance Secrets (pdf)
TOAD for App Designer (pdf)	TOAD Team Coding (doc)
TOAD for Data Analysts (pdf)