ORACLE DATABASE ADMINISTRATOR
The modules describes the Oracle Database
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