10g OCM Exam

在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博客 ” ，链接：http://blog.itpub.net/165278/viewspace-462987/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/165278/viewspace-462987/