Putting America Back to Work, through advance industry specific education, providing the tools necessary to
hold the knowledge force in America, is our mission.

RAC

• Introduction to cluster technology
• Introduction to RAC
• High-performance and high-availability database
• Database clusters
• Oracle Real Application Clusters
• Architecture and components
• RAC and disk technology
• RAC installation and internals
• Installation and configuration
• Internals of Real Application Clusters
• Oracle Real Application Clusters
• RAC administration
• Backup and recovery
• Failover with TAF
• Performance tuning and parallel execution
• Performance monitoring and tuning
• Parallel execution
• RAC design and deployment
• RAC design considerations
• RAC performance tuning, design and deployment
• Application deployment
• Migration to RAC
• RAC Cluster Guard
• Using RAC Cluster Guard
• RAC troubleshooting
• Troubleshooting installation issues
• Troubleshooting cluster issues
• Troubleshooting high-speed interconnects
• Oracle 10g RAC new features
• New installation features
• New management features
• Oracle automated disk management and cluster-ready services

Advance RMAN

• RMAN duplication
• Hot Cloning

Dumps

• SCN Dump
• File Header Dump
• Dump redo log headers
• System state dump
• Process state dump
• Library Cache Dump
• Hanganalyze

SQL / PLSQL / Object Enhancements

• ANSI/ISO SQL Support In Oracle9i
• Joins
• CASE Statements
• NULLIF Function
• COALESCE Function
• Scalar Subqueries
• Explicit Defaults
• Automatic Segment Free Space Management
• Automatic Undo Management
• Undo Tablespace Creation
• Enabling Automatic Undo Management
• Maintenance
• Monitoring
• Bitmap Join Indexes
• How It Works
• Creation
• Restrictions

Advance Data Guard

• Data Guard
• Architecture
• Database Synchronization Options
• Setup No-Data-Divergence
• Setup Primary Database
• Setup Standby Database
• Start Managed Standby Recovery
• Protect Primary Database
• Cancel Managed Standby Recovery
• Activating A Standby Database
• Backup Standby Database
• Database Switchover
• Database Failover
• Automatic Archive Gap Detection
• Background Managed Recovery
• Delayed Redo Application

Flashback

• Export And Import Enhancements In Oracle9i
• FLASHBACK_SCN And FLASHBACK_TIME
• RESUMABLE
• STATISTICS
• TABLESPACES
• TABLES Pattern Matching
• Reduced Character Set Conversions

Online Reorganization

• High Availability Enhancements In Oracle9i
• Online Index Rebuilds
• Online Table Redefinition
• Online Analyze Validate
• Quiesce Database
• Dynamic Initialization Parameters

IOT Enhancements

• Index Organized Table (IOT) Enhancements In Oracle9i
• Logical Rowid
• Bitmap Secondary Indexes
• Additional Enhancements
• Index Skip Scanning
• How It Works
• Advantages

LOB Enhancements

• LOB Enhancements In Oracle9i
• LOB Migration
• SQL And PL/SQL Function Support
• Implicit LOB Conversions
• OCI Support
• Issues

LogMiner Enhancements

• LogMiner Enhancements In Oracle9i
• DDL Statements
• Data Dictionary Access
• DDL Dictionary Tracking
• Dictionary Staleness
• Log Corruption
• Committed Data Only
• Primary Keys
• Restrictions
• Logminer Views & Viewer

Memory Management

• Memory Management In Oracle9i
• Dynamic SGA Parameters
• Automatic SQL Execution Memory Management
• Buffer Cache Advisory
 
Linux And RAC

• Install RED HAT on 2 nodes
• Enable 2 nodes for Firewire
• Explain DAS/NAS/SAN
• Two Node Architecture, Unprotected
• Two Node Architecture, Protected Apps tier and unprotected DB tier
• Two Node Architecture, Protected Apps tier and DB tier
• FAILOVER CLUSTER OFFERINGS
• RAC Architecture
• Failover RAC Architecture
• Real Application Cluster
• RAC Building Blocks
• CLUSTERINTER CONNECT
• INTERCONNECT PRODUCTS
• INTERCONNECT PROTOCOL
• IO CHANNEL HBA Products
• FACRIC SWITCHES
• CLUSTER NODES
• CLUSTER TYPES
• Shared Storage Options
• Decide RAC architecture
• Install oracle provided RPM’s

Partitioning Enhancements

• Partitioning Enhancements In Oracle9i
• List Partitioning
• Maintaining Global Indexes
• Parallel Direct-Load Inserts

Performance Enhancements

• Performance Enhancements In Oracle9i
• New FIRST_ROWS_n Optimization Mode
• Cursor Sharing
• Index Monitoring
• Index Skip Scanning
• System Statistics
• Database Statistics
• Cached Execution Plans
• Persistent Initialization Parameters
• PFILE
• SPFILE
• Database Startup
• Parameter Scope

Recovery Enhancements

• Recovery Enhancements In Oracle9i
• Minimal I/O Recovery
• Fast-Start Time-Based Recovery
• Flash Freeze
• Media Recovery Enhancements

RMAN Enhancement

• Recovery Manager (RMAN) Enhancements In Oracle9i
• Customizable Configuration Parameters
• Backup And Restore Enhancements
• Reliability Enhancements
• General Enhancements

Resource Manager Enhancement

• Resource Manager Enhancements In Oracle9i
• Active Session Pool
• Maximum Estimated Execution Time
• Automatic Consumer Group Switching
• UNDO_POOL
• Resource Plan Directive Interactions
• Modified Views
• Resumable Space Allocation
• Resumable Mode
• Timeout Period
• AFTER SUSPEND Trigger
• Views
• DBMS_RESUMABLE Package
• Restrictions
• Scalable Session Management
• Oracle Shared Server
• Dedicated External Procedure Agents
• Multithreaded Heterogeneous Service (HS) Agent
• OCI Connection Pooling
• Core Library Improvements

Security Enhancements

• Security Enhancements In Oracle9i
• Internal Connections Deprecated
• Secure Application Roles
• Partitioned Fine Grain Access Control
• Global Application Context
• Fine Grained Auditing (FGA)
• Other New Features

Locking Enhancements

• SQL New Features In Oracle9i
• Explicitly Named Indexes On Keys
• Share Locks On Unindexed FKs
• PK Lookup During FK Insertion
• View Constraints
• Function Based Index Enhancements
• MERGE Statement
• Multitable Inserts
• External Tables
• SELECT FOR UPDATE Enhancements

Workspace Management

• Workspace Management In Oracle9i
• What Are Workspaces For?
• WM_ADMIN_ROLE
• Version Enabling A Table
• Workspace Creation
• Export And Import Implications
• Versioning Restrictions
• Security
• Locks
• Advantages

Wait Interface, EVENTS 10046 etc

• Identify waits in oracle server using wait interface
• Setup wait interface scripts and tables
• Locate wait events and categorize them, IO, CPU, NETOWRK etc
• Fix internal wait conditions
• Different wait levels trace
• Various ways to trace
• Reading and loading RAW trace files, various options
• Simulate major events and provide FIX