Oracle Database 11g: Oracle Certified Master Upgrade (OCM) NEW
Starting dates and places
Description
An Oracle Certified
Master is a top-level Oracle expert who has in depth technical
knowledge of the Oracle data server and industry experience
managing mission critical Oracle database systems and applications.
An OCM is looked upon as an expert within their organization,
amongst their peers and across the industry.
The OCM exam is conducted at designated Oracle University
facilities in each global region.
Prerequisites for Registration
Before registering for the 11g Upgrade OCM, you must do the following:
- Earn your Oracle9i Database or Oracle Database 10g Administrator Certified Master (OCM) credential
- OCM participants complete a series of skill-sets and resolve technical and failure prob…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
An Oracle Certified Master is a top-level Oracle expert who has
in depth technical knowledge of the Oracle data server and industry
experience managing mission critical Oracle database systems and
applications. An OCM is looked upon as an expert within their
organization, amongst their peers and across the industry.
The OCM exam is conducted at designated Oracle University
facilities in each global region.
Prerequisites for Registration
Before registering for the 11g Upgrade OCM, you must do the following:
- Earn your Oracle9i Database or Oracle Database 10g Administrator Certified Master (OCM) credential
- OCM participants complete a series of skill-sets and resolve technical and failure problems within an Oracle 11g environment
- Visit the Oracle Certification Program website to view all the details about the OCM exam, including the minimum recommended skills. http://www.oracle.com/education/certification
- Skill-sets are timed and require a high degree of Oracle database knowledge to successfully complete them
- It is highly recommended that participants have a minimum of 3 – 4 years of Oracle database administrator experience
Oracle Testing ID
You must provide your 9-character Oracle Testing ID to initiate
the OCM exam. The Oracle Testing ID is the unique identifier
associated with your Oracle exam history at Prometric and Pearson
Vue. We strongly recommend that OCM candidates locate their Oracle
Testing ID at least one week prior to their exam date. To set up a
web account with Pearson Vue and confirm an Oracle Testing ID,
visit http://www.pearsonvue.com/oracle
Follow these instructions to obtain your Oracle ID.
Audience
- Technical Consultant
- Database Administrators
Course Topics Database, RMAN, EM and Network Configuration
- Configure server-side network, Configure client-side network
- Create and Manage encrypted tablespaces
- Create and Manage a tablespace that uses NFS mounted file system file
- Set up ADR file based repository, Perform cold database backup
- Manage user accounts and use case sensitive passwords, Use OPatch to install a patch
- Install and configure EM Agent, Create Base Recovery Catalog, Configure RMAN
- Perform multisection backup of a datafile
- Create an Archival Backup
- Create Physical Standby Database with real-time apply
- Configure the data guard environment to reduce overheads of fast incremental backups on the primary database
- Configure the Observer
- Switchover and switch back
- Convert the standby to a snapshot standby
- Configure archivelog deletion policy for the dataguard configuration
- Troubleshoot fast materialized views to fast refresh and query rewrite
- Add a tablespace by using Transportable Tablespace Feature of Data Pump Import (cross platform transportable tablespace)
- Configure a schema to support a star transformation query
- Configure and use parallel execution for queries
- Use and access SecureFile LOBS
- Create partitioned tables (includes reference and interval partitioning)
- Configure Flashback Data Archive
- Use Oracle Streams to capture and propagate changes in a table
- Set up and configure Resource Manager to control active sessions, number of I/Os, execution time..etc
- Use Result Cache, Use multi column statistics
- Gather statistics on a specific table without invalidating cursors
- Use partitioned indexes
- Use SQL Tuning Advisor, Use SQL Access Advisor
- Configure baseline templates
- Use SQL Plan Management feature
- Replay a captured workload
Course Objectives
- To test the participants with a series of skill sets and determine their ability to resolve technical problems within a live Oracle 11g database environment
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.