Oracle Information

RAC

Windows Specific Docs

Managing Oracle on Windows Windows Backup Scripts

Assorted Docs

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

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
Exceptions	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)

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)

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)

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

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 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	ANALYZE A STATSPACK Report
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
TUNING METHODOLOGY OR CHECKLIST	Transportable Tablespaces
Optimize your Network Configuration	Using DBMS_Profiler
Histograms	ASH Active Session History

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

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

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)

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	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
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