Oracle Stuff


UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm

Introduction And Installation
Creating a Data Warehousing DB
Quick Tips for Oracle and UNIX
Introduction to Oracle SQL & PL/SQL
Introduccion al SQL
A bag of Scripts
Scripts
Installing_Oracle8i_Client New Features of Oracle 8i

UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm

9i Specific Docs

New Features of Oracle 9i
Using_Dynamic_SGA
Monitor_Index_Usage
Installing_Oracle9i_Client


UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm

Tuning
Oracle Internal Architecture
Multiple Buffers Pools
Managing the SGA

Performance TUNING (install, tune, analyze, rollback, explain plan, key hints, partitions) Tuning when You Can't Touch the Code (Tune, Raid, etc)
General Tuning Performance Guide Tips to Write effective queries (Rules, Driving Table, Explain Plan, SQL Trace, TKPROF)
Statspack Retrieving the Top-N rows
Analyze_Statspack_Report
Rename or Move Datafiles and Logfiles
Explain Plan (complete doc) Explanation of CBO vs. RBO
New Tablespaces Management options Transportable Tablespaces

 
UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm

Replication 

Replication, Standby and OPS Comparison Replication: Creation in 8i (txt version)
Replication: Basic Concepts Replication: Creation in 8i and Tune (doc version)
Resolving Replication Problems

 
UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm

Standby
Standby DB: Basic Concepts Standby DB: Creation
Events that affect Standby DB Activate Standby DB
Graceful Switchover and Switchback Standby Switchover (español)

  UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm

Backup & Recovery 

Backup And Recovery Information Archivelog Mode Failure Scenarios
Recovery Procedure Implementing Restore and Recovery Strategy
Casos de Backup y Recuperacion
Recovery Manager (RMAN) Manage RMAN Repository

  UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm

Windows Specific Docs
 
Managing Oracle on NT Configuracion RAID
Configuring VLDB (excellent info about RAID) RAID Configuration over NT Servers
RAID Considerations for Oracle NT and Oracle Performance
Oracle on Win2000 for OLTP Tuning Guide Oracle on NT for OLTP Tuning Guide

  UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm

Unix Specific Docs

Unix Administration Commands Summary of useful Unix Commands
Solaris Information Server
HP Information Server
Installing Oracle 9i for SUN
Installing Oracle 8i for SUN
Installing Oracle on Linux
VI Quick Reference
Linux and Oracle Docs

UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm

Assorted Docs 

SQL Loader Type of Indexes
Oracle FAQ's Personal Zip Docs
FAQ's about SQL*Net Net8 Oracle Names Step by Step Configuration
DBMS_Job Intermedia Text
OEM SQL Server and Oracle Comparison 
Tools, Tips and Techniques for DW Rollback Segments
Cloning a Database Parallel Query
Parallel Query Option Temporary Tables
DBMS_Output and UTL_FILE Deadlocks
Audit Options Managing BFILEs
Multi-Threaded Server Overview
Optimal Physical Database Design
Effective Coding Style Profiling in 8i
Oracle Limitations
Oracle Datatypes
Encrypt_Data_and_Code

UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm

 Great Links

Great Tools
  UPDATED VERSION AT :
http://www.pafumi.net/oracle_base.htm