Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

   

Oracle Certified Master (OCM) Preparation Class

A five-day on-site Oracle Certified Master OCM Training Course
© 2007-2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices


 
Key Features

* Learn advanced Oracle DBA Concepts.

* Get advice from an OCM curriculum developer.

  

Course Description

The primary goal is this course is to prepare the students to pass the Oracle OCM Database Administration practicum.  This Oracle OCM course is an intensive 5-day course is designed to provide Oracle professionals with an in-depth understanding of the DBA concepts and knowledge required for the OCM exam, and tips and techniques for passing the Oracle Certified Masters (OCM) exam.

This course covers all of the Oracle10g Database Administration topics on the OCM exam including SGA instance management, file & tablespace management, user administration & security and table & index management.

exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle10g OCM exam.  In addition, this course provides sample OCM exam questions and an opportunity to access your overall knowledge of Oracle DBA concepts.

Audience

This Oracle OCM DBA exam review training is designed for the practicing Oracle professional but it is useful to anyone interested in learning Oracle 10g database administration. 

Learning Objectives:

The primary objective of this Oracle OCM training is to provide each student with the knowledge and testing secrets for passing the Oracle10g OCM practicum.  The student will gain confidence in their Oracle DBA knowledge and learn the tricks and traps of the Oracle10g OCM DBA exam using Red Hat Linux.

Using a proven training combination of intense instruction, practicum and numerous Oracle OCM sample exam questions, the student should have a firm understanding of Oracle10g Database Administration.  The student will successfully install and configure a working Oracle database, create tablespaces and files, manage security and user access and learn basic performance tuning.



Oracle 10g Certified Professional
Oracle Certified Master OCM Exam Preparation

 Copyright © 2007-2016 by Burleson Corporation
 
 
Server Configuration
 - Create the database
 - Determine and set sizing parameters for database structures
 - Create and manage temporary, permanent, and undo tablespaces
 - Stripe data files across multiple physical devices and locations
 - Configure the database environment to support optimal data access performance
 - Create and manage database configuration files
 - Create and manage bigfile tablespaces
 - Create and manage multiple network configuration files
 - Create and configure a listener
 - Configure the database instance to support shared server connections
 - Set up network tracing
 - Manage Oracle network processes (the Listener Control utility)
 - Configure the network environment to allow connections to multiple databases
 - Use configurationless connections

 
Enterprise Manager Grid Control
 - Install the Enterprise Manager Grid Control software
 - Configure the Enterprise Manager repository
 - Create Enterprise Manager Grid Control users
 - Use Enterprise Manager to modify a database configuration
 - Configure Enterprise Manager to modify a database availability
 - Create and manage jobs
 - Create and monitor alerts
 - Create notifications
 - Implement Grid Control and Database Control
 - Choose the appropriate tablespace type for the intended use
 - Create Scheduler jobs
 - Create schedules
 - Assign jobs to windows
 - Create programs
 - Create job classes
 - Install the Enterprise Manager Grid Control infrastructure
 - Deploy Enterprise Manager Grid Control agents
 - Configure Grid Control for business requirements
 
Managing Database Availability
 - Create a recovery catalog database
 - Configure Recovery Manager
 - Use Recovery Manager to perform database backups
 - Use Recover Manager to perform complete database restore and recovery operations
 - Set Flashback Database parameters
 - Monitor Flashback Database logs and statistics
 - Perform a Flashback Database operation
 - Configure a flash recovery area

 

Data Management
 - Implement fine-grained auditing
 - Create a secure application role
 - Grant specific privileges for a Flashback Query
 - Set parameters for retaining undo
 - Implement fine-grained access control
 - Create and manage contexts
 - Use SQL*Loader
 - Implement transportable tablespaces between homogeneous and heterogeneous systems (using different methods of moving files)
 - Choose the appropriate partition method (range, hash, list, and composite)
 - Choose the appropriate partition key
 - Choose appropriate indexing methods (local, global, prefixed, and nonprefixed)
 - Perform partition maintenance operations
 - Maintain indexes on a partitioned table
 - Create and manage LOB segments
 - Apply parallelism appropriately
 - Tune memory for parallel operations
 - Set parallel parameters

 

Data Warehouse Management
 - Create external tables (Data Loader and Data Pump drivers)
 - Implement Data Pump export and import jobs for data transfer
 - Implement Data Pump to and from remote databases
 - Implement Replication/Streams
 - Configure and manage master replication
 - Configure and manage distributed materialized views
 -
Configure and manage Streams for replication
 
Performance Management
 - Install Statspack
 - Adjust the default interval for statistics collection
 - Customize the events that are monitored
 - Use ADDM to analyze statistics and to identify performance bottlenecks and fix them
 - Implement automatic shared memory management
 - Tune memory using manual memory management
 - Monitor and tune SGA areas that are not automatically tuned
 - Implement automatic SQL execution memory management
 - Tune the PGA using work area size parameters
 - Use the PGA Advisor
 - Create a Database Resource Manager plan with directives (active session count, max execution time)
 - Create consumer groups
 - Configure consumer group mappings
 - Manage Services (Oracle Database 10g Release 2)
 - Create and manage objects to accommodate different data access methods (schema tuning)
 - Use the SQL Tuning Advisor
 - Use the SQL Access Advisor
 - Gather Optimizer statistics
 - Interpret execution plan
 - Use SQL tuning tools and features

 

Real Application Clusters
 - Install Cluster Ready Services
 - Install the Oracle Database 10g software
 - Implement ASM failure groups
 - Create and manage as ASM instance
 - Create and manage ASM disk groups
 - Configure ASM for the shared disks, and create a clustered database
 - Configure archiving
 - Configure Services with a primary instance and an available instance

 

Data Guard
 - Use Data Guard Manager and DGMGRL
 - Create and utilize a physical standby database
 - Create and utilize a logical standby database
 - Set up log transport services for various levels or protection
 - Configure the network environment to allow communication between the standby database and the primary database
 - Open the physical standby database in a "ready-only" state
 - Perform a switchover operation and a failover operation
 - Implement Data Guard

Note that our Oracle OCM training is completely independent from Oracle Corporation and Oracle University, but designed and taught by an Oracle Certified Master.

 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.