OCM考纲

sakko51150

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 a tablespace that uses NFS mounted file system file
  
• 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
  
• Configure the network environment to allow connections to multiple databases
  
• Use configurationless connections
  
• Use OPatch to install a patch
  
• Use Grid Infrastructure to manage oracle databases and other resources
  
• Use Enterprise Manager Configuration Assistant(EMCA) utility
  

Enterprise Manager Grid Control

• Install and Patch 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 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

• Mantain recovery catalogs
  
• Configure Recovery Manager
  
• Use Recovery Manager to perform database backups
  
• Use Recover Manager to perform complete database restore and recovery operations
  
• Configure RMAN
  
• Create different types of RMAN backups to cater for different performance and retention requirements
  
• Set Flashback Database parameters
  
• Configure a Fast Recovery Area
  
• Perform various recovery operations using Flashback technology
  

Data Management

• Manage Materialized Views to improve rewrite and refresh performance
  
• Configure and manage distributed materialized views
  
• Create and Manage encrypted tablespaces
  
• Manage Transport of tablespaces across platforms
  
• Configure a schema to support a star transformation query
  
• Administer external tables
  
• Implement Data Pump export and import jobs for data transfer
  
• Implement Data Pump to and from remote databases
  
• Configure and use parallel execution for queries
  
• Use SQL*Loader
  
• Administer, manage and tune parallel execution
  

Data Warehouse Management

• Administer partitioned tables and indexes using appropriate methods and keys
  
• Perform partition maintenance operations
  
• Maintain indexes on a pa rtitioned table
  
• Implement securefile LOB
  
• Create and manage LOB segments
  
• Implement fine-grained access control
  
• Create and manage contexts
  
• Administer flashback data archive and schema evolution
  

Performance Management

• Administer Resource Manager
  
• Use Result Cache
  
• Use multi column statistics
  
• Gather statistics on a specific table without invalidating cursors
  
• Use partitioned indexes
  
• Administer and tune schema object to support various access methods
  
• Interpret execution plan
  
• Use SQL tuning tools and features
  
• Use SQL Tuning Advisor
  
• Use SQL Access Advisor
  
• Use SQL Performance Analyzer
  
• Configure baseline templates
  
• Use SQL Plan Management feature
  
• Implement instance caging
  

Grid Infrastructure and ASM

• Install Oracle Grid Infrastructure
  
• Create ASM Disk Groups
  
• Create and manage as ASM instance
  
• Implement ASM failure groups
  
• Creating ACFS File System
  
• Start, stop, configure and administer Oracle Grid Infrastructure
  

Real Application Clusters

• Install the Oracle Database 11gR2 software
  
• Configure ASM for the shared disks and create a clustered database
  
• Configure archiving
  
• Configure services using both Manual and Policy Managed methods
  

Data Guard

• Create Physical Standby Database with real-time apply.
  
• Configure the data guard environment to reduce overheads of fast incremental backups on the primary database
  
• Configure the Observer
  
• Switchover and switch back
  
• Configure connect time failover
  
• Convert the standby to a snapshot standby
  
• Configure archivelog deletion policy for the Dataguard configuration来源： <http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:11GOCM>