|
Database, RMAN, EM and Network Configuration
|
|
Configure server-side network
|
4
|
|
|
Configure client-side network
|
4
|
|
|
Create and Manage encrypted tablespaces
|
4
|
|
|
Create and Manage a tablespace that uses NFS mounted file system file
|
4
|
14 Set Up DirectNFS for Example Database
|
|
Set up ADR file based repository
|
4
|
|
|
Perform cold database backup
|
5
|
|
|
Manage user accounts and use case sensitive passwords
|
4
|
11G OCM Case Sensitive Passwords
|
|
Use OPatch to install a patch
|
4
|
11G OCM OPatch 11.1.0.7 on GRIDCTRL
|
|
Install and configure EM Agent
|
4
|
02 Deploy EM Agent on BANKSTOWN
03 Upgrade to EM Agent 10.2.0.5.0
15 Deploy EM Agent on PENRITH Cluster
|
|
Create Base Recovery Catalog
|
5
|
|
|
Configure RMAN
|
4
|
|
|
Perform multisection backup of a datafile
|
4
|
|
|
Create an Archival Backup
|
4
|
|
|
Data Guard
|
|
Create Physical Standby Database with real-time apply.
|
3
|
|
|
Configure the data guard environment to reduce overheads of fast incremental backups on the primary database
|
4
|
|
|
Configure the Observer
|
1
|
|
|
Switchover and switch back
|
3
|
|
|
Convert the standby to a snapshot standby
|
1
|
|
|
Configure archivelog deletion policy for the dataguard configuration
|
4
|
|
|
Data and Data Warehouse Management
|
|
Troubleshoot fast materialized views to fast refresh and query rewrite
|
1
|
|
|
|
1
|
|
|
Configure a schema to support a star transformation query
|
4
|
|
|
Configure and use parallel execution for queries
|
3
|
|
|
Use and access SecureFile LOBS
|
1
|
|
|
Create partitioned tables (includes reference and interval partitioning)
|
4
|
|
|
Configure Flashback Data Archive
|
4
|
|
|
Use Oracle Streams to capture and propagate changes in a table
|
1
|
|
|
Performance Management
|
|
Set up and configure Resource Manager to control active sessions, number of I/Os, execution time..etc
|
4
|
|
|
Use Result Cache
|
4
|
|
|
Use multi column statistics
|
4
|
|
|
Gather statistics on a specific table without invalidating cursors
|
4
|
|
|
Use partitioned indexes
|
4
|
|
|
Use SQL Tuning Advisor
|
5
|
|
|
Use SQL Access Advisor
|
5
|
|
|
Configure baseline templates
|
4
|
|
|
Use SQL Plan Management feature
|
4
|
|
|
Replay a captured workload
|
4
|
|