Introduction to Oracle SQL & PL/SQL	Quick Tips for Oracle and UNIX
PL/SQL Functions	Initialization Parameters LINK1  and LINK2(orafaq)
Analytic Functions
Explicit Cursors	Advanced_Cursors
Exceptions	Composite Datatypes
Native Dynamic SQL	New Features of Oracle 8i

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

New Features of Oracle 10g	Oracle 10g Top 20 Features
Tuning 10g on Linux using ASM	New Features in Data Guard
Background Processes	Install 10g Instant Client
Auditing in 10g	Wait Interface and Events
Oracle 10g Products (Standard Edition vs EE)	Oracle Official Documentation Site
Oracle Database 10g Products	RMAN New Features

Quick Guide for RHAS 30 for Oracle and Tuning	Installing Oracle 10g on Linux x86
Best Site for Linux and Oracle	Installing Cygwin and X Windows System
Large SGA on UNIX	Installing Oracle 9i for SUN
Linux Benchmark (Secuity_over_Linux)	Uninstalling Oracle
Linux - Oracle Articles	IOSTAT/VMSTAT/NETSTAT
Summary of Unix Commands	Linux Admin Quick Reference
Linux Administration Commands	Writing_Unix_Scripts and Bash Shell
VI Quick Reference	Red Hat Enterprise Linux Manuals
Unix Command Translator	Unix porting Commands

Oracle Internal Architecture
Memory Configuration and Use	Multiple Buffers Pools
TUNING (install, tune, analyze, UNDO, explain plan, hints)	Tips for effective queries (Rules, Driving Table, Explain Plan)
All about Triggers and Event Attributes	CBO and the use of DBMS_STATS
CheckPoint Tuning and Redo Logs	Tune Redo Log Buffer
Statspack: Configuration	ANALYZE A STATSPACK Report
Wait Interface	All about Wait_Events
All about LATCHES	SQLTrace and TKProf
Managing Tablespaces and Datafiles	Retrieving the Top-N rows
New Tablespaces Management options	Transportable Tablespaces
TUNING METHODOLOGY OR CHECKLIST	Performance Tuning (PDF)

 

Replication