FirstDBA - Oracle


DBA's quick reference designed to share information to the most popular relational/object database management systems

                Oracle    PostgreSQL    MySQL    SQL Server     DB2     Firebird                                                Home

  •  Documentation: 

               > Oracle New Features: 10g | 11g

               > Oracle Docs: Search | By Example | Library | Index

               > Oracle Database Administrator's Guide: 10g | 11g

               > Oracle Backup/Recovery Basics | Advanced | Reference

               > Oracle Database Performance Tuning Guide

               > Oracle Database Reference | SQL Reference

               > Oracle for DBA newbies Guide

               > Oracle Database Concepts

               > Oracle Data Guard Guide

               > Oracle Streams Concepts | Replication Guides

               > Oracle Spatial Guide

               > Oracle High Availability Overview | Best Practices

               > Oracle Utilities - Data Pump | SQL*Loader | External Tables

               > Oracle Technology Center (OTN) - (free registration)

               > Oracle Support (Metalink)

               > Oracle Enterprise Manager Doc Library

             > Oracle Database Editions - Key Features Comparison

 

               > How to Create a Standby Database Using RMAN (PPT)

             > Creating 10g Physical Standby DB . Switchover / Failover

             > Comparison of 10g Data Pump & 9i Export Parameters

             > Linux/Unix System Paremeters for Oracle 

             > Oracle Database Licensing Info 10g  11g

             > Feature Availability by Edition 10g  11g 

 

  •  Scripts:            

               > View Oracle DBA scripts

  

  •  Perfromance:    

               >  ixora = Unix + Oracle

               >  Monitoring and performance tuning FAQ

  •  Tools:      

               >  Oracle SQL Developer - Download (free)

               >  CASE Studio  -  Download

             >  Toad - Download (freeware edition)

               >  Oracle 10g Data Dictionay Flash - Download

               >  iSQL-Viewer - Open-source SQL tool (Oracle,Postgres,MySQL)

 

  •  Advanced Topics:

               >  Oracle Data Guard  - High Availability & Falirover

               >  Oracle RAC            - High Scalability & Availability 

               >  Oracle Streams      - Data sharing and replication

 

  •  Certification:

               >  Oracle Certified Professional OCP

 

  •  Training:

               >  Oracle University

             >  Free 10g Express Edition for self-training (light version)

 

  •  Useful Links:

             Oracle E-Delivery - Alternative site to products download

               >  DBA Support.com

               >  Oracle dbazine.com

               >  Oracle FAQ (Frequently Asked Questions)

             >  Oracle DBA Tips

               >  Oracle Code Tips - Oracle Magazine

               >  Oracle-BASE

               >  OakTable Network

               >  SearchOracle.com

               >  Hotsos Articles Library

               >  Akadia - Oracle Articles 

               >  PSOUG Library - quick and brief 

               >  OraclePower Library

               >  Oracle Pipeline (Quest)

 

               >  Ask Tom - Tom Kyte

               >  Jonathan Lewis pages

               >  Ixora = Unix + Oracle (Steve Adams)

               >  Mark Rittman - BI & Warehousing

               >  Pete Finnigan - Oracle Security | Scripts               

               >  Julian Dyke - Oracle Internals

               >  Connar McDonald - OracleDBA

             

               >  Independent Oracle User Group (IOUG)

               >  Nothern California Oracle Users Group (NoCOUG)

               >  Puget Sound Oracle Users Group (psoug Library)

 

               >  The Linux Tutorial

               >  The Linux Kernel - How To

               >  The Linux Kernel Archives - Kernel Donwloads

               >  Red Hat Enterprise Linux Documentation

               >  Red Hat Fedora Core Project

               >  Puschitz - Oracle/Linux