Oracle Certified Database Administrator (OCDBA) - Oracle Certified Database Associate (OCA)

Back to the Top of this page

Back to the Top of this page

II. Oracle Certified Professional (OCP)

Oracle9i DBA Fundamentals II

This course gives the Oracle database administrator (DBA) a firm foundation in fundamental database administrative tasks. Students learn about transporting for databases and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. In hands-on exercises, students configure network parameters so that database clients and tools can communicate with the Oracle database server. This course also addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios. Students also examine backup methodologies based on business requirements in a mission critical enterprise. Students use multiple strategies and Oracle Recovery Manager to perform backups, and restore and recovery operations.

Course Topics:

Networking Overview Explaining solutions included with Oracle9i for managing complex networks Describing Oracle networking add-on solutions Basic Oracle Net Architecture Explaining the key components of Oracle Net architecture Explaining Oracle Net Services role in client-server connections Describing how web client connections are established through Oracle networking products Basic Oracle Net Services Server-Side Configuration Identifying How the Listener Responds to Incoming Connections Configuring the Listener using Oracle Net Manager Controlling the Oracle Net Listener by Using the Listener Control Utility Describing Dynamic Service Registration Configuring the Listener for IIOP and HTTP Connections Basic Oracle Net Services Client-Side Configuration Describing the Difference Between Host Naming and Local Service Name Resolution Using Oracle Net Configuration Assistant to Configure Host Naming Method, Local Naming Method, and Net Service Names Performing Simple Connection Troubleshooting Usage and Configuration of the Oracle Shared Server Identifying the Components of the Oracle Shared Server Describing the Oracle Shared Server Architecture Configuring Shared Servers by Using Initialization Parameters Configuring Dispatchers by Using Initialization Parameters Identifying Useful Data Dictionary Views Backup and Recovery Overview Describing the Basics of Database Backup, Restore, and Recovery Listing the Types of Failures that May Occur in an Oracle Environment Defining a Backup and Recovery Strategy Instance and Media Recovery Structures Describing the Oracle Processes, Memory Structures, and Files Relating to Recovery Identifying the Importance of Checkpoints, Redo Log Files, and Archived Log Files Describing Ways to Tune Instance Recovery Configuration of the Database Archiving Mode Noarchivelog and Archivelog Mode Configuration Automatic and Manual Archiving of Redo Log Files Multiple Archival Destinations and Processes Oracle Recovery Manager (RMAN) Overview and Configuration Identifying the Features and Components of RMAN Describing the RMAN Repository and Control File Usage Describing Channel Allocation Describing Media Management Library Interface Connecting to Recovery Manager Configuring the RMAN Environment User-Managed Backups Describing User-Managed Backup and Recovery Operations Performing Closed Database Backups Performing Open Database Backups Cleaning Up After a Failed Online Backup Backing Up the Control File Discussing Backup Issues Associated with Read-Only Tablespaces Identifying the Backup Implications of Operations with NOLOGGING Options Using DBVerify to Check for Block Corruption RMAN Backups Identifying RMAN Specific Backups Using the RMAN BACKUP Command to Create Backup Sets Backing Up the Control File Backing Up the Archived Redo Log Files Using the RMAN COPY Command to Create Image Copies User-Managed Complete Recovery Describing Media Recovery Performing Recovery in Noarchivelog Mode Performing Recovery in Archivelog Mode Read-only Tablespace Recovery Relocating and Recovering a Tablespace RMAN Complete Recovery Describing the Use of RMAN for Restoration and Recovery Performing Recovery in Noarchivelog Mode Performing Completing Recovery in Archivelog Mode Restoring Data Files to a Different Location Relocating and Recovering a Tablespace User-Managed Incomplete Recovery Describing the Steps of Incomplete Recovery Identifying the Situations Which Require Incomplete Recovery Performing an Incomplete Recovery Recovering from the Loss of Current Online Redo Logs RMAN Incomplete Recovery Performing Incomplete Recovery Using UNTIL TIME Performing Incomplete Recovery Using UNTIL SEQUENCE RMAN Repository Maintenance Performing Crosschecking of Backups and Copies Updating the Repository When Backups Have Been Deleted Changing the Availability Status of Backups and Copies Making a Backup or Copy Exempt from the Retention Policy Cataloging Backups Made with Operating System Commands RMAN Catalog Creation and Usage Describing the Contents of the Recovery Catalog Listing the RMAN Features Which Require the Recovery Catalog Creating the Recovery Catalog Maintaining the Recovery Catalog by Using RMAN Commands Using RMAN to Register, Resynchronize, and Reset a Database Querying the Recovery Catalog to Generate Reports and Lists Creating, Storing and Executing Scripts Describing Methods for Backing Up and Recovering the Recovery Catalog Transporting Data Between Databases Export Import Guidelines for Using Export and Import

