Introduction to Oracle SQL & PL/SQL	Quick Tips for Oracle and UNIX
PL/SQL Functions	Initialization Parameters LINK1  and LINK2
Analytic Functions
Oracle Silent Installation	All About Joins
Explicit Cursors	Advanced_Cursors - Cursors for Loop - Ref Cursors - Bulk Collection
Exceptions	Composite Datatypes
Native Dynamic SQL	New Features of Oracle 8i

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

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)
Oracle Official Documentation Site (External)	Oracle 10g Articles (Oracle Base, External)
Upgrading to 10g (External)	Oracle Database 10g Products (External)
Oracle 10g Price List (pdf)	Oracle 10g Product Family (pdf)
Oracle by Example Series

Quick Guide for RHAS for Oracle and Tuning	Installing Cygwin and X Windows System
Installing Oracle 10g on Linux x86	Installing Oracle 10g on SUN
Best Site for Linux and Oracle (External)	Oracle on SUSE (with screen shots, External)
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)
Metalink Note on Linux Quick Reference = 341782.1	The Oracle-on-Linux Installation Menu (External)
Oracle and Linux Articles

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)
Analyzing an AWR Report
Statspack: Configuration	ANALYZE A STATSPACK 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

Standby or Data Guard

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

Standby DB: Concepts and Creation	Standby DB: Another Method to Create
Data Guard Recommendations	Events that affect Standby DB
Create Manual (non-automatic) Standby DB	Synchronize a Gap On Arch Log Files on the Standby DB
RMAN Create Logical Dataguard DB	Activate Manual (non-automatic) Standby
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)

 

RAC