NETCOTECH
 [ OCA 9i ][ OCP 9i ][ OCP 10g ]


ORACLE 9i DBA OCP (Oracle Certified Professional)

Exam #1Z0-032:         DBA Fundamentals II
Exam #1Z0-033:         Performance Tuning

Oracle OCP Course Overview
Our Oracle DBA courses will help you become a seasoned OCP (Oracle Certified Professional). “Oracle Database Administration Courses” includes the coursework for the exams one needs to take for the OCP Certification (Oracle Certified Professional) Database Administrator credential.


OCP Exam #1Z0-032: Oracle 9i: DBA Fundamentals II
Oracle Networking Overview
Basic Oracle Net Architecture
Basic Oracle Net Server-Side Configuration
Basic Oracle Net Services Client-Side Configuration
Usage and Configuration of the Oracle Shared Server
Backup and Recovery Overview
Instance and Media Recovery Structures
Configuring the Database Archiving Mode
User-Managed Backups
RMAN Backups
User-Managed Complete Recovery
RMAN Complete Recovery
User-Managed Incomplete Recovery
RMAN Incomplete Recovery
RMAN Maintenance
Recovery Catalogue Creation and Maintenance
Transporting Data Between Databases
Loading Data into a Database

OCP Exam #1Z0-033: Oracle 9i: Performance Tuning
Overview of Oracle9i Performance Tuning
Diagnostic and Tuning Tools
Sizing the Shared Pool
Sizing the Buffer Cache
Sizing other SGA Structures
Database Configuration and I/O Issues
Optimize Sort Operations
Diagnosing Contention For Latches
Monitoring and Detecting Lock Contention
Tuning Oracle Shared Server
Application Tuning
Using Oracle Blocks Efficiently
SQL Statement Tuning
Tuning the Operating System and Using Resource Manager

OCP Exam #1Z0-032: Oracle 9i: DBA Fundamentals II

Oracle Networking Overview
Explain solutions included with Oracle9i for managing complex networks
Describe Oracle networking add-on solutions

Basic Oracle Net Architecture
Explain the key components of the Oracle Net layered architecture
Explain Oracle Net Services role in client server connections
Describe how web client connections are established through Oracle networking products

Basic Oracle Net Server-Side Configuration
Identify how the listener responds to incoming connections
Configure the listener using Oracle Net Manager
Control the listener using the Listener Control Utility (lsnrctl)
Describe Dynamic Service Registration
Configure the listener for IIOP and HTTP connections for Oracle database server

Basic Oracle Net Services Client-Side Configuration
Describe the difference between host naming and local service name resolution
Use Oracle Net Configuration Assistant to configure: Host Naming, Local naming method, Net service names
Perform simple connection troubleshooting

Usage and Configuration of the Oracle Shared Server
Identify the components of the Oracle Shared Server
Describe the Oracle Shared Server architecture
Configure the Oracle Shared Server
Identify and explain usefulness of related dictionary views

Backup and Recovery Overview
Describe the basics of database backup, restore and recovery
List the types of failure that may occur in an Oracle environment
Define a backup and recovery strategy

Instance and Media Recovery Structures
Describe the Oracle processes, memory structures, and files relating to recovery
Identify the importance of checkpoints, redo log files, and archived log files
Describe ways to tune instance recovery

Configuring the Database Archiving Mode Mode
Describe the differences between Archivelog and Noarchivelog modes
Configure a database for Archivelog mode
Enable automatic archiving
Perform manual archiving of logs
Configure multiple archive processes
Configure multiple destinations, including remote destinations

User-Managed Backups
Describe user-managed backup and recovery operations
Discuss backup issues associated with read tablespaces
Perform closed database backups
Perform open database backups
Back up the control file
Perform cleanup after a failed online backup
Use the DBVERIFY utility to detect corruption

RMAN Backups
Identify types of RMAN specific backups
Use the RMAN BACKUP command to create sets
Back up the control file
Back up the archived redo log files
Use the RMAN COPY command to create image copies

User-Managed Complete Recovery
Describe media recovery
Perform recovery in Noarchivelog mode
Perform complete recovery in Archivelog mode
Restore datafiles to different locations
Relocate and recover a tablespace by using archived redo log files
Describe read-only tablespace recovery

RMAN Complete Recovery
Describe the use of RMAN for restoration and recovery
Perform recovery in Noarchivelog mode
Perform complete recovery in Archivelog mode
Restore datafiles to different locations
Relocate and recover a tablespace by using archived redo log files

User-Managed Incomplete Recovery
Describe the steps of incomplete recovery
perform an incomplete database recovery
Identify the loss of current online redo log files

RMAN Incomplete Recovery
Perform an incomplete database recovery using UNTIL TIME
Perform an incomplete database recovery using UNTIL SEQUENCE