Back to the Top of this page

Oracle9i: Performance Tuning Workshop

This course will introduce participants to the importance of good initial database design, and the method used to tune a production Oracle9i database. The focus is on Database and Instance tuning rather than specific operating system performance issues. Participants will gain practical experience tuning an Oracle database. Using the available Oracle tools, such as Oracle Enterprise Manager (with the Diagnostics and Tuning Packs) participants also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database. The class includes a one-day interactive workshop that provides participants with real-world experience including problem diagnosis and performance enhancement. This course is designed to prepare you for the corresponding Oracle Certified Professional exam: Exam #1Z0-003.

Course Topics:

Overview of Oracle 9i Performance Tuning Job Roles in Tuning Tuning phases Tuning goals and Service Level Agreements Common performance problems Tuning Methodology Diagnostic and Tuning Tools Alert log file Background process trace files User trace files Dictionary views providing statistics Dynamic performance views TIMED_STATISTICS parameter to collect statistics Statistics Package STATSPACK procedures Sizing the Shared Pool Overview of the shared pool Library cache tuning Reuse statements Using Reserved Space Keeping Large Objects Related tuning issues Data Dictionary Cache (DDC) Tuning Sizing the Buffer Cache Overview of tuning the buffer cache Buffer Cache Sizing Parameters in Oracle9i Depreciated Buffer Cache Parameters Buffer Cache Advisory Parameter Dynamically resizing SGA components Granules of Allocation Increase the size of a SGA component Resolving Techniques Sizing other SGA Structures Sizing the redo log buffer Detecting contention Resolving contention Sizing the Java Pool Monitoring Java Pool Memory Sizing the SGA for Java Sizing Java Pool Memory Limiting Java Session Memory Usage Database Configuration and I/O Issues Distributing files across devices Tablespace usage Detecting improper tablespace usage Moving datafiles Oracle File Striping Tuning Full Table Scans Tuning checkpoints Redo log file configuration Optimize Sort Operations What is the sorting process Sort Area Parameters (New & Old) Tuning sort operations (DB Configuration) Tuning Temporary segments Reducing sort operations (application tuning) Identify sort operations Avoiding sort operations Diagnostic Tools Diagnosing Contention For Latches Oracle¿s Implementation of latches Latch request types - willing-to-wait, immediate Reducing Latch Contention Significant Latches Shared Pool and Library Cache Latches Tuning Rollback (or UNDO) Segments Describing Rollback segment usage Usage and configuration Detecting Problems with Rollback Segments Resolving Problems with Rollback Segments Creating Rollback Segments and bringing them online Allocating transactions to a rollback segment Resolving RBS problems Describing System Managed Undo Monitoring and Detecting Lock Contention Concepts of Locking Overview of Locking issues Types of DML locks Levels of locks Types of DDL lock modes Detecting Blocking Locks Monitoring locking activity Deadlocks Tuning Oracle Shared Server Introducing Oracle Shared Server When are Shared Servers required in Oracle9i Monitoring dispatcher processes Monitoring shared server processes Increasing or decreasing the number of Dispatchers Increasing or decreasing the number of Shared Servers Monitoring Process Usage Monitoring Memory Usage Application Tuning Role of the DBA Oracle Data Structures Selecting the physical structure Data storage structures Clusters Indexes B-Tree Compressed Using Oracle Blocks Efficiently Database Storage hierarchy Allocating extents Monitoring Space Usage in Data Segments Recovering space from sparsely populated segments Database Blocks Chaining and migration Detecting row chaining and migration Resolving row chaining and migration SQL Statement Tuning Cost-based, Rule-based Optimiser Modes New Cost Based Optimiser option Plan Stability Plan Equivalence Stored Outlines Creating Stored Outlines Maintaining Stored Outlines Hints Tuning the Operating System and Using Resource Manager System Architecture Virtual and Physical Memory Paging and Swapping Paging and Swapping CPU Tuning Guidelines Process Vs Thread Resource Manager Concepts