| 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 |
|
| Add a tablespace by using Transportable Tablespace Feature of Data Pump Import (cross platform transportable tablespace) |
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 |
|
Leave a Reply