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 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, External)                                        

 
10g Specific Docs

New Features of Oracle 10g
Flash Recovery Area
Tuning 10g on Linux using ASM
 New Features in Data Guard

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) 


11g New Features!!!
Oracle Database 11g Editions
Oracle 11g Articles (Oracle Base, External)


Unix Specific Docs

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))
10g Installation on Red Hat Enterprise Linux 5 (RHEL5) (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)

 
Tuning

Oracle Internal Architecture - SGA and Background Process explained

Arquitectura Interna de Oracle (Spanish - pdf)
Oracle Server Architecture (doc)

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)
CheckPoint Tuning and Redo Logs
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


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 Manual (non-automatic) Standby DB
 Activate Manual (non-automatic) Standby
Graceful Failover and Failback on Manual (non-automatic) 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)
Quick RAC Commands
 

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
RMAN Duplicate Database
 

Windows Specific Docs

Managing Oracle on Windows

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

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

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
Cheat Sheets (external) Introduccion a Oracle (Spanish)
TOAD Quick Guide TOAD Hidden Performance Secrets
TOAD Debugging PL/SQL


Great Links

Great Tools 

Free SQL Formatters