Oracle Administration

Course Topics
MODULE 1: Database Administration

Oracle Installation
Database Startup Modes
Database Shutdown Modes
Setting Parameters in the Parameter file
Creating a Database
Creating Data Dictionary Views
Suspending and Quiescing the Database
Parameter file Management
Creating Server Parameter file using Text Parameter file
Managing Server Parameter file
Creating Text Parameter file using Server Parameter file
Tablespace Management
Creating and Managing Dictionary Managed Tablespaces
Creating and Managing Locally Managed Tablespaces
Creating and Managing Default Temporary Tablespaces
Creating Tablespaces with Non Default Block Size
Creating and Maintaining the Data Files
Creating and Maintaining OMF Datafiles
Creating and Maintaining the Control Files
Creating and Maintaining Multiple OMF Control files
Creating and Maintaining the Redo Log Files
Creating and Maintaining Multiple OMF Redolog files
Managing Archived Redo Log Files
Log Miner

MODULE 2: Rollback & Undo Segment Management

Creating Rollback Segments
Managing Rollback Segments
Sizing Rollback Segments
Creating and Managing Undo Tablespaces

MODULE 3: Schema Management

Storage Structures and Relationships
Automatic Segment Space Management
Table Management
Creating and Managing Normal Tables
Sizing Tables
Partitioned Table Management
Creating and Managing Range Partitioned Table
Creating and Managing Hash Partitioned Table
Creating and Managing Composite Partitioned Table
Creating and Managing List Partitioned Table
Creating and Managing Index-Organized Tables
Creating and Managing Clusters Tables
Creating and Managing Temporary Tables
Redefining Tables Online
Flashback Queries
Resumable Operations
Index Management
Creating and Managing B*Tree Indexes
Creating and Managing Bitmap Indexes
Creating and Managing Partition Indexes
Creating and Managing Function Based Indexes
Index Monitoring

MODULE 4: User Management and Security

Creating and Managing Users
Creating and Managing Roles
Creating and Managing Profiles
User Authentication
Passwordfile Management
Database Auditing

MODULE 5: Integrity Constraints

Globalization Parameter
Loading Methods
SQL*Loader
Direct Load

MODULE 6: Oracle Network Administration

Oracle Networking Overview
Oracle Net Stack Communication Architecture
Oracle Net Services Server Side Configuration
Oracle Net Services Client Side Configuration
Usage and Configuration of Oracle Names Method
Usage and Configuration of the Shared Servers
Usage and Configuration of Connection Manager
Troubleshoot the Network Environment
Security in Network Environment

MODULE 7: Backup and Recovery

Backup and Recovery Considerations
Logical Backup using Export Utility
Logical Recovery using Import Utility
Transportable Tablespaces
Physical Backup without Recovery Manager
Cold or Offline Backup
Hot or Online Backup
Types of Failures and Troubleshooting
Physical Recovery without Recovery Manager
Complete Recovery with Archiving
Incomplete Recovery with Archiving

MODULE 8: Oracle Recovery Manager (RMAN)

Oracle Recovery Manager Overview
Creating and Maintaining Recovery Catalog
Recovery Manager Commands
Physical Backup using Oracle
Recovery Manager
Restoring and Recovering using Oracle Recovery Manager

MODULE 9: Oracle Performance Tuning

Database Planning
Oracle Alert Files and Trace Files
Dynamic Performance Views
Oracle Utilities
Tuning Shared Pool
Tuning Database Cache
Tuning Redo Log Buffer
Using the ANALYZE Statement
Using the DBMS_STATS Package
SQL Trace and TKPROF
Using EXPLAIN PLAN
Using Auto trace
Using Oracle Blocks Efficiently
Optimize Sort Operations
Tuning Rollback Segments
Monitoring and Detecting Lock Contention
Contention Issues

Shopping Cart Software

Quick Contact