Paul's Oracle Links

Introduction And Installation

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

 
9i Specific Docs

New Features of Oracle 9i

Dynamic_SGA

Partitions


Advanced PL/SQL (Collections and BULK operations)

Oracle 9i Articles (Oracle Base)                                        

 
10g Specific Docs

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


Unix Specific Docs

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

 
Tuning

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

Oracle Replication Survival Guide Resolving Replication Problems
High Availability Solutions Replication: Creation in 8i (txt version)

Replication: Creation in 8i and Tune (doc version)

Encirq Replication Environment

RAC Filesystem Options
RAC Links and ML Notes
 

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
 

Backup & Recovery

Backup and Recovery General Information Backup And Recovery Information
Recovery Procedure (Graphical) Recovery Procedures

Recover with Missing Arch Redo Logs

Implementing Restore and Recovery Strategy

Backup And Recovery Scripts More RMAN Examples and Docs

Recovery Manager (RMAN)

Rman_Scripts

A Typical RMAN Setup and Configuration

Manage RMAN Repository

Good Link with DB Backup and Recovery Info
 

PeopleSoft Docs

Application Messages Troubleshooting Guide

Environment Management Guide                          

 

 

 

 

 

Windows Specific Docs

NT and Oracle Performance Managing Oracle on NT

Oracle on Win2000 for OLTP Tuning Guide

Oracle on NT for OLTP Tuning Guide

 

Configuring VLDB (excellent info about RAID)

 

Assorted Docs

Effective Coding Style, Naming Standards and Architectural Tips

Oracle Configuration Standards

Optimal Physical Database Design
Secure your database
Temporary Tables Encrypt_Data_and_Code

All about DBMS_Jobs and Intervals

Intermedia Text

OEM

Oracle Datatypes

Tools, Tips and Techniques for DW

Oracle Limitations

Cloning a Database

Parallel Query

DBMS_Output

Deadlocks

All about UTL_FILE Package RAID Configuration

Audit Options

Managing BFILEs

Multi-Threaded Server Overview (MTS) or Shared Server

Type of Indexes

SQL Loader

Profiling in 8i

Loading Data Faster: Testing different Options
Send Mail Through Oracle
XML
Oracle 9i vs. MySQL
SQL Server and Oracle Comparison  Linux vs. Windows NT
Oracle Locking Survival Guide   Create Sample Schemas
SQL Injection Walkthrough   SQL Injection Exampl
Applying Patches to Oracle Several Non Oracle Related Tips
Materialized Views  Autonomus Transactions 
Unix Oracle FAQ  Database Resource Manager (DRM)                                     

Great Links

Great Tools