Oracle Information

Introduction And Installation

Introduction to Oracle SQL & PL/SQL

Quick Tips for Oracle and UNIX
PL/SQL Functions
Initialization Parameters LINK1  and LINK2
Analytic Functions
Oracle Miscellaneous Functions (External)
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

 
9i Specific Docs

New Features of Oracle 9i

Dynamic_SGA

All on Partitions


Advanced PL/SQL (Collections and BULK operations)

Oracle 9i Articles (Oracle Base)                                        

 
10g Specific Docs

New Features of Oracle 10g
Flash Recovery Area
Tuning 10g on Linux using ASM
New Features in Data Guard
Background Processes
Install 10g Instant Client (External)
Auditing in 10g
Wait Interface and Events
Regular Expressions cheat_sheet(pdf) Oracle Official Documentation Site (External)
Oracle Database 10g Products (External)
RMAN New Features
Upgrading to 10g (External)
Migrating NON-ASM to ASM
Oracle 10g Price List (pdf)  Oracle 10g Product Family (pdf) 


11g New Features!!!
Oracle Database 11g Editions


Unix Specific Docs

Quick Guide for RHAS 30 for Oracle and Tuning
Installing Cygwin and X Windows System
Installing Oracle 10g on Linux x86 Installing Oracle 10g for SUN
Best Site for Linux and Oracle (External)
Oracle on SUSE (with screen shots, External))
Large SGA on UNIX
Installing Oracle 9i for SUN
Linux Benchmark (Secuity_over_Linux) Uninstalling Oracle
Linux - Oracle Articles (External)
Linux Admin Quick Reference (pdf)

Summary of Unix Commands

Linux Administration Commands (top, etc)

Writing_Unix_Scripts and Bash Shell Tuning Linux for Oracle (GREAT PAPER!!)

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)

 
Tuning

Oracle Internal Architecture - SGA explained

Arquitectura Interna de Oracle (Spanish - pdf)

Oracle Server Architecture

Memory Configuration and Use

Multiple Buffers Pools
Shared Pool Management
Tune Redo Log Buffer
Tuning by Statistics
Performance Tuning (PDF)

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

Tips for effective queries (Rules, Driving Table, Explain Plan)

CheckPoint Tuning and Redo Logs CBO and the use of DBMS_STATS
Statspack: Configuration
ANALYZE A STATSPACK Report
Wait Interface
All about Wait_Events

All about LATCHES

SQLTrace and TKProf

Managing Tablespaces, Datafiles and Oracle Files

Retrieving the Top-N rows

New Tablespaces Management options

Transportable Tablespaces

TUNING METHODOLOGY OR CHECKLIST Using DBMS_Profiler
Oracle Performance Diagnostic Guide (External ML Note: 390374.1
All about Triggers and Event Attributes
Optimize your Network Configuration



High Availability Solutions

Standby or Data Guard

Standby DB: Concepts and Creation Standby DB: Another Method to Create

Data Guard Recommendations

Events that affect Standby DB

Create non-automatic Standby DB
Activate non-automatic Standby
Graceful Failover and Failback non Data Guard DB's
Information and Commands (external)
RMAN Create Logical Dataguard DB
 

RAC

RAC Filesystem Options Step by Step 3 node RAC on Linux (pdf File)
RAC for Beginners (pdf) RAC Design and Best Practices (pdf)
RAC 10g on Vmware - Step by Step RAC Links and ML Notes
Oracle 11 RAC Survival Guide (External) RAC 11g on Vmware - Step by Step (pdf)
 

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



Backup & Recovery / RMAN

Backup and Recovery General Information
Backup and Recovery Checklist (PDF)
Backup Information Recovery Procedures
Recovery Procedure (Graphical)
Recover with Missing Arch Redo Logs
Backup And Recovery Scripts
Clone a Database from Hot or Cold Backup

Recovery Manager (RMAN)

Manage RMAN Repository

RMAN Demos for 10.2
RMAN Quick Start Guide
 

Windows Specific Docs

Managing Oracle on Windows Configuring VLDB (excellent info about RAID)

Oracle on Win2000 for OLTP Tuning Guide

Windows Backup Scripts

 



Assorted Docs

Effective Coding Style, Naming Standards and Architectural Tips

Oracle Configuration Standards

Optimal Physical Database Design
Secure your database
Create Sample Schemas Encrypt_Data_and_Code

All about DBMS_Jobs and Intervals

Intermedia Text

OEM

Oracle Datatypes

Tools, Tips and Techniques for DW

Oracle Limitations

Parallel Query Tuning Parallel Execution

XML

Introduccion a Oracle (Spanish)

DBMS_Output

Deadlocks

All about UTL_FILE Package RAID Configuration

Audit Options

Managing BFILEs

Multi-Threaded Server Overview (MTS) or Shared Server

All about Indexes

SQL Loader

Loading Data Faster: Testing different Options

SQL Server and Oracle Comparison  Oracle 9i vs. MySQL
Oracle 10g on Linux vs. Windows (pdf)
Oracle 9i on Linux vs. Windows NT(word)
Oracle Locking Survival Guide (External)
Send Mail Through Oracle
SQL Injection Walkthrough
SQL Injection Example
Applying Patches to Oracle Several Non Oracle Related Tips
Materialized Views
Autonomus Transactions
Using Comma Separated Lists with DBMS_UTILITY
Date and Times in Oracle
TOAD Quick Guide


Great Links

Great Tools 

Free SQL Formatters