Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Oracle10g Database Administration OCA Preparation Class

A five-day on-site Oracle Certified Associate OCA Training Course
Test 1Z1-042

© 2007-2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices



Key Features

* Learn Oracle DBA Concepts.

* Understand Concurrency Management.

* Employ DBA Management.

* Use Oracle Performance Tuning.

* See Oracle security and user management.



Course Description

The primary goal is this course is to prepare the students to pass the Oracle10g OCA Database Administration exam 1, a prerequisite for exam 2, test 1Z1-043 for the Oracle10g OCP.  This Oracle10g OCP 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 OCA exam, and tips and techniques for passing the Oracle10g OCA exam.

This course covers all of the Oracle10g Database Administration topics on the OCP 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 OCP exam.  In addition, this course provides sample OCP exam questions and an opportunity to access your overall knowledge of Oracle DBA concepts.


This Oracle OCA DBA exam review training is designed for the practicing Oracle professional but it is useful to anyone interested in learning Oracle 10g database administration.  This includes Oracle developers, Oracle DBAs, Oracle web developers and any computer professional who needs to understand the architecture of an Oracle database.  The course assumes a basic knowledge of computer programming techniques, relational database concepts, SQL, and basic Oracle architecture.

Curriculum Design

This Oracle OCA training was designed by Donald K. Burleson.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning. Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle tuning training.

Learning Objectives:

The primary objective of this Oracle10g OCA training is to provide each student with the knowledge and testing secrets for passing the Oracle10g OCA exam.  The student will gain confidence in their Oracle DBA knowledge and learn the tricks and traps of the Oracle10g OCA DBA exam.

Using a proven training combination of intense instruction, practicum and numerous Oracle10g OCA 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 10g Certified Professional
Oracle10g Database Administration OCA Exam Preparation

Test 1Z1-042
Copyright © 2007-2016 by Burleson Corporation


Day 1: Oracle DBA Concepts
Oracle10g Instance creation and management
What is an Oracle Instance?
Installing Oracle
Oracle Optimal Flexible Architecture (OFA)
Locating initialization, listener.ora & sqlnet.ora files
Finding the alert log
Common environment variables
Structures in an Oracle Instance
            Oracle Memory Structures, SGA and PGA
            Oracle Processes and their purposes
Startup nomount, mount and open database commands
Sample Oracle10g OCP exam questions
Oracle10g Database Architecture
Oraclde10g management framework
Using the Database Creation Assistant (DBA)
Creating and dropping a database
Tables and Indexes
Partitioning of Tables and Indexes
Gathering and applying patches
Sample Oracle10g OCP exam questions
Day 2:
Concurrency Management
Transactions, serialization, locks and latches
Lock modes
Detecting and resolving lock conflicts
Managing deadlocks
Interfacing with Oracle
Oracle transaction management
Using SQL*Plus and iSQL*Plus
Using embedded Oracle with Pro*C & Java
PL/SQL & Triggers
Pining PL/SQL packages & compiling PL/SQL
System-level triggers – startup trigger, logon trigger, PL/SQL error trigger
Basic Network structure
Oracle*Net Files
Multi-threaded server
Create additional listeners
Create Oracle Net service aliases
Configure connect time failover
Use ping and tnsping
Oracle*Net names resolution
Sample Oracle10g OCP exam questions
Day 3: DBA Management
Tablespace Management Overview
Dictionary Managed Tablespaces
Locally Managed Tablespaces
Automatic Segment Space Management
Moving tablespaces online and offline
Sample Oracle10g OCP exam questions
UNDO Tablespace Management
Use of undo segments
Creating an undo tablespace
User managed undo tablespaces
Automatic undo management
Monitor & Configure undo retention
Use the Undo Advisor
Size the undo tablespace
Sample Oracle10g OCP exam questions
Oracle Utilities
Datapump - Import/export
Oracle streams
Day 4: Oracle Performance Tuning
Oracle Performance Tuning
Locate invalid and unusable objects
Gather SQL optimizer statistics with dbms_stats
Basic Oracle performance metrics
Use OEM and dbms_alert to set warning and critical alert thresholds
The SQL Tuning Advisor
The SQL Access Advisor
Interpreting server generated alerts
Oracle advisory utilities v$db_cache_advice, v$shared_pool_advice, v$pga_aggregate_target_advice
Using OEM performance screens
Fixing performance issues
Day 5: Oracle security and user management
User Management
Creating Users
Altering users
User Profiles
User resource groups
Granting privileges & roles
Auditing user activity with dbms_audit
Sample Oracle10g OCP exam questions
Oracle Security
Password use in Oracle
Password encryption and password aging
External authentication
Using Single sign-on (SSO)
Object security
Virtual Private Databases (VPD) in Oracle
Oracle “grant execute” security
Use of Roles in Oracle
Register for security updates
Sample Oracle10g OCP exam questions
Backup & Recovery
Oracle backup & recovery planning
Parallel instance recovery
Basics of checkpoints, redo log files, and archived log files
Creating consistent Oracle backups
Online hot backups
Incremental Oracle backups
Automating database backups with dbms_scheduler
Monitor the flash recovery area
Recovering from loss of a Control file
Recovering from loss of a Redo log file
Recovering from loss of a system-critical data file
Recovering from loss of a non system-critical data file
OCP Final Exam Review
Full sample OCP DBA exam
OCP testing techniques for success
Testing tips and secrets


Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.