今天我終於收到通過Oracle 11g OCM升級考試的通知
正式晉升為3M大師：9i/10g/11g OCM
考試範圍如下,但是其實並不是每個項目都會考.考試內容相對簡單多了,只要Oracle 10g OCM稍加準備就應該可以順利通過
我個人在第3單元Performance Management遇到一些阻礙,幾乎將所有時間用完
其他單元大約只花費限制時間的2/3就完成所有的項目
Database, RMAN, EM and Network Configuration
[ ] Configure server-side network
[ ] Configure client-side network
[ ] Create and Manage encrypted tablespaces
[ ] Create and Manage a tablespace that uses NFS mounted file system file
[ ] Set up ADR file based repository
[ ] Perform cold database backup
[ ] Manage user accounts and use case sensitive passwords
[ ] Use OPatch to install a patch
[ ] Install and configure EM Agent
[ ] Create Base Recovery Catalog
[ ] Configure RMAN
[ ] Perform multisection backup of a datafile
[ ] Create an Archival Backup
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
[ ] Convert the standby to a snapshot standby
[ ] Configure archivelog deletion policy for the dataguard configuration
Data and Data Warehouse Management
[ ] Troubleshoot fast materialized views to fast refresh and query rewrite
[ ] Add a tablespace by using Transportable Tablespace Feature of Data Pump Import (cross platform transportable tablespace)
[ ] Configure a schema to support a star transformation query
[ ] Configure and use parallel execution for queries
[ ] Use and access SecureFile LOBS
[ ] Create partitioned tables (includes reference and interval partitioning)
[ ] Configure Flashback Data Archive
[ ] Use Oracle Streams to capture and propagate changes in a table
Performance Management
[ ] Set up and configure Resource Manager to control active sessions, number of I/Os, execution time..etc
[ ] Use Result Cache
[ ] Use multi column statistics
[ ] Gather statistics on a specific table without invalidating cursors
[ ] Use partitioned indexes
[ ] Use SQL Tuning Advisor
[ ] Use SQL Access Advisor
[ ] Configure baseline templates
[ ] Use SQL Plan Management feature
[ ] Replay a captured workload