RMAN Maintenance
Perform cross checking of backups and copies
Update the repository when backups have been deleted
Change the availability status of backups and copies
Make a backup or copy exempt from the retention policy
Catalog backups made with operating system commands

Recovery Catalog Creation and Maintenance
Describe the contents of the recovery catalog
Create the recovery catalog
Maintain the recovery catalog by using RMAN commands
Use RMAN to register, resynchronize, and reset a database
Query the recovery catalog to generate reports and lists
Create, store, and run scripts
Describe methods for backing up and recovering the recovery catalog

Transporting Data Between Databases
Describe the uses of the Export and Import utilities
Describe Export and Import concepts and structures
Perform simple Export and Import operations
List guidelines for using Export and Import

Loading Data into a Database
Demonstrate usage of direct- load insert operations
Describe the usage of SQL*Loader
Perform basic SQL*Loader operations
List guidelines for using SQL*Loader and direct-load insert

OCP Exam #1Z0-033: Oracle 9i: Performance Tuning

Overview of Oracle9i Performance Tuning
Describe the roles associated with the database tuning process
Describe the dependency between tuning in different development phases
Describe service level agreements
Describe appropriate tuning goals
Describe the most common tuning problems
Describe the tuning considerations during development and production
Describe performance and safety tradeoffs

Diagnostic and Tuning Tools
Explain how the alert. log file is used
Explain how background trace files are used
Explain how user trace files are used
Describe the statistics kept in the dynamic performance views
Explain how Stats Pack collects statistics
Collect statistics using Stats Pack
Collect statistics using Enterprise Manager
Use other tuning tools

Sizing the Shared Pool
Measure and tune the library cache hit ratio
Measure and tune the dictionary cache hit ratio
Size and pin objects in the shared pool
Tune the shared pool reserve space
Describe the UGA and session memory considerations
Explain other tuning issues related to the shared pool
Set the large pool

Sizing the Buffer Cache
Describe how the buffer cache is used by different Oracle processes
Describe the tuning issues related to the buffer cache
Monitor the use of the buffer cache, also the different pools within the buffer cache
Implement dynamic SGA allocation
Set the DB_CACHE_ADVICE parameter
Create and size multiple buffer pools
Detect and resolve free list contention

Sizing other SGA Structures
Monitor and size the redo log buffer, Monitor and size the java pool
Control the amount of Java session memory used by a session
Configure the instance to use I/O Slaves, Configure and use multiple DBW processors

Database Configuration and I/O Issues
Explain the advantages of distributing different Oracle file types
Describe reasons for partitioning data in tablespaces
Diagnose table space usage problems, Describe how checkpoints work
Monitor and tune checkpoints, Monitor and tune redo logs

Optimize Sort Operations
Describe how sorts are performed, Identify the SQL operations which require sorts
Differentiate between disk and memory sorts
Create and monitor temp tablespaces, reduce total sorts & disk sorts
Determine the number of sorts performed in memory
set old and new sort parameters

Diagnosing Contention For Latches
Describe the purpose of latches, Describe the different types of latched request
Diagnose contention for latches, Tune the appropriate resources to minimize latch contention

Monitoring and Detecting Lock Contention
Define levels of locking, Describe possible causes of contention
Use Oracle utilities to detect lock contention, Resolve contention in an emergency
Prevent locking problems, Recognize Oracle errors arising from deadlocks

Tuning Oracle Shared Server
Identify issues associated with managing users in a Shared Server environment
Diagnose and resolve performance issues with Oracle Shared Server processes
Configure the Oracle Shared Server environment to optimize performance

Application Tuning
Describe the role of the DBA in tuning Applications
Explain different storage structures, and why one storage structure may be preferred over another
Explain the different types of indexes, Explain Index Organized Tables
Describe partitioning methods, Explain the use of the DBMS_STATS procedure
Describe Materialized Views and use of Query Rewrites
List requirements for OLTP, DSS and Hybrid Systems

Using Oracle Blocks Efficiently
Describe the correct usage of extents and Oracle blocks
Explain space usage and the high water mark
Determine the high water mark, Describe the use of Oracle Block parameters
Recover space from sparsely populated segments
Describe and detect chaining and migration of Oracle blocks
Perform index reorganization, Monitor indexes to determine usage

SQL Statement Tuning
Describe how the Optimizer is used, Explain the concept of plan stability
Use stored outlines, Describe how hints are used
Use SQL Trace and TKPROF, Collect statistics on indexes and tables
Describe the use of histograms, Copy statistics between databases

Tuning the Operating System and Using Resource Manager
Describe different system architectures, Describe the primary steps of OS tuning
Identify similarities between OS and DB tuning, Understand virtual memory and paging
Explain the difference between a process and a thread
Set up Database Resource Manager, Assign users to Resources Manager groups
Create resource plans within groups