Oracle Database 10g: OCM Exam
Preparation
Activity Guide
D70037GC10
Edition 1.0
April 2008
D54401
®
Copyright © 2008, Oracle. All rights reserved.
Disclaimer
This document contains proprietary information and is protected by copyright and other intellectual property laws. You may
copy and print this document solely for your own use in an Oracle training course. The document may not be modified or
altered in any way. Except where your use constitutes "fair use" under copyright law, you may not use, share, download,
upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part
without the express authorization of Oracle.
The information contained in this document is subject to change without notice. If you find any problems in the document,
please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This
document is not warranted to be error-free.
Restricted Rights Notice
If this documentation is delivered to the United States Government or anyone using the documentation on behalf of the
United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS
The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are
restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract.
Trademark Notice
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their
respective owners.
Oracle Database 10g: OCM Exam Preparation – Activity Guide
iii
Contents
Oracle Enterprise Manager 10g Grid Control Ed 2
Practices for Chapter 2: Deploying the Oracle Management Agent ..................................................1
(EM 10g Grid Control Ed 2 - Chapter 4)
Practice Solutions for Chapter 2: Deploying the Oracle Management Agent ....................................5
(EM 10g Grid Control Ed 2 - Chapter 4)
Practices for Chapter 3: Job System..................................................................................................18
(EM 10g Grid Control Ed 2 - Chapter 14)
Practice Solutions for Chapter 3: Job System....................................................................................22
(EM 10g Grid Control Ed 2 - Chapter 14)
Oracle Database 10g: Performance Tuning Ed 1.1
Practices for Chapter 4: Using Statspack...........................................................................................48
(10g Performance Tuning Ed 1.1 - Chapter 5)
Practice Solutions for Chapter 4: Using Statspack.............................................................................52
(10g Performance Tuning Ed 1.1 - Chapter 5)
Practices for Chapter 5: Using Automatic Workload Repository........................................................70
(10g Performance Tuning Ed 1.1 - Chapter 6)
Practice Solutions for Chapter 5: Using Automatic Workload Repository..........................................72
(10g Performance Tuning Ed 1.1 - Chapter 6)
Practices for Chapter 6: Tuning the Shared Pool...............................................................................103
(10g Performance Tuning Ed 1.1 - Chapter 8)
Practice Solutions for Chapter 6: Tuning the Shared Pool.................................................................107
(10g Performance Tuning Ed 1.1 - Chapter 8)
Practices for Chapter 7: Automatic Shared Memory Management....................................................131
(10g Performance Tuning Ed 1.1 - Chapter 10)
Practice Solutions for Chapter 7: Automatic Shared Memory Management......................................134
(10g Performance Tuning Ed 1.1 - Chapter 10)
Practices for Chapter 8: Tuning PGA and Temporary Space ............................................................154
(10g Performance Tuning Ed 1.1 - Chapter 13)
Practice Solutions for Chapter 8: Tuning PGA and Temporary Space ..............................................158
(10g Performance Tuning Ed 1.1 - Chapter 13)
Oracle Database 10g: OCM Exam Preparation – Activity Guide
iv
Oracle Database 10g: SQL Tuning Ed 2
Practices for Chapter 9: Gathering Statistics .....................................................................................178
(10g SQL Tuning Ed 2 - Chapter 7)
Practice Solutions for Chapter 9: Gathering Statistics .......................................................................179
(10g SQL Tuning Ed 2 - Chapter 7)
Oracle Database 10g: RAC for Administrators Ed 2
Practices for Chapter 11: Oracle Clusterware Installation and Configuration....................................185
(10g RAC for Admin Ed 2 - Chapter 1)
Practice Solutions for Chapter 11: Oracle Clusterware Installation and Configuration......................187
(10g RAC for Admin Ed 2 - Chapter 1)
Practices for Chapter 12: RAC Software Installation..........................................................................212
(10g RAC for Admin Ed 2 - Chapter 2)
Practice Solutions for Chapter 12: RAC Software Installation ...........................................................215
(10g RAC for Admin Ed 2 - Chapter 2)
Practices for Chapter 13: RAC Database Creation............................................................................236
(10g RAC for Admin Ed 2 - Chapter 3)
Practice Solutions for Chapter 13: RAC Database Creation..............................................................239
(10g RAC for Admin Ed 2 - Chapter 3)
Practices for Chapter 14: Services.....................................................................................................275
(10g RAC for Admin Ed 2 - Chapter 7)
Practice Solutions for Chapter 14: Services.......................................................................................279
(10g RAC for Admin Ed 2 - Chapter 7)
Oracle Database 10g: Data Guard Administration Ed 2
Practices for Chapter 15: Creating a Configuration and Physical Standby Database .......................339
(10g Data Guard Admin Ed 2 - Chapter 4)
Practices for Chapter 16: Configuring Data Protection Modes and Redo Transport Services ..........342
(10g Data Guard Admin Ed 2 - Chapter 6)
Practices for Chapter 17: Creating a Logical Standby Database by Using Enterprise Manager.......343
(10g Data Guard Admin Ed 2 - Chapter 7)
Practices for Chapter 18: Performing Switchover and Failover .........................................................345
(10g Data Guard Admin Ed 2 - Chapter 9)
Oracle Database 10g: Security Ed 2
Practices for Chapter 20: Using Application Contexts........................................................................347
(10g Security Ed 2 - Chapter 11)
Oracle Database 10g: OCM Exam Preparation – Activity Guide
v
Practice Solutions for Chapter 20: Using Application Contexts .........................................................350
(10g Security Ed 2 - Chapter 11)
Practices for Chapter 21: Implementing Fine-Grained Access Control..............................................358
(10g Security Ed 2 - Chapter 12)
Practice Solutions for Chapter 21: Implementing Fine-Grained Access Control ...............................360
(10g Security Ed 2 - Chapter 12)
Oracle Database 10g: Implement and Administer a Data Warehouse
Practices for Chapter 22: Parallel Operations in Data Warehouses ..................................................365
(10g Implement and Administer a Data Warehouse - Chapter 8)
Practice Solutions for Chapter 22: Parallel Operations in Data Warehouses ....................................368
(10g Implement and Administer a Data Warehouse - Chapter 8)
Oracle Database 10g: Develop PL/SQL Program Units Ed 2
Practices for Chapter 23: Manipulating Large Objects.......................................................................378
(10g Develop PL/SQL Program Units Ed 2 - Chapter 9)
Practice Solutions for Chapter 23: Manipulating Large Objects.........................................................379
(10g Develop PL/SQL Program Units Ed 2 - Chapter 9)