在oracle官网上找到了ocm考试内容，内容太多了，都是要实际操作的，像我不是专职dba的人来说，很难搞，纯粹为了考而试验，感觉有点累，时间长了又忘记了，就先在这里记下考试内容吧。

Exam Topics

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博客

10g OCM Exam