| |
Oracle10g Database Administration
OCA Preparation Class
A five-day on-site Oracle Certified Associate OCA Training
Course
Test 1Z1-042
© 2007-2009 by Burleson Consulting
* Learn Oracle DBA Concepts.
* Understand Concurrency Management.
* Employ DBA Management.
* Use Oracle Performance Tuning.
* See Oracle security and user management.
|
|
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 hands-on 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.
Hands-on
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.
|
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 Consulting instructors offer
decades of real world DBA experience in Oracle features, and they will
share their Oracle secrets in this intense hands-on 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, hands-on 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.
Oracle10g
Database Administration OCA Exam Preparation
Test 1Z1-042
Copyright ©
2007-2009 by Burleson Consulting
Syllabus
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
Tablespaces
Tables and Indexes
Clusters
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
Oracle*Net
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
SQL*Loader
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
Using ARCHIVELOG mode
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
|
