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

ADVICE FROM SENIOR OU INSTRUCTORS:

• Obtain a minimum of 3 - 4 years of Oracle experience. Five or more years experience would be more typical of the qualified candidate.
• Make sure you have all the skills described under Recommeded Minimum Skills and Experience.
• Be prepared to use the non-searchable documentation during the exam, to help you with correct syntax.
• Review command line solutions and be prepared to use them, even if you know how to do things in GUI. GUI is not available for every segment of the exam.
• Take the time to get hands-on practice with all the exam objectives, especially on skills that you do not use regularly.
• You must be able to translate high-level conceptual requirements into the specific commands and actions that are needed to execute them. This is where your years of experience and hands-on practice are especially vital to success on the exam.

RECOMMENDED MINIMUM SKILLS AND EXPERIENCE:

• 3-4 years of professional enterprise-level Oracle experience
• Extensive experience with backup, restore and recovery operations
• Proficient with SQL
• Working knowledge of LINUX command language that includes:
• Formatting and executing basic OS commands
• Creating and navigating through directory structures
• File management using copy, move, and delete
• Linux environment text editors
• Setting environment variables
• The ability to locate and launch Oracle executables that include: 
• RMAN utility
• Oracle Net Manager
• Oracle Net Configuration Assistant
• OEM
• Listener Utility
• OMS
• Oracle Password Utility
• Database Creation Assistant
• DGMGRL (for 11g OCM)
• Proficient with Oracle Enterprise Manager
• Proficient in using Oracle Net Manager and the Oracle Net Configuration Assistant to configure networking
• Advanced knowledge and use of Oracle Enterprise Server technology and features
• Familiarity navigating through online Oracle documentation
• Proficient with using Mozilla 1.6 browser software