10g OCM考试大纲 (英文版)

chenkehao

10g OCM考试大纲

OCM考试一共有9个section，详细的安排如下：
第一天：
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分钟


Oracle 10g OCM 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