Oracle Database 11g: Oracle Certified Master Upgrade (OCM) NEW

Total time

Oracle Database 11g: Oracle Certified Master Upgrade (OCM) NEW

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

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…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle 11G, Oracle 10G, Oracle, CompTIA A+ / Network+ / Security+, and IT Security.

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
Data Guard
  • 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
Data and Data Warehouse Management
  • 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
Performance Management
  • 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

There are no reviews yet.

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.