OCM (ORACLE 10G)考试范围（摘自oracle官方网站）

取得ocp证书后，再参加2门原厂培训，并通过2天的ocm上机考试，就可以获得ocm证书。

omc考试会设置几个场景，每个场景都有时间限制，而且考试是环环相扣的，如果前面的场景没有做出来会影响后面的考试。曾和通过ocm考试的人聊过，考试题目不难，关键是要熟练，而且心态要好。以下是考试涉及的内容，准备参加考试的同仁们可以按照此提纲进行准备（此内容摘自oracle官方网站）。

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 
[  ] 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 Oracle Clusterware
[  ] 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 preferred 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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10537377/viewspace-614980/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10537377/viewspace-614980/