上海涛德顾问学院

查看: 4276|回复: 0

[Oracle 11g OCM] Oracle 11g OCM考纲

[复制链接]
匿名
匿名  发表于 2014-4-13 15:10:07
Oracle 11g OCM考纲
及全球Oracle OCM考试时间安排可查询Oracle官网

http://education.oracle.com/pls/ ... ms=p_exam_id:11GOCM

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 partitioned 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
回复

使用道具 举报

上海涛德顾问学院 ( 沪ICP备14006824号 )  

GMT+8, 2018-6-20 00:18 , Processed in 0.270116 second(s), 29 queries , Gzip On.

Top Data World

回顶部