Description
This course is essential for those who wish to administer their databases while taking advantage of advanced features. Among the points covered are: OEM, advanced network configuration, task scheduling, redefinition of online tables, use of alerts and Flashback.
Who is this training for ?
For whom ?Oracle 11g database administrators, application administrators, system administrators and consultants.
Prerequisites
Training objectives
Training program
- Introduction and reminders
- Control files, redo log.
- Transactions.
- Identification of a database.
- Automated installation by response file, application of patches.
- Advanced configuration
- Network.
- Remote listener.
- Connection filtering.
- OEM.
- Architecture.
- Grid Control vs Database Control.
- The repository.
- Administration console and modules.
- Exercise: Configuring the network to to start the database remotely.
- Configuring EM Database Control.
- Task Scheduling
- Using DBMS_JOB.
- Introduction to Oracle Scheduler.
- Definition of jobs.
- Exercise: Schedule a job with Oracle Scheduler.
- Monitoring, advanced maintenance
- Automatic Diagnostic Repository (ADR).
- Alert log.
- Workbench support.
- Set alert thresholds.
- Use alerts.
- Monitoring used space.
- Oracle memory structures.
- Automatic management.
- Database storage structures.
- Flashback techniques: Flashback Transaction, presentation of Flashback Data Archive technology.
- Exercise: Monitor the database and its objects.
- Redefine tables online.
- Use Flashback.
- Resource Manager
- Concepts, configuring Database Resource Manager.
- Create a new resource allocation plan.
- Active session pool.
- Maximum execution time.
- Create groups of resource consumers.
- Exercise: Creating a resource plan with EM.
- Automatic Storage Management (ASM)
- Architecture.
- Features.
- Installing the Grid Infrastructure.
- The Oracle Restart tool.
- Managing an ASM instance.
- ASM disk groups.
- Migrating a database into ASM.
- Exercise: Update in place of Oracle 11g ASM (Grid Infrastructure).
- Database Replay
- System architecture: capture, global load processing, re-execution.
- Production system before modification.
- Use the Capture wizard.
- Table partitioning
- Compression of tables and tablespaces.
- Partitioning by interval, by system, by virtual column and by reference.
- Maintenance of partitioned tables.
- Exercise: Creating and modifying partitioned tables and indexes.