10G-OCM考试简介--考试环境-考试大纲-考试安排-转自还不算晕的专栏
首先是10G OCM考试环境：数据库：Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 Oracle Enterprise Manager 10g Grid Control Release 10.2.0.1.1
操作系统：oel 5.4
数据库软件及操作系统安装包如需要可以留言。
ORALCE官网关于考试环境要求详见：http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:10GOCM
关于考试的其它要求及建议：http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:10GOCM&p_org_id=&lang=#tabs-1
Notes about the exam注意需要使用命令行完成至少40%，用命令或OEM完成40%，其它工具20%。
[*]Exam participants work through eight skillsets that are based on exam objectives.
[*]Approximately 40% of the tasks must be performed using CLI.
[*]Approximately 40% of the tasks can be performed using either CLI or OEM
[*]The remaining tasks need to be performed using various other tools like Oracle Universal Installer and Database Configuration Assistant.
考试大纲：http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:10GOCM&p_org_id=&lang=#tabs-1
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
考试安排及要求：--来自网络
机器内存大概为4G，大多数都是在奇数机上运行。
1、时间安排
第一天：
section 0:创建一个数据库 45分钟
section 1:数据库和网络配置 120分钟
section 2:Gridcontrol安装配置 120分钟
section 3:数据库备份恢复 60分钟
section 4:数据仓库管理 90分钟
第二天：
section 5:数据库管理 120分钟
section 6:数据库性能管理 120分钟
section 7:部署Oracle RAC数据库 105分钟
sectoin 8:部署Dataguard数据库 60分钟
页:
[1]