| |
Oracle Certified
Master (OCM) Preparation Class
A five-day on-site Oracle
Certified Master OCM Training Course
© 2007-2016 by Burleson Corporation
* Learn advanced Oracle
DBA Concepts.
* Get advice from
an OCM curriculum developer.
|
|
The primary
goal is this course is to prepare the students to pass the Oracle
OCM Database Administration practicum. This Oracle OCM course
is an intensive 5-day course is designed to provide Oracle
professionals with an in-depth understanding of the DBA concepts
and knowledge required for the OCM exam, and tips and techniques
for passing the Oracle Certified Masters (OCM)
exam.
This course
covers all of the Oracle10g Database Administration topics on the
OCM exam including SGA instance management, file & tablespace
management, user administration & security and table &
index management.
exercises are used to demonstrate each feature and the student will
gain first-hand experience in the key Oracle DBA concepts required
to pass the Oracle10g OCM exam. In addition, this course
provides sample OCM exam questions and an opportunity to access
your overall knowledge of Oracle DBA concepts.
This Oracle OCM
DBA exam review training is designed for the practicing Oracle
professional but it is useful to anyone interested in learning
Oracle 10g database administration.
|
Learning
Objectives:
The primary
objective of this Oracle OCM training is
to provide each student with the knowledge and testing secrets for
passing the Oracle10g OCM
practicum. The student will gain confidence in their Oracle
DBA knowledge and learn the tricks and traps of the Oracle10g OCM
DBA exam using Red Hat Linux.
Using a proven
training combination of intense instruction, practicum and
numerous Oracle OCM sample exam questions, the student should have
a firm understanding of Oracle10g Database Administration.
The student will successfully install and configure a working
Oracle database, create tablespaces and files, manage security and
user access and learn basic performance tuning.
Oracle Certified
Master OCM Exam Preparation
Copyright
© 2007-2016 by Burleson Corporation
|
Server
Configuration |
| - |
Create
the database |
| - |
Determine
and set sizing parameters for database
structures |
| - |
Create
and manage temporary, permanent, and undo tablespaces
|
| - |
Stripe
data files across multiple physical devices and
locations |
| - |
Configure
the database environment to support optimal data access
performance |
| - |
Create
and manage database configuration files |
| - |
Create
and manage bigfile tablespaces |
| -
|
Create and manage
multiple network configuration files |
| -
|
Create and configure
a listener |
| -
|
Configure the
database instance to support shared server
connections |
| -
|
Set up network
tracing |
| -
|
Manage Oracle network
processes (the Listener Control utility) |
| -
|
Configure the network
environment to allow connections to multiple
databases |
| -
|
Use configurationless
connections |
| Enterprise
Manager Grid Control |
| -
|
Install the
Enterprise Manager Grid Control software |
| -
|
Configure the
Enterprise Manager repository |
| -
|
Create
Enterprise Manager Grid Control users |
| -
|
Use Enterprise
Manager to modify a database configuration |
| -
|
Configure
Enterprise Manager to modify a database availability
|
| -
|
Create and
manage jobs |
| - |
Create and monitor
alerts |
| - |
Create
notifications |
| - |
Implement Grid Control and
Database Control |
| - |
Choose the appropriate
tablespace type for the intended use |
| - |
Create Scheduler
jobs |
| - |
Create
schedules |
| - |
Assign jobs to
windows |
| - |
Create
programs |
| - |
Create job
classes |
| - |
Install the Enterprise
Manager Grid Control infrastructure |
| - |
Deploy Enterprise Manager
Grid Control agents |
| - |
Configure Grid Control for
business requirements |
| Managing Database
Availability |
| -
|
Create a recovery
catalog database |
| -
|
Configure Recovery
Manager |
| -
|
Use Recovery Manager
to perform database backups |
| -
|
Use Recover Manager
to perform complete database restore and recovery
operations |
| -
|
Set Flashback
Database parameters |
| - |
Monitor Flashback Database
logs and statistics |
| - |
Perform a Flashback
Database operation |
| - |
Configure a flash recovery
area |
| Data
Management |
| - |
Implement fine-grained
auditing |
| - |
Create a secure application
role |
| - |
Grant specific privileges
for a Flashback Query |
| - |
Set parameters for
retaining undo |
| - |
Implement fine-grained
access control |
| - |
Create and manage
contexts |
| - |
Use
SQL*Loader |
| - |
Implement transportable
tablespaces between homogeneous and heterogeneous systems (using
different methods of moving files) |
| - |
Choose the appropriate
partition method (range, hash, list, and composite)
|
| - |
Choose the appropriate
partition key |
| - |
Choose appropriate indexing
methods (local, global, prefixed, and nonprefixed)
|
| - |
Perform partition
maintenance operations |
| - |
Maintain indexes on a
partitioned table |
| - |
Create and manage LOB
segments |
| - |
Apply parallelism
appropriately |
| - |
Tune memory for parallel
operations |
| - |
Set parallel
parameters |
| Data Warehouse
Management |
| -
|
Create external
tables (Data Loader and Data Pump drivers) |
| -
|
Implement Data
Pump export and import jobs for data transfer |
| -
|
Implement Data
Pump to and from remote databases |
| -
|
Implement
Replication/Streams |
| -
|
Configure and
manage master replication |
| - |
Configure and manage
distributed materialized views |
| - |
Configure
and manage Streams for replication
|
Performance Management |
| - |
Install
Statspack |
| - |
Adjust
the default interval for statistics collection |
| - |
Customize
the events that are monitored |
| - |
Use ADDM
to analyze statistics and to identify performance bottlenecks and
fix them |
| - |
Implement
automatic shared memory management |
| - |
Tune memory using manual
memory management |
| - |
Monitor and tune SGA areas
that are not automatically tuned |
| - |
Implement automatic SQL
execution memory management |
| - |
Tune the PGA using work
area size parameters |
| - |
Use the PGA
Advisor |
| - |
Create a Database Resource
Manager plan with directives (active session count, max execution
time) |
| - |
Create consumer
groups |
| - |
Configure consumer group
mappings |
| - |
Manage Services (Oracle
Database 10g Release 2) |
| - |
Create and manage objects
to accommodate different data access methods (schema
tuning) |
| - |
Use the SQL Tuning
Advisor |
| - |
Use the SQL Access
Advisor |
| - |
Gather Optimizer
statistics |
| - |
Interpret execution
plan |
| - |
Use SQL tuning tools and
features |
| Real Application Clusters |
|
- |
Install Cluster
Ready Services |
|
- |
Install the
Oracle Database 10g software |
|
- |
Implement ASM
failure groups |
|
- |
Create and
manage as ASM instance |
| - |
Create and manage ASM disk
groups |
| - |
Configure ASM for the
shared disks, and create a clustered database |
| - |
Configure
archiving |
| - |
Configure Services with a
primary instance and an available instance |
| Data Guard |
|
- |
Use Data Guard
Manager and DGMGRL |
|
- |
Create and
utilize a physical standby database |
|
- |
Create and
utilize a logical standby database |
|
- |
Set up log
transport services for various levels or
protection |
| - |
Configure the network
environment to allow communication between the standby database and
the primary database |
| - |
Open the physical standby
database in a "ready-only" state |
| - |
Perform a switchover
operation and a failover operation |
| - |
Implement Data
Guard |
|
|
Note that our Oracle OCM training is completely independent from
Oracle Corporation and Oracle University, but designed and taught
by an Oracle Certified Master.
|
|
