Exam 1Z0-053: Oracle Database 11g: Administration II Curriculum Outline

Oracle Database 11g: Database Architecture and ASM

Overview/Description
To recognize the structural elements in Oracle Database 11gs architecture, including and Automatic Storage Management (ASM), and recognize the steps for managing storage using disk groups.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration

1.50 Hours

Objectives :

Oracle Database 11g: Database Architecture and ASM

identify the characteristics of elements of the Oracle Database 11g architecture.

recognize the steps for managing database files using Automatic Storage Management (ASM) and disk groups.

identify ways to manage disk groups and their attributes and also configure and manage ASM instances.

recognize the steps for managing ASM storage, scalability, and performance using the ALTER command and also the ASMCMD utility.

create an ASM instance and disk group and use the ASMCMD to view disk group data.

Back to List

Oracle Database 11g: Configuring for Recovery

Overview/Description
To recognize the steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g, using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration

2 Hours

Objectives :

Oracle Database 11g: Configuring for Recovery

identify the benefits of Oracle Database 11gs backup and recovery functionality.

recognize the steps for configuring a database for backup.

recognize the steps for configuring the Flash Recovery Area.

recognize the steps for creating an RMAN recovery catalog and using it to store database backups.

identify the steps for resynchronizing a recovery catalog, using RMAN stored scripts, and backing up a recovery catalog.

create and configure a recovery catalog and register a database in the recovery catalog in a given scenario.

Back to List

Oracle Database 11g: Configuring for Backups

Overview/Description
To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for performing user-managed backups and recoveries.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration

2.5 Hours

Objectives :

Oracle Database 11g: Configuring for Backups

recognize the steps for preparing and optimizing a database for a backup.

recognize the steps for creating fast incremental backup and duplex backup sets using RMAN.

recognize the steps for creating archival and multisection backups and also for compressing and encrypting backups using RMAN.

recognize the steps for backing up to sequential media, such as tape drives, and for using reports and views to monitor backups.

identify the different types of file loss that can occur and the steps for restoring the files and recovering the database in a given scenario.

recognize the steps involved in a complete and an incomplete recovery, and identify the steps for performing a user-managed backup.

recognize the steps for performing different types of user-managed recoveries.

back up a database and recover a lost online redo log file in a given scenario.

Back to List

Oracle Database 11g: Using RMAN for Recovery

Overview/Description
To identify ways to use RMAN to ensure that data is not lost in Oracle Database 11g, by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration

2 Hours

Objectives :

Oracle Database 11g: Using RMAN for Recovery

identify the steps for performing a complete recovery using RMAN.

recognize the steps for using RMAN to perform an incomplete recovery, restore a database to a new host, and perform a disaster recovery.

identify the steps for using RMAN to recover a database in a given scenario.

recognize the steps for creating a duplicate database using RMAN and Enterprise Manager.

recognize the steps for performing a tablespace point-in-time recovery (TSPITR).

clone a database and complete a tablespace point-in-time recovery (TSPITR) in a given scenario.

Back to List

Oracle Database 11g: Supporting RMAN and Using Flashback Technology

Overview/Description
To recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks, and also for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11gs flashback features.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration

2.25 Hours

Objectives :

Oracle Database 11g: Supporting RMAN and Using Flashback Technology

recognize the steps for monitoring RMAN.

recognize the benefits of RMAN backup and restore operations in terms of performing RMAN tuning operations, such as multiplexing.

identify the steps for performing RMAN tuning operations.

recognize the steps for enabling flashback features and for using the recycle bin in Oracle Database 11g.

recognize the steps for using flashback to query data, retrieve versions of rows, view changes made at the transaction level, and reverse a transaction.

use flashback to reverse a transaction in a given scenario.

recognize the steps for recovering a set of tables or an entire database to a specific point in time, using Flashback Tables and Flashback Database.

identify the steps for using guaranteed restore points, for monitoring Flashback Database, and for tracking and archiving data with Flashback Data Archive.

Back to List

Oracle Database 11g: Diagnosing the Database and Managing Memory

Overview/Description
To identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and also for enabling and configuring automatic memory management and automatic shared memory management.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration

2 Hours

Objectives :

Oracle Database 11g: Diagnosing the Database and Managing Memory

identify the steps for viewing diagnostic data and incidents associated with a database problem via Automatic Diagnostic Repository and Support Workbench.

identify the steps for creating a service request (SR) for an incident and packaging and uploading the associated diagnostic data to Oracle Support, and also for monitoring your databases health.

recognize the steps for handling block corruption and for detecting, analyzing, and repairing failures with the help of Data Recovery Advisor.

identify the functions of different memory structures in Oracle Database 11g.

recognize the steps for enabling and monitoring automatic memory management (AMM) and for enabling, configuring, and disabling automatic shared memory management (ASMM).

identify the steps for controlling automatic memory management in the PGA and for sizing the SGA and PGA, and recognize the guidelines for efficient memory usage.

enable automatic memory management and view automatic memory settings in a given scenario.

Back to List

Oracle Database 11g: Database Performance and Space Management

Overview/Description
To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration

2.50 Hours

Objectives :

Oracle Database 11g: Database Performance and Space Management

identify the tuning steps required to establish the Oracle Database 11g environment.

identify the steps for monitoring and managing session performance using Enterprise Manager, views, Automatic Workload Repository (AWR) statistics, and SQL advisors.

recognize the steps for using the SQL Tuning Advisor and SQL Access Advisors to analyze SQL statements and improve data retrieval.

recognize the general steps required to capture a production workload and replay it in a test environment, using the Database Replay feature.

identify a high load SQL statement and then tune it using the SQL Tuning Advisor.

recognize the steps for generally managing and monitoring space in Oracle Database 11g.

recognize the steps for shrinking segments and reclaiming available space using the Segment Advisor and resumable statements.

identify the steps for moving large volumes of data between two Oracle Database 11g databases, using transportable tablespaces.

Back to List

Oracle Database 11g: Managing Resources and Task Automation

Overview/Description
To identify ways to ensure that resources are being put to best use and database jobs are performed when they should be, using the Database Resource Manager and the Scheduler.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration

2 Hours

Objectives :

Oracle Database 11g: Managing Resources and Task Automation

identify the steps for accessing and creating resource plans and consumer groups using the Database Resource Manager.

identify the steps for planning and monitoring resource allocation to consumer groups, using resource plan directives.

use the Database Resource Manager to address system resource utilization and control in a given scenario.

recognize the steps for using the Scheduler to create, schedule and monitor regular and lightweight jobs.

distinguish between time-based and event-based schedules for executing jobs and job chains using the Scheduler.

recognize the steps for performing advanced Scheduler administration to manage job windows, prioritize jobs, and make the best use of resources.

Back to List

Oracle Database 11g: Globalization

Overview/Description
To recognize the steps for utilizing Oracle Database 11gs globalization support features to ensure that information and data is displayed in a users native language, and that territory and language-dependent conventions are adhered to.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration

1.25 Hours

Objectives :

Oracle Database 11g: Globalization

identify the steps for selecting the database character set that meets your needs and for specifying language-dependent behavior.

recognize the steps for performing and customizing linguistic searches and sorts.

identify the steps for performing multiple character set conversions, and for scanning an unknown file set to determine its language.

modify language, date, and time formats for a session and perform a linguistic sort in a given scenario.

Back to List

Exam 1Z0-311: Oracle Application Server 10g: Administration I Curriculum Outline

Oracle Application Server 10g: Introduction

Overview/Description
To provide an introduction to OracleAS architecture, components, and installation options

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
1.25 Hours

Oracle Application Server 10g: Introduction

• Identify the solution areas and terminology associated with OracleAS
• Distinguish between the components of some of the solution areas of OracleAS
• Distinguish between the components of selected solution areas of OracleAS
• Identify how OracleAS middle-tier installation types can be deployed
• Determine an OracleAS installation type for a given scenario

Back to List

Oracle Application Server 10g: Infrastructure and Middle Tier Installation

Overview/Description
To demonstrate how to prepare for, execute, and verify OracleAS Infrastructure and Middle Tier installation

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2.75 Hours

Oracle Application Server 10g: Infrastructure and Middle Tier Installation

• Determine any issues that need to be addressed before the installation of OracleAS Infrastructure
• Select the necessary options when initiating OracleAS Infrastructure installation in a given scenario
• Complete an OracleAS Infrastructure installation
• Perform OracleAS Infrastructure postinstallation tasks
• Prepare for, execute, and verify an installation of OracleAS Infrastruture
• Perform an installation of OracleAS Middle Tier
• Perform OracleAS Middle Tier postinstallation tasks
• Execute and verify an installation of OracleAS Middle Tier

Back to List

Oracle Application Server 10g: Management Tools and Oracle Internet Directory

Overview/Description
To demonstrate how to use OracleAS management tools and manage the Oracle Internet Directory (OID)

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2.75 Hours

Oracle Application Server 10g: Management Tools and Oracle Internet Directory

• Perform some basic management tasks from the home pages of Application Server Control
• Perform some basic process management tasks using the opmnctl utility in OracleAS
• Perform management tasks using the dcmctl utility
• Perform management tasks with emctl, opmnctl, and dcmctl utilities in OracleAS
• Define the role and security benefits of Oracle Internet Directory (OID)
• Identify the architecture of the OID server instance and OID node
• Stop and start an OID server instance in OracleAS
• Identify the commands used to manage data in the directory server and launch Oracle Directory Manager
• Perform some OID process and directory management tasks in a given scenario

Back to List

Oracle Application Server 10g: General Management and Directives for the HTTP Server

Overview/Description
To demonstrate how to perform general management of Oracle HTTP Server (OHS)

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
4 Hours

Oracle Application Server 10g: General Management and Directives for the HTTP Server

• Recognize the server-level directives used to set Oracle HTTP Server (OHS) processes and connections
• Identify the role of Oracle HTTP Server (OHS) files and file-location directives in OracleAS
• Perform the steps to change HTTP server properties in OracleAS
• Configure some properties of Oracle HTTP Server (OHS) in OracleAS in a given scenario
• View and edit HTTP server logs in OracleAS
• Use Application Server Control to modify advanced server properties and enable status-report generation for Oracle HTTP Server (OHS)
• Perform the tasks to update Oracle HTTP Server (OHS) logs and configuration files in OracleAS in a given scenario
• Recognize the key concepts associated with Oracle HTTP Server (OHS) configuration
• Define container directives for an HTTP server in OracleAS
• Use the Options and AllowOverrides directives and appropriate parameters to control the features that an HTTP server allows
• Use the appropriate directives to set indexing, error handling, caching behavior, and aliases in Oracle HTTP Server (OHS)
• Identify how to redirect HTTP server requests using mod_rewrite directives
• Define directives for an HTTP server in a given scenario

Back to List

Oracle Application Server 10g: OracleAS Web Cache

Overview/Description
To demonstrate how to administer and configure OracleAS Web Cache

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2.25 Hours

Oracle Application Server 10g: OracleAS Web Cache

• Recognize the key concepts and administration tasks associated with OracleAS Web Cache
• Perform general administration tasks for OracleAS Web Cache
• Perform basic OracleAS Web Cache administration tasks in a given scenario
• Configure site definitions and server mappings for OracleAS Web Cache
• Create and configure caching rules for OracleAS Web Cache
• Configure basic cache-content invalidation in OracleAS
• Configure logging in OracleAS Web Cache
• Configure different elements of OracleAS Web Cache in a given scenario

Back to List

Oracle Application Server 10g: OracleAS Portal

Overview/Description
To demonstrate how to manage OracleAS Portal

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
3 Hours

Oracle Application Server 10g: OracleAS Portal

• Define the roles of the key utilities of OracleAS Portal
• Create and manage OracleAS Portal schemas and users
• Perform some of the core management tasks associated with OracleAS Portal groups
• Perform management tasks for an OracleAS Portal user and group in a given scenario
• Perform portlet repository management tasks in OracleAS Portal
• Export and import objects in OracleAS Portal
• Perform the appropriate portlet repository and export/import tasks in a given scenario
• Configure self-registration and view OraDAV configuration for OracleAS Portal
• Configure language support and portal dependencies in OracleAS Portal
• Configure some core features of OracleAS Portal in a given scenario

Back to List

Oracle Application Server 10g: mod_plsql, CGI Scripts, and Database Providers

Overview/Description
To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2 Hours

Oracle Application Server 10g: mod_plsql, CGI Scripts, and Database Providers

• Define the role of the key Oracle HTTP Server (OHS) modules used to deploy PL/SQL and CGI applications
• Configure how mod_plsql connects to a database server to fulfill HTTP requests
• Recognize the syntax for invoking a PL/SQL application and configure caching for mod_plsql
• Configure different elements of mod_plsql in a given scenario
• Distinguish between the entries used in an httpd.conf file to enable the execution of different types of CGI scripts
• Register the database provider with OracleAS Portal
• Perform some of the steps to configure Oracle for Fast CGI and the database provider in a given scenario

Back to List

Oracle Application Server 10g: Application Management and Deployment

Overview/Description
To demonstrate how to manage and deploy applications in OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2.50 Hours

Oracle Application Server 10g: Application Management and Deployment

• Perform the appropriate, basic OC4J management tasks in OracleAS
• Configure OC4J server properties in OracleAS
• Perform the basic tasks for J2EE application management in OracleAS
• Manage an OC4J instance and J2EE application in OracleAS, in a given scenario
• Create a data source in OracleAS
• Deploy web-application modules and deploy complete J2EE applications in OracleAS
• Register web providers in OracleAS
• Perform the tasks to deploy an application in OracleAS

Back to List

Oracle Application Server 10g: Component Administration in Oracle Internet Directory

Overview/Description
To demonstrate how to configure Oracle Internet Directory (OID) components in OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
1.50 Hours

Oracle Application Server 10g: Component Administration in Oracle Internet Directory

• Recognize the administration options available with Oracle Internet Directory (OID)
• Assign user and group privileges in Oracle Internet Directory (OID)
• View and modify Oracle Internet Directory (OID) password-related information in OracleAS
• Configure Oracle Internet Directory (OID) settings in OracleAS Portal
• Perform a series of Oracle Internet Directory (OID) administration tasks, in a given scenario, in OracleAS

Back to List

Oracle Application Server 10g: DAS and SSO

Overview/Description
To demonstrate how to manage users and groups with Delegated Administration Service (DAS) and administer the Single Sign-On feature of OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
3 Hours

Oracle Application Server 10g: DAS and SSO

• Start, stop, and verify the operation of the Delegated Administrative Service (DAS) in OracleAS
• Perform key user and group administration tasks in OracleAS Delegated Administration Service (DAS)
• Configure how user entries display in OracleAS Delegated Administration Service (DAS)
• Perform service, account, and identity management realm management tasks in OracleAS Delegated Administration Service (DAS)
• Perform the tasks to manage a user and user account in OracleAS Delegated Administration Service (DAS), in a given scenario
• Sequence the steps in the OracleAS Single Sign-On (SSO) authentication process
• Perform some basic Single Sign-On (SSO) administration tasks in OracleAS
• Perform the key administration tasks for partner and external applications in OracleAS Single Sign-On (SSO)
• Perform the tasks to appropriately administer an SSO server, in a given scenario

Back to List

Oracle Application Server 10g: Component Security with SSL

Overview/Description
To demonstrate how to manage wallets and certificates and configure components for SSL in OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
2.25 Hours

Oracle Application Server 10g: Component Security with SSL

• Outline the interactions between client and server when using SSL in OracleAS
• Perform key management tasks in Oracle Wallet Manager
• Perform certificate-management tasks in OracleAS
• Perform wallet and certificate management tasks in OracleAS, in a given scenario
• Configure SSO, Oracle Internet Directory (OID), and OracleAS Web Cache for SSL
• Configure OracleAS Portal for SSL
• Perform some of the tasks to configure SSO, OID, and OracleAS Portal for SSL

Back to List

Oracle Application Server 10g: Oracle Certificate Authority Management

Overview/Description
To demonstrate how to manage Oracle Certificate Authority (OCA)

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial

Expected Duration
1.50 Hours

Oracle Application Server 10g: Oracle Certificate Authority Management

• Identify the tools that make up the OracleAS PKI solution
• Define the key elements of the Oracle Certificate Authority (OCA) architecture
• Perform the steps to set up administration access in OracleAS Certificate Authority (OCA)
• Perform key certificate management tasks in Oracle Certificate Authority (OCA)
• Manage the Oracle Certificate Authority (OCA) server and certificates in a given scenario

Back to List

Exam 1Z0-312: Oracle Application Server 10g: Administration II Curriculum Outline

Oracle Application Server 10g: Managing Customized Topologies and Distributing Infrastructure Components

Overview/Description
To discuss common deployment topologies and to explain how to install and configure Oracle Application Server components to suit different needs

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial; a good understanding of Oracle Application Server components and concepts

Expected Duration
3 Hours

OracleAS 10g: Managing Customized Topologies and Distributing Infrastructure Components

• Identify some of the new features available for managing customized topologies and recognize some of the key deployment considerations
• Identify the main considerations for evaluating general development topologies
• Identify key considerations when evaluating the departmental, development life cycle, and data centre topologies
• Evaluate recommended development and deployment topologies
• Recognize the features of Cold Failover Clusters, Active Failover Clusters, and Identity Management replication as part of high availability deployments
• Identify how to use multiple metadata repositories and list the requirements for installing OracleAS Infrastructure using an existing Oracle9i database
• Install OracleAS Infrastructure by using an existing Infrastructure component
• Install a Metadata Repository into an existing database and install the Infrastructure using the existing repository
• Identify how to upgrade a distributed OracleAS environment and recognize the effect of an upgrade on system availability
• Identify the steps involved in the procedure for upgrading the middle tier, Metadata Repository, and Identity Management Services
• Identify how to upgrade a system to Oracle AS 10g

Back to List

Oracle Application Server 10g: High Availability

Overview/Description
To explain high availability and its importance from the perspective of application servers and discuss the high availability features in Oracle Application Server at the OC4J level

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial; a good understanding of Oracle Application Server components and concepts

Expected Duration
2.50 Hours

OracleAS 10g: High Availability

• Recognize the concepts associated with high availability and identify the features of Oracles end-to-end high availability solution
• Determine the appropriate method of providing high availability for applications and the middle tier
• Determine the appropriate method of providing high availability for OracleAS Infrastructure using clustering
• Outline the site-to-site high availability solution for OracleAS Infrastructure
• Determine a high availability solution for a given scenario
• Identify the benefits of J2EE clustering and the configuration of islands
• Recognize the concepts involved in session and application replication for high availability solutions
• Create an OC4J island, configure state replication, and monitor virtual machine metrics
• Configure clustering of OC4J Java Virtual Machines

Back to List

Oracle Application Server 10g: Managing and Configuring Clusters

Overview/Description
To explain how to manage and configure clusters in OracleAS 10g

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial; a good understanding of Oracle Application Server components and concepts

Expected Duration
3.25 Hours

OracleAS 10g: Managing and Configuring Clusters

• Explain clustering and describe how OracleAS Web Cache clusters work
• Configure Web Cache cluster members and settings, and identify how to invalidate the cache
• Configure session binding and monitor cache cluster performance
• Configure web cache cluster settings, add an additional web cache to a cache cluster, and obtain performance statistics for the web cache
• Create an OracleAS Farm using a file-based repository
• Identify the characteristics of OracleAS clusters managed using a repository
• Identify the role of OPMN, DCM, and mod_oc4j in OracleAS cluster management
• Create, stop, and start an OracleAS cluster, add and remove instances, and identify how to create an OracleAS cluster using dcmct1
• Create clusters and add standalone instances
• Outline the architecture of OracleAS Infrastructure Cold Failover Clusters and identify how to install middle tiers in a CFC environment
• Identify the steps involved in installing and starting an OracleAS Infrastructure in a Cold Failover Cluster and identify how to manage and test a failover

Back to List

Oracle Application Server 10g: Business Intelligence Component Management

Overview/Description
To examine Business Intelligence components such as Oracle AS Discoverer and OracleAS Reports and to describe how to deploy reports and forms applications to OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial; a good understanding of Oracle Application Server components and concepts

Expected Duration
4 Hours

OracleAS 10g: Business Intelligence Component Management

• Monitor OracleAS Report Services and control and configure OracleAS Discoverer
• Configure OracleAS Discoverer Plus, Discoverer Viewer, and Discoverer Portlet Provider, and register Discoverer Portlet Provider
• Control OracleAS Discoverer services
• Identify features for monitoring OracleAS Discoverer, identify the configuration files used with Discoverer, and use the EUL command-line tool for Java
• Identify the capabilities of OracleAS Reports Services and determine how its components contribute to the running of a report
• Identify Reports Services configuration files and configure the Reports Server and the Reports Servlet
• Identify how to deploy reports using OracleAS Reports Services
• Configure Reports Services and deploy a Reports application
• Outline the architecture of Forms Services and identify the role of each Forms Service component in running an application
• Identify the configuration files and the levels of configuration associated with OracleAS Forms Services, identify how the configuration files are used at runtime, and use Application Server Control for configuration tasks
• Configure the Forms Servlet using Application Server Control
• Configure environmental variables in a Forms runtime environment, manage user sessions, and identify how to deploy Forms applications and their associated files
• Configure the Forms Servlet for a new testing environment

Back to List

Oracle Application Server 10g: XML Applications, Web Services, and Monitoring

Overview/Description
To describe how to deploy XML applications and web services with Oracle AS and to discuss the monitoring capabilities of Oracle Enterprise Manager Application Server Control

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial; a good understanding of Oracle Application Server components and concepts

Expected Duration
2.75 Hours

OracleAS 10g: XML Applications, Web Services, and Monitoring

• Define terms associated with XML, identify the Oracle XML and XDK components, and identify the steps in the XML parsing process
• Recognize how an XSQL servlet functions, initialize the XSQL demo application, and create and access an XSQL page
• Define the Web services standards, identify why organizations use Web services, and outline the Web services architecture and communication flow
• Identify the main features of SOAP, and describe how to invoke, manage, and deploy Web services, and how to implement a stateless Java Web service
• Use Web services and XSQL
• Identify Log Loader tasks and search log files
• Configure diagnostic message correlation
• Manage and troubleshoot the Log Loader
• Use the log repository to monitor OracleAS

Back to List

Oracle Application Server 10g: Tuning and Reconfiguring the Middle Tier

Overview/Description
To describe how to optimize the performance of Oracle Application Server components and to explain how to perform reconfiguration tasks in the Oracle Application Server middle tier and infrastructure

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial; a good understanding of Oracle Application Server components and concepts

Expected Duration
4.25 Hours

OracleAS 10g: Tuning and Reconfiguring the Middle Tier

• Identify how to monitor the performance of Oracle Application Server
• Monitor performance and analyze performance issues in OracleAS
• Monitor and tune the performance of OC4J processes and applications
• Monitor OracleAS system components
• Identify how to set up data sources and connection attributes
• Identify useful hints and tips for tuning servlets, JSPs, EJBs, and the web cache
• Monitor and tune the performance of OracleAS Web Cache and Forms Services
• Configure browser keep-alive and origin server response timeouts and monitor metrics for a Forms Service instance
• Expand a middle tier installation in OracleAS in a given scenario
• Configure services after installation in OracleAS
• Expand a middle tier and configure Forms Services in a given scenario
• Associate installations with the Infrastructure and remove instances in OracleAS
• Identify the steps for changing the host name and IP address on the middle tier and the IP address on the Infrastructure
• Associate a J2EE and Web Cache installation with Identity Management and change the host name on the server hosting Oracle Application Server middle tier

Back to List

Oracle Application Server 10g: Backup and Recovery

Overview/Description
To explain how to perform backup and recovery procedures in OracleAS

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial; a good understanding of Oracle Application Server components and concepts

Expected Duration
1.75 Hours

OracleAS 10g: Backup and Recovery

• Identify the type of Oracle Application Server backup to perform in a given scenario
• Recognize how to configure and use the OracleAS Backup and Recovery Tool
• Identify the steps for performing backup procedures in OracleAS
• Identify the steps for restoring OracleAS infrastructure or middle-tier installations from backup
• Back up and restore OracleAS configurations

Back to List

Exam 1Z0-047: Oracle Database 11g: SQL Expert I Curriculum Outline

Oracle Database 11g: Using SQL to Query Your Database

Overview/Description
To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
2.2

Lesson Objectives

Oracle Database 11g: Using SQL to Query Your Database

Identify the functions, capabilities, and terminology associated with Oracle Database 11gs components and relational databases in general.

Recognize the steps for using Oracle SQL Developer to create a new database connection and browse tables.

Recognize the steps for using the SQL SELECT statement to retrieve different sets of data from a database.

Recognize the steps for limiting and ordering the rows returned by a SQL query.

Recognize ways to sort data returned by a SQL query, using substitution variables as well as the DEFINE and VERIFY commands.

Recognize the steps for using SQL functions to modify, format, and otherwise manipulate returned data.

Identify and write SQL queries to display, sort, and format output in a given scenario.

Course Number:
257492_eng

Back to List

Oracle Database 11g: Conversion Functions, Group Functions, and Joins

Overview/Description
To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g: Conversion Functions, Group Functions, and Joins

Identify the steps for using functions to convert character, date, and numeric values and perform operations pertaining to null values.

Recognize the steps for using the CASE expression and the DECODE function to implement conditional processing.

Identify and write queries that convert data types and implement conditional processing, in a given scenario.

Recognize the benefits of using group functions to return values for groups of rows.

Identify the steps for creating, restricting, and nesting group functions.

Identify the steps for using joins to return data from more than one table.

Write queries that calculate values for groups of data and return values from multiple tables in a given scenario.

Course Number:
257503_eng

Back to List

Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation

Overview/Description
To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
1.9

Lesson Objectives

Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation

Recognize the steps for using subqueries inside other queries to perform various actions.

Identify the steps for using set operators to combine the results of two or more queries.

Write queries using set operators.

Identify the steps for adding new rows to a table, modifying table data, and removing rows.

Recognize the steps for controlling database transactions, and implementing read consistency.

Insert, update and delete rows in a table, and control data transactions to it.

Course Number:
257513_eng

Back to List

Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms

Overview/Description
To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms

Recognize the steps for creating, defining, and naming a table, and for specifying data types for its columns.

Recognize the steps for using constraints to prevent invalid data entry into tables.

Recognize the steps for altering or dropping a table.

Identify the steps for creating and manipulating views to view or hide a tables data.

Recognize the steps for using sequences to create integers, using indexes to improve the performance of queries, and using synonyms to give a table an alternative name.

Create a new table and create and use a sequence, index, and synonym.

Course Number:
257522_eng

Back to List

Oracle Database 11g: Controlling User Access and Managing Schema Objects

Overview/Description
To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 11g: Controlling User Access and Managing Schema Objects

Identify the steps for granting and revoking system and object privileges.

Grant privileges to users in a given scenario.

Recognize the steps for altering a table by adding, modifying, and dropping columns.

Recognize the steps for adding and manipulating constraints and for creating indexes.

Identify the steps for recovering your database using flashback, and for manipulating external data.

Alter a table by dropping columns and adding constraints and indexes.

Course Number:
257867_eng

Back to List

Oracle Database 11g: Data Dictionary Views and Large Data Sets

Overview/Description
To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.7

Lesson Objectives

Oracle Database 11g: Data Dictionary Views and Large Data Sets

Identify the steps for using data dictionary views to find information about tables, constraints, views, sequences, and synonyms.

Query the appropriate dictionary views to find information about schema objects in a given scenario.

Recognize the steps for manipulating data using subqueries and explicit default values.

Identify the steps for inserting into multiple tables, merging rows in tables, and tracking changes in data.

Manipulate large data sets using multitable INSERT and MERGE operations.

Course Number:
257876_eng

Back to List

Oracle Database 11g: Managing Data in Different Time Zones

Overview/Description
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.3

Lesson Objectives

Oracle Database 11g: Managing Data in Different Time Zones

Recognize the steps for managing time zones and time intervals.

Recognize the steps for using datetime functions to manage dates and time in Oracle Database 11g.

Display time zone offsets in a given scenario.

Extract and return the value of a datetime field in a given scenario.

Course Number:
257884_eng

Back to List

Oracle Database 11g: Using Subqueries and Regular Expressions

Overview/Description
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.8

Lesson Objectives

Oracle Database 11g: Using Subqueries and Regular Expressions

Identify the steps for writing multiple-column and scalar subqueries.

Recognize the steps for solving problems by using correlated subqueries and the WITH clause.

Write multiple-column, correlated, and scalar subqueries in a given scenario and solve a problem using the WITH clause.

Recognize the benefits of implementing complex match logic in the database, using regular expressions.

Identify the steps for using regular expressions functions and for accessing subexpressions.

Use regular expression functions to search for, replace, and manipulate data, and also add a CHECK constraint to a column.

Course Number:
257896_eng

Back to List

Exam 1Z0-050: Oracle Database 11g: New Features for Administrators Curriculum Outline

Oracle Database 11g Release 2: Installation and Oracle Restart

Overview/Description
Oracle Database 11g Release 2 offers a unique scale-out technology with a single database instance, lower server and storage costs, and increased availability and scalability. It also provides customers with improved user service levels, reduced down-time, and more efficient use of IT resources as well as an increased level of performance and security. In addition it provides business intelligence and data warehousing. This course demonstrates how to install the Oracle Grid Infrastructure, use ASMCA to create disk groups, and create and manage ASM volumes and the Cluster File System. It also outlines how to install Oracle Database 11g, enable direct NFS, using online patching, and use Oracle Restart to manage the components. It is one of a series of courses in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for the Oracle Database 10g Administrator Certified Professionals (10g DBA OCP) to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g Release 2: Installation and Oracle Restart

Recognize the benefits of Oracle Grid Infrastructure

Install the Oracle Grid Infrastructure

Create and manage ASM Dynamic Volumes

Create and manage ASM Cluster File System

Install Oracle Database 11g software

Identify the upgrade paths and deprecated features

Identify the features of Direct NFS

Recognize the features of Online Patching

Manage components using Oracle Restart

Install and configure Oracle Database 11g Release 2

Course Number:
od_onft_a01_it_enus

Back to List

Oracle Database 11g Release 2: ASM, Storage and Partitioning Enhancements

Overview/Description
Oracle Database 11g Release 2 provides many improvements from its previous releases. This includes enhancements to ASM and storage to improve performance and to reduce server maintenance down time. This course identifies the enhancements in each of these areas. It also demonstrates how to use ASM fast mirror resync, manage ASM users, disk groups, ACLs, and Intelligent Data Placement, as well as table compression, SQL Access Advisor, and segment creation. It is one of a series of courses in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for the Oracle Database 10g Administrator Certified Professional (10g DBA OCP) to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g Release 2: ASM, Storage and Partitioning Enhancements

Identify the options available when using ASM

Manage ASM disk groups

Manage ASM ACLs

Use ASM Intelligent Data Placement

Use Oracle Database 11g Release 2s ASM enhancements

Identify the features of 4-KB sector disks

Compress table data

Create SQL Access Advisor analysis sessions

Create temporary tablespaces and segments

Course Number:
od_onft_a02_it_enus

Back to List

Oracle Database 11g Release 2: Oracle Partitioning and Security Features

Overview/Description
Oracle Database 11g Release 2 offers more advanced data warehouse, partitioning, security and network feature enhancements to allow the DBA to provide a more efficient way for users to access data in a secure environment. This course covers the enhanced data warehouse and partition enhancements, which includes support for loading data stored in compressed files, new parameters for simplified parallelism implementation, and new partitioning methods. It also covers the security and networking enhancements, including how to use SecureFiles, the password file, default auditing, and tablespace encryption, as well as network support for IPv6 and configuring fine-grained access. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g Release 2: Oracle Partitioning and Security Features

Load data that is stored in compressed files

Implement simplified parallelism

Implement new partitioning methods

Recognize the features of Oracle SecureFiles

Use SQL and PL/SQL APIs to access SecureFiles

Implement the enhanced security features in Oracle Database 11g Release 2

Encrypt a tablespace and control access to the network

Identify how Oracle Net supports IPv6

Apply Oracle Database 11g R2s partitioning features in a given scenario

Employ Oracle Database 11g R2s enhanced security features

Course Number:
od_onft_a03_it_enus

Back to List

Oracle Database 11g Release 2: Using Change Management Solutions

Overview/Description
Oracle Database 11g Release 2 is designed for data center environments that are rapidly evolving and changing to keep up with business demands, enabling DBAs to manage change effectively and efficiently. Oracle Database 11g Release 2 offers significant advances in the areas of automatic diagnostics, supportability, and change management. It can be expensive for organizations to evaluate and implement changes to their data center infrastructure, and Oracle addresses this issue with a collection of solutions under the umbrella of Change Management. These consist of SQL Performance Analyzer, SQL Plan Management, and Database Replay. This course identifies each of these change management solutions and demonstrates how to use them to analyze SQL statements, test upgrades, and capture and analyze workloads. It is one of a series of courses in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g Release 2: Using Change Management Solutions

Identify the phases of the lifecycle of change management

Recognize the features of SQL Performance Analyzer

Use SQL Performance Analyzer to measure database performance

Recognize the features of SQL Plan Management

Migrate stored outlines to SQL Plan baselines

Identify how Database Replay can capture and process a workload

Identify the features of workload filters and replay analysis

Identify how to use Database Replay

Plan for and test the effectiveness of a change in data center infrastructure

Course Number:
od_onft_a04_it_enus

Back to List

Oracle Database 11g Release 2: Intelligent Infrastructure Enhancements

Overview/Description
Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded features for automatic SQL tuning and the Automatic Workload Repository, which allows the DBA to ensure the database is running efficiently, and by using the Enhanced Resource Manager the DBA has the ability to optimize resource allocation among many different database sessions to prevent excessive overhead. This course identifies how to automatically tune SQL statements using Automatic SQL Tuning, use Automatic Workload Repository baselines to gather performance metrics, control maintenance tasks, determine I/O metrics using I/O Calibration tool, and use Resource Manager. This course is one of a series in the SkillSoft learning path that covers objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g Release 2: Intelligent Infrastructure Enhancements

Setup and manage Automatic SQL Tuning

Identify the features of AWR baselines

Control automated maintenance tasks

Determine and gather I/O metrics

Identify the Resource Manager database and server consolidation features

Identify the features of instance caging

Creating AWR baselines

Control an AutoTask job

Calibrate I/O resources

Course Number:
od_onft_a05_it_enus

Back to List

Oracle Database 11g Release 2: Diagnosability Enhancements

Overview/Description
Oracle Database 11g Release 2 offers new diagnosability enhancements to help DBAs in diagnosing, resolving, and preventing problems. These new features include enhancements to problem and incident identification, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently diagnose issues and report problems to Oracle Support, as well as reducing damage and interruptions. This course discusses using Automatic Diagnostic Repository, creating and submitting Incident Packages to Oracle Support, running health checks and viewing the reports. It also demonstrates how to use SQL Repair Advisor and SQL Test Case Builder. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Expected Duration (hours)
1.0

Lesson Objectives

Oracle Database 11g Release 2: Diagnosability Enhancements

Identify the features of Automatic Diagnostic Repository

Handle critical errors using Enterprise Manager Support Workbench

Create User-Reported Problems

Run database health checks

Use SQL Repair Advisor

Employ Oracles improved diagnosis tools

Course Number:
od_onft_a06_it_enus

Back to List

Oracle Database 11g Release 2: SQL Monitoring and Performance Enhancements

Overview/Description
Oracle Database 11g Release 2 offers improvements and new features to provide DBAs a better way to monitor SQL commands in real-time and to allow the database to automatically manage its own memory and gather optimizer statistics. These features enable the DBA to ensure the optimal memory sizes are being used for the database using Automatic Memory Management, and that SQL statements are running properly by monitoring them in real-time using Enterprise Manager. It also offers a new feature to conceptually extend the buffer cache by using DB Smart Flash. This course demonstrates how to monitor SQL commands in real-time using SQL Monitoring, use Automatic Database Diagnostic Monitoring (ADDM), DB Smart Cache, gather and view different statistics for partitioned tables, hash-based sampling, multicolumn, and expressions, and use deferred statistics. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Expected Duration (hours)
1.0

Lesson Objectives

Oracle Database 11g Release 2: SQL Monitoring and Performance Enhancements

Monitor the performance of SQL statements in real time

Use Automatic Database Diagnostic Monitoring

Use Automatic Memory Management

Improve database performance by using DB Smart Flash Cache

Use Optimizer Statistics

Identify Oracle Database 11g R2s locking enhancements

Utilize the Oracle Database 11g Release 2 performance enhancements and monitor SQL

Course Number:
od_onft_a07_it_enus

Back to List

Oracle Database 11g Release 2: Application Performance Enhancements

Overview/Description
Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and improved query and DML performance. Application performance in Oracle Database 11g Release 2 is also improved by the use of adaptive cursor sharing, which allows for intelligent cursor sharing and the use of invisible indexes. It provides two different caches. The first cache includes SQL Query Result Cache used to cache query results or query blocks for future use, which reduces memory use and provides scalability. The second cache is the PL/SQL cross-section function result caching mechanism, which provides a language-supported and system-managed means for storing the results of PL/SQL functions in the SGA, so that they are available to all the application sessions that are running. This course identifies the new online redefinition enhancements for tables, invisible indexes, adaptive cursor sharing, and using SQL Query Result, Client Query, and PL/SQL Function Caches. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Expected Duration (hours)
1.0

Lesson Objectives

Oracle Database 11g Release 2: Application Performance Enhancements

Identify online redefinition enhancements

Recognize the features of invisible indexes

Identify the features of Adaptive Cursor Sharing

Use the SQL query result cache

Use the client-side query cache

Identify the features of the PL/SQL function cache

Improve application performance

Course Number:
od_onft_a08_it_enus

Back to List

Oracle Database 11g Release 2: Backup, Recover, Archive, and Repair Data

Overview/Description
Oracle Database 11g Release 2 offers new and improved features to ensure for continuous data access, even during unplanned failures and scheduled maintenance tasks. New RMAN features make it easier to backup, recover and duplicate databases in a timely manner while minimizing data loss. It also offers Flashback technology, giving DBAs additional protection against data loss, as well as the Data Recovery Advisor which automatically diagnoses data failures and offers suggestions on how to correct the issues. This course demonstrates how to backup and recover database, archive backups, using TSPITR, and manage the recovery catalogs. It also demonstrates how to use the Flashback Data Archive, Flashback Transaction Backout, LogMiner, and Data Pump as well as use the Data Recovery Advisor. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g Release 2: Backup, Recover, Archive, and Repair Data

Identify the new features of RMAN

Duplicate a database

Identify how to create archival backups and use the new features of TSPITR

Manage recovery catalogs

Create and use virtual private catalogs

Create, protect, and use history data with Flashback Data Archive

Identify the features of Flashback Transaction Backout and LogMiner

Use Data Pump legacy mode

Repair data after a failure

Archive, recover, and repair data

Course Number:
od_onft_a09_it_enus

Back to List

Oracle Database 11g Release 2: Oracle Scheduler and Secure Backup

Overview/Description
Oracle Database 11g Release 2 offers improvements to Oracle Scheduler that increases efficiency and usability. These include allowing users to get specific email notifications about job activities, triggering jobs to automatically execute when the specified file is received, enabling jobs to run on multiple nodes while managing it from a central location, and running PL/SQL on a remote database as a job. Oracle Database 11g Release 2 also offers backup to Amazon S3 through the Oracle Secure Backup module, this offers a low-cost database backup Web services storage option rather than maintaining a local backup infrastructure. This course demonstrates how to use Oracle Schedule to create email notifications, create file watchers and create and manage remote database and multiple destination jobs. It also discusses the Oracle Secure Backup Cloud module. This course is one of a series in the SkillSoft learning path that covers the objectives for the Oracle exam 1Z0-050 Oracle Database 11g: New Features for Administrators, which is an upgrade path for Oracle Database 10g Administrator Certified Professional (10g DBA OCP) certified individuals to achieve Oracle Database 11g Administrator Certified Professional (11g DBA OCP) certification.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA’s considering upgrading their systems to 11g

Expected Duration (hours)
1.0

Lesson Objectives

Oracle Database 11g Release 2: Oracle Scheduler and Secure Backup

Use Scheduler email notifications

Create a file watcher

Create remote database and multiple destination jobs

Use Oracle Secure Backup Cloud module

Schedule tasks and use Oracle Secure Backup

Course Number:
od_onft_a10_it_enus

Back to List

Mentoring 1Z0-050 Oracle Database 11g: New Features for Administrators

Overview/Description
SkillSoft Mentors are available to help students with their studies for exam 1Z0-050 Oracle Database 11g: New Features for Administrators. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.

Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.

Expected Duration (hours)
0.0

Lesson Objectives

Mentoring 1Z0-050 Oracle Database 11g: New Features for Administrators

Installation and Upgrade Enhancements

Storage Enhancements

Intelligent Infrastructure Enhancements

Performance Enhancements

Partitioning and Storage-Related Enhancements

Using RMAN Enhancements

Using Flashback and Logminer

Diagnosability Enhancements

Database Replay

Using the Data Recovery Advisor

Security: New Features

Oracle SecureFiles

Miscellaneous New Features

SQL Performance Analyzer

SQL Plan Management

Automatic SQL Tuning

Course Number:
mnt1z0050

Back to List

TestPrep 1Z0-050 Oracle Database 11g: New Features for Administrators

Overview/Description
To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test.

Target Audience
Individuals seeking practice in a structured testing environment, covering the skills and competencies being measured by the vendor certification exam.

Prerequisites
The associated SkillSoft certification content should be completed before attempting this TestPrep. This will maximize the effectiveness of the preparation exam.

Expected Duration (hours)
0.0

Lesson Objectives

TestPrep 1Z0-050 Oracle Database 11g: New Features for Administrators

Installation and Upgrade Enhancements

Storage Enhancements

Intelligent Infrastructure Enhancements

Performance Enhancements

Partitioning and Storage-Related Enhancements

Using RMAN Enhancements

Using Flashback and Logminer

Diagnosability Enhancements

Database Replay

Using the Data Recovery Advisor

Security: New Features

Oracle SecureFiles

Miscellaneous New Features

SQL Performance Analyzer

SQL Plan Management

Automatic SQL Tuning

Course Number:
TP1Z0050_eng

Back to List

Oracle Database 11g: Installation and Upgrade Enhancements

Overview/Description
Recognize the enhancements to Oracle Database 11gs installation and upgrade processes, as well as its various post-upgrade steps, and recognize how to create a new database.

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

140 Minutes

Objectives :

Oracle Database 11g: Installation and Upgrade Enhancements

Recognize the benefits of Oracles Infrastructure grid and self-tuning capabilities.

Identify the changes to the Oracle database installation process and recognize the steps for installing Oracle Database 11g.

Recognize Oracle Database 11gs upgrade enhancements and identify the steps for performing an upgrade.

Recognize the steps for running the Oracle Database Upgrade Assistant as part of an upgrade.

Recognize the common post-upgrade steps and adjustments to initialization parameters, and identify the steps for creating a database.

Identify the steps for enabling Direct Network File System and installing a hot patch.

Identify the best practices and recommendations for testing and analyzing an Oracle Database 11g installation.

Create a new Oracle Database 11g database.

Back to List

Oracle Database 11g: Storage Enhancements

Overview/Description
recognize ways in which storage has been enhanced in Oracle Database 11g using Automatic Storage Managements (ASMs) commands and extensions.

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

100 Minutes

Objectives :

Oracle Database 11g: Storage Enhancements

Recognize the ways to enhance efficiency and performance of Oracle Database 11g by using Automatic Storage Management (ASM) Fast Mirror Resync and ASM Preferred Mirror Read.

Identify ways to use ASM to enhance scalability and performance and control disk group attributes and compatibility.

Identify the steps for adding an offlined disk without ASM and also with ASM, following a nondata issue.

Recognize the syntax for performing disk group checks, mounting disk groups for fast rebalance, and forcing a disk group drop.

Identify the correct method for backing up ASM metadata using ASMCMD extensions.

Back up ASM metadata using ASMCMD extensions.

Back to List

Oracle Database 11g: Change Management Overview and SQL Plan Management

Overview/Description
outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

150 Minutes

Objectives :

Oracle Database 11g: Change Management Overview and SQL Plan Management

Recognize the steps for managing change when upgrading or reconfiguring Oracle Database, including the setting up a snapshot standby database as a test environment.

Recognize the general uses and benefits of SQL Performance Analyzer for ascertaining performance gains following a database change.

Identify the steps for capturing the SQL workload using SQL tuning sets.

Identify the different tasks that can be performed when managing components using the SQL Performance Analyzer.

Recognize the ways in which the different phases of the SQL Performance Analyzer help to assess the SQL performance impact of change.

Identify the elements of SQL plan management and recognize the steps for seeding SQL plan baselines.

Recognize ways to load and evolve SQL plan baselines, select SQL plans, and set up various SQL plan management scenarios.

Recognize the steps for executing all phases of SQL plan management.

Seed SQL Plan Baselines for your most regressing statements.

Back to List

Oracle Database 11g: Database Replay and Automatic SQL Tuning

Overview/Description
Explain the benefits and uses of Oracle Database 11gs crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

155 Minutes

Objectives :

Oracle Database 11g: Database Replay and Automatic SQL Tuning

Recognize the benefits of using Database Replay and the concepts and reasons behind recreating a production database workload in a test environment.

Identify the scope of Database Replays capabilities by recognizing the supported database changes and workloads, as well as some of the considerations and available options during capture, replay and replay analysis.

Identify the steps for running Database Replay using the Capture Wizard in Enterprise Manager.

Recognize the steps for replaying workload using the Replay Workload Wizard and also using PL/SQL to do the same, as well as calibrating replay clients.

Identify the steps for capturing the workload for a small application using Database Replay and replaying it to get the same results as during the original execution.

Run Database Replay in Enterprise Manager.

Recognize how SQL tuning can benefit developers in improving the performance of SQL statements, and identify the methods and DBA controls that you can use in Oracle Database 11g to run the Automatic SQL Tuning feature.

Identify the general steps and concepts behind configuring Automatic SQL Tuning, reviewing results, and performing a fine tune using PL/SQL.

Recognize the steps for executing Automatic SQL Tuning and viewing its results.

Back to List

Oracle Database 11g: Intelligent Infrastructure Enhancements

Overview/Description
Identify how to monitor performance, automate maintenance, calibrate and manage resources, and streamline job scheduling using Oracle Database 11gs intelligent infrastructure enhancements.

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

120 Minutes

Objectives :

Oracle Database 11g: Intelligent Infrastructure Enhancements

Recognize the scope of Oracle Database 11gs AWR Baselines feature, which includes baseline template creation options and baseline views.

Recognize the steps for creating an AWR Baseline and using it to define alert thresholds.

Recognize the benefits of the Automatic Maintenance Tasks feature for statistics collection, segment advisor, and Automatic SQL Tuning, and identify how to control such tasks.

Recognize the steps for calibrating I/O resources in Oracle Database 11g.

Recognize how to manage resources and streamline schedules using the Resource Manager and lightweight jobs.

Identify the steps for creating and running lightweight scheduler jobs.

Calibrate I/O Resources in Oracle Database 11g.

Back to List

Oracle Database 11g: Performance Enhancements

Overview/Description
identify the scope and capabilities of Oracle Database 11gs performance-enhancing tools, such as those for memory management, performance analysis, and statistics gathering.

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

95 Minutes

Objectives :

Oracle Database 11g: Performance Enhancements

Recognize the different ways to use Automatic Database Diagnostic Monitor to analyze Oracle Real Application Clusters (RACs) and report on issues affecting the entire database as well as individual instances.

Identify the benefits of Oracle Database 11gs Automatic Memory Management system.

Identify the concepts and methods employed in Oracle database 11g for gathering and publishing various kinds of statistics.

Identify the steps for observing memory distribution patterns using Automatic Memory Management and also for testing various statistic gatherings on a particular table.

Use Automatic Memory Management to observe memory distribution patterns.

Back to List

Oracle Database 11g: Partitioning and Storage-Related Enhancements

Overview/Description
identify the benefits of Oracle Database 11gs partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

110 Minutes

Objectives :

Oracle Database 11g: Partitioning and Storage-Related Enhancements

Identify the steps for employing Oracle Databases new partitioning scheme to perform interval partitioning.

Recognize the steps for performing system and virtual column-based partitioning, using Oracle Database 11gs new partitioning scheme.

Identify the steps for performing reference partitioning, using Oracle Database 11gs new partitioning scheme.

Recognize the steps for performing extended composite partitioning, using Oracle Database 11gs new partitioning scheme, and for compressing tables.

Recognize the steps for using SQL Access Advisor to help you to decide which partitions, indexes, materialized views, and materialized view logs you need to optimize your databases workload.

Use the SQL Access Advisor to get partitioning recommendations.

Back to List

Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner

Overview/Description
identify ways of using Oracle Database 11gs enhanced RMAN, Flashback and LogMiner tools to clone databases, create backups and catalogs, archive historical data, and roll back transactions.

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

125 Minutes

Objectives :

Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner

Recognize the ways in which enhancements to RMAN in Oracle Database 11g can help you perform faster and optimized backups.

Identify the steps for duplicating an active Oracle Database 11g database.

Identify the steps for creating and managing archival backups and RMAN catalogs in Oracle Database 11g.

Duplicate an active Oracle Database 11g database.

Recognize the benefits of Flashback Data Archives in Oracle Database 11g for retaining historical data.

Identify the steps for using Flashback Data Archives.

Identify the steps for using the Flashback Transaction Backout and LogMiner features to locate and roll back transactions and user errors in Oracle Database 11g.

Back to List

Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor

Overview/Description
recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor.

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

125 Minutes

Objectives :

Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor

Recognize the scope and capabilities of the Automatic Diagnostic Repository (ADR) feature in Oracle Database 11g.

Identify the tasks that can be performed, using the Support Workbench wizard, to handle critical errors in Oracle Database 11g.

Identify the steps for configuring incident packages and for creating, manipulating, and modifying custom packages.

Identify the steps for dealing with critical errors in Oracle Database 11g, using the Health Monitor and SQL Repair Advisor tools.

Recognize your options for assessing data failures in Oracle Database 11g, using the Data Recovery Advisor.

Identify the steps for getting advice on repairing data failures, executing these repairs using RMAN data repair commands, and setting parameters to detect further corruption.

Repair a down database via Enterprise Manager.

Back to List

Oracle Database 11g: New Security Features

Overview/Description
identify the ways in which Oracle Database has enhanced security, including enhancements to Transparent Data Encryption and password security, and identify the steps for managing all aspects of security.

Target Audience

Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBAs considering upgrading their systems to 11g

Prerequisites

The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration

85 Minutes

Objectives :

Oracle Database 11g: New Security Features

Recognize ways to configure a password file to use case-sensitive passwords and also how to configure security settings in Oracle Database 11g.

Recognize the different types of encryption in Oracle Database 11g, and identify the steps for managing fine-grained access to external network services.

Recognize ways for setting up administrator authentication and managing transparent data encryption and other security settings.

Identify the steps for increasing the security of passwords and implementing tablespace encryption in Oracle Database 11g.

Identify the best approach to take to encrypt a tablespace in Oracle Database 11g.

Back to List

Exam 1Z0-040: Oracle Database 10g: New Features for Administrators Curriculum Outline

Oracle Database 10g: New Installation and Configuration Features

Overview/Description
To discuss the new installation and configuration features of Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
2.25 Hours

Oracle Database 10g: New Installation and Configuration Features

• Identify the products and components of the Oracle 10g grid computing infrastructure
• Identify the installation improvements to Oracle Database 10g
• Identify the key grid and installation features of Oracle 10g and make the necessary installation considerations in a given scenario
• Identify the key upgrades to the Database Configuration Assistant (DBCA) in Oracle 10g
• Identify the key areas of the new Enterprise Manager GUI and use some of its new deployment features
• Use the new features of Enterprise Manager to review database feature usage, manage policies, and modify initialization parameters
• Launch and use the new features of Oracle 10g Enterprise Manager

Back to List

Oracle Database 10g: New Data Loading Features

Overview/Description
To discuss new data loading features in Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
2 Hours

Oracle Database 10g: New Data Loading Features

• Take the preparatory steps for transporting tablespaces from one platform to another in Oracle 10g
• Identify the key processes and file issues associated with Oracle Database 10g Data Pump
• Use the code that allows you to import and export data with Oracle Database 10g Data Pump
• Perform a data-only unload of data in Oracle 10g
• Populate an external table and project column data in Oracle Database 10g
• Perform an external table population in Oracle Database 10g in a given scenario

Back to List

Oracle Database 10g: New Automatic Management and Management Infrastructure Features

Overview/Description
To identify the new automatic management and management infrastructure features of Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
3.25 Hours

Oracle Database 10g: New Automatic Management and Management Infrastructure Features

• Work with the Automatic Database Diagnostic Monitor (ADDM) in Oracle Database 10g
• Perform the tasks and calculations associated with the configuration and management of Automatic Shared Memory Management in Oracle Database 10g
• View Automatic Database Diagnostic Monitor (ADDM) findings and manage shared memory in Oracle Database 10g in a given scenario
• Perform the key tasks associated with Oracle Database 10gs new statistics collection feature
• Use the appropriate code to lock and view automatically gathered statistics in Oracle Database 10g
• Identify the key components and concepts of Oracle 10gs new Automatic Workload Repository (AWR) feature
• Set AWR statistics capturing and snapshot purging in Oracle Database 10g
• Perform the tasks in a typical advisor tuning session in Oracle Database 10g
• Manually invoke the ADDM advisor to analyze an Oracle system in a given scenario
• Identify the alert process and alert types in Oracle Database 10g
• Set alerts and view metrics and server alert information in Oracle Database 10g
• Change an alert threshold and edit a notification rule in a given scenario in Oracle Database 10g

Back to List

Oracle Database 10g: New Resources, Scheduling and Task-Management Features

Overview/Description
To identify the new resource, scheduling, and task-management features of Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
3.25 Hours

Oracle Database 10g: New Resource, Scheduling, and Task-Management Features

• Use the new resource-plan timeout and session mapping features of Resource Manager in Oracle Database 10g
• Use the new group switching and CPU allocation features of Resource Manager in Oracle Database 10g
• Set idle time outs for a consumer group and create a mapping between a consumer group and a session attribute in Oracle Database 10g
• Define the components of the Oracle Database 10g Scheduler and identify the SQL used to assign privileges to them
• Create jobs, programs, and schedules in Oracle Database 10g
• Create job classes, windows, and job priorities in Oracle Database 10g
• Create a job class, job, and window in Oracle 10g Enterprise Manager in a given scenario
• Use the GUI and code-based tools to manage Scheduler components in Oracle Database 10g
• Use the tools to manage Scheduler component attributes and global attributes in Oracle Database 10g
• View information about jobs and purge jobs in Oracle Database 10g
• Manage and view Scheduler components in Oracle Database 10g in a given scenario

Back to List

Oracle Database 10g: New Space Management Features

Overview/Description
To identify the new space management features of Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
2.25 Hours

Oracle Database 10g: New Space Management Features

• Identify the new features of undo management and their functions in Oracle Database 10g
• Set tablespace space usage thresholds in Oracle Database 10g
• Set a space usage threshold for a tablespace in a given scenario in Oracle Database 10g
• Use the appropriate code to define sorted hash clusters in Oracle Database 10g
• Perform a segment shrink operation in Oracle Database 10g
• Access the tools used to optimize segment space in Oracle Database 10g
• Perform a segment shrink operation in a given scenario in Oracle Database 10g

Back to List

Oracle Database 10g: New Storage Features

Overview/Description
To identify the new storage features of Oracle Database 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
3 Hours

Oracle Database 10g: New Storage Features

• Use the tools to manage the SYSAUX tablespace and its occupants in Oracle Database 10g
• Rename a tablespace and define a default permanent tablespace in Oracle Database 10g
• Identify the code used to copy and transfer database files in Oracle Database 10g
• Move a tablespace occupant and edit the tablespace properties in a given scenario in Oracle Database 10g using EM
• Differentiate the components of the new Automatic Storage Management (ASM) architecture in Oracle Database 10g
• Identify the processes associated with ASM instance administration, startup, and shutdown
• Follow the GUI-based and code-based steps to administer disk groups in Oracle Database 10g
• Use the appropriate commands and views to administer Automatic Storage Management (ASM) files and templates in Oracle Database 10g
• Create a disk group and add a disk in Oracle Database 10g in a given scenario

Back to List

Oracle Database 10g: New Tuning, Performance-Monitoring and Analysis Features

Overview/Description
To use Oracle 10gs new tuning, performance-monitoring, and analysis features

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
3 Hours

Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features

• Identify how to use the new optimizer statistics in Oracle Database 10g
• Use the SQL Tuning Advisor in a given scenario
• Use the SQL Access Advisor in a given scenario
• Recognize how Oracle 10g database performance is monitored
• Use the SQL Tuning Advisor and the SQL Access Advisor in a given scenario
• Use MERGE and partitioned outer joins in a given scenario
• Use group mapping in interrow calculations in a given scenario
• Recognize materialized view operations in a given scenario
• Use analytical calculations and fast refresh capabilities in a given scenario

Back to List

Oracle Database 10g: New Backup and Recovery Features

Overview/Description
To use Oracle 10gs new backup and recovery features

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
2.25 Hours

Oracle Database 10g: New Backup and Recovery Features

• Recognize flash backup and recovery in Oracle Database 10g
• Use new features associated with incremental backups in a given scenario
• Maintain backups in Oracle Database 10g in a given scenario
• Recognize simplified recovery, database dropping, and enhanced RMAN scripts
• Implement backup and recovery with Oracle Database 10g in a given scenario
• Create and manage compressed backups in a given scenario
• Manage backup operations in a given scenario

Back to List

Oracle Database 10g: Using Flashback

Overview/Description
To recognize Oracle 10gs Flashback technology and use Flashback features

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
2.25 Hours

Oracle Database 10g: Using Flashback

• Recognize flashback technology and its features
• Use Flashback Database in a given scenario
• Use Enterprise Manager to flash back a dropped table in a given scenario
• Use Flashback Database and Flashback Drop in a given scenario
• Use Flashback Versions Query and Flashback Transaction Query in a given scenario
• Use Flashback Table in a given scenario
• Use Flashback Versions Query and Flashback Table in a given scenario

Back to List

Oracle Database 10g: New Features in Security and Software Maintenance

Overview/Description
To use the new security and software upgrade features in Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
2.75 Hours

Oracle Database 10g: New Features in Security and Software Maintenance

• Create a column-level VPD policy in a given scenario
• Identify the policy type to use in a given scenario
• Create a fine-grained auditing policy in a given scenario
• Create a column-level VPD policy and a fine-grained auditing policy in a given scenario
• Point out why a column-level VPD policy and a fine-grained auditing policy are incorrect in a given scenario
• Use the Database Upgrade Assistant to perform a database upgrade to Oracle Database 10g in a given scenario
• Identify the order of the principal tasks required to manually upgrade a database to Oracle Database 10g
• Upgrade a database to Oracle Database 10g using Database Upgrade Assistant in a given scenario

Back to List

Oracle Database 10g: New Features in VLDB Support

Overview/Description
To use Oracle 10gs new VLDB support features

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
2 Hours

Oracle Database 10g: New Features in VLDB Support

• Use bigfile tablespaces in Oracle Database 10g in a given scenario
• Use Enterprise Manager to create and manage temporary tablespace groups in a given scenario
• Use Enterprise Manager to create and manage partitions in a given scenario
• Use Enterprise Manager to create VLDB objects in a given scenario
• Recognize range, hash, and bitmap index enhancements in Oracle Database 10g
• Recognize how to manage range, hash, and bitmap indexes in a given scenario

Back to List

Oracle Database 10g: Miscellaneous New Features

Overview/Description
To recognize how various new features are used in Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration
2.25 Hours

Oracle Database 10g: Miscellaneous New Features

• Recognize the new transaction and statistics monitoring enhancements in Oracle Database 10g
• Recognize how tracing, statistical information gathering, and client and shared server configuration is achieved in multi-tier environments in a given scenario
• Enable tracing and statistics aggregation in a given scenario
• Recognize the enhancements to resumable statements, buffer cache management, and large objects in Oracle Database 10g
• Recognize regular expression support and linguistic sorting in Oracle Database 10g
• Recognize the new e-mail, compression, LogMiner, and quotation mark enhancements in Oracle Database 10g
• Recognize regular expression, sorting, and e-mail usage in a given scenario

Back to List

Exam 1Z0-054: Oracle Database 11g: Performance Tuning Curriculum Outline

Oracle Database 11g: Performance Tuning Methodology and Tools

Overview/Description
Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool – Enterprise Manager – can be used to monitor an Oracle database using the many performance-related pages it provides via a user-friendly graphical user interface. This course provides an introduction to performance tuning methodologies, effective tuning goals, and the types of performance data that can be gathered by diagnostic tools available in Oracle Database 11g. It also demonstrates how to use Time Model and Enterprise Manager to diagnose performance issues, and discusses using the various dynamic performance views (V$ views) to perform statistical analysis when diagnosing problems. The use of alert logs, user trace files, and wait events analysis are also explored in this introduction to performance tuning. This course helps to prepare you for the Oracle Database 11g: Performance Tuning exam which counts towards the Oracle Database 11g Performance Tuning Certified Expert designation.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g: Performance Tuning Methodology and Tools

Identify the steps in both the general and Oracle tuning methodologies

Identify the characteristics of effective tuning goals

Recognize the three types of performance data gathered by diagnostic tools

Recognize the factors to consider when tuning DB time

Recognize how to use the time model to diagnose performance issues

Recognize how to view diagnostic information in Enterprise Manager

Recognize how you can use dynamic performance to view statistics

Recognize how to use dynamic performance views to display wait events

Recognize how to use Alert Logs to perform tuning

Identify ways to generate user trace files

View diagnostic information in a given scenario

Course Number:
od_odpt_a01_it_enus

Back to List

Oracle Database 11g: Using AWR and Defining Problems

Overview/Description
Automatic Workload Repository (AWR) is the infrastructure that provides services to Oracle Database 11g components that collect, maintain, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual AWR reports as well as AWR compares period reports. It discusses the identification of performance issues, setting the tuning priorities, how to tune depending on the particular application life cycle phase, and the steps involved in implementing migration, upgrade, and environment changes. The course also delves into the area of interpreting tuning diagnostics using Statspack – a set of scripts and PL/SQL packages that allow you to capture point-in-time performance data. It explains how to capture and manage Statspack snapshots and the generation and usage of Statspack reports for diagnostic analysis.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g: Using AWR and Defining Problems

Identify the features of the AWR

Recognize how to create and manage AWR snapshots

Recognize how to run an AWR report

Recognize how to generate a Compare Periods report

Generate an AWR report in a given scenario

Generate a Compare Periods report in a given scenario

Recognize how to define problems

Recognize how to set tuning priorities

Identify factors to consider when tuning for different application life cycle phases

Identify the seven steps for implementing migration, upgrade, and environment changes

Recognize how business requirements affect performance

Identify how to file a performance service request

Recognize how to install Statspack

Recognize how to capture and manage Statspack snapshots

Recognize how to read Statspack performance reports

Course Number:
od_odpt_a02_it_enus

Back to List

Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools, and Services

Overview/Description
Metrics, alerts, baselines, and thresholds are monitoring objects that can be used to monitor and manage the performance tuning of an Oracle Database 11g environment. Automatic Workload Repository (AWR) based tools can be used to tune automatic maintenance tasks and generate and read ADDM and ASH reports. This course demonstrates how to create static and repeating baselines, compute baseline statistics, define alert thresholds, and generate ADDM and ASH reports. In Oracle Database 11g you can configure, manage, and implement services to work with client applications using Database Resource Manager and the Scheduler. This course discusses the use of services for monitoring applications and demonstrates how to set performance-metric thresholds on services. It also explains how to configure services aggregation and tracing.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.5

Lesson Objectives

Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools, and Services

Identify the features of metrics, alerts, and baselines

Recognize how to view metric history information, metric details, and histogram views

Recognize how to receive an alert when a specified threshold is exceeded

Identify the features of AWR baselines

Recognize how to create AWR baselines

Recognize how to manage AWR baselines

Recognize how to manage thresholds

Create and manage AWR baselines and thresholds

Recognize how to tune automatic maintenance tasks

Recognize how to generate and read ADDM reports

Identify the features of the Active Session History

Recognize how to generate ASH reports

Recognize how to configure and manage services

Recognize how to use services with client applications, the Database Resource Manager, and the Scheduler

Recognize how to set performance-metric thresholds on services

Recognize how to configure services aggregation and tracing

Course Number:
od_odpt_a03_it_enus

Back to List

Oracle Database 11g: Problem SQL Statements and Oracle Optimizer

Overview/Description
Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command, SQL*Plus AUTOTRACE command options, and the V$SQL_PLAN view. The functions of the Optimizer and how to influence and control the optimizers behavior is discussed in detail, including the various query access paths that can be used, when to use different join methods and sort operations, how to manage and maintain indexes, and how to reorganize tables to optimize the processing of SQL statements.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.5

Lesson Objectives

Oracle Database 11g: Problem SQL Statements and Oracle Optimizer

Match each phase in SQL statement processing with its features

Identify the steps in DML processing

Identify the operations performed by the Oracle optimizer

Recognize the features of execution plans

Recognize how to generate and view execution plans

Recognize how to use the SQL*Plus AUTOTRACE command options to view execution plans and statistics

Identify the steps involved in using the SQL Trace facility

Identify the functions of the query optimizer

Recognize how to influence and control the optimizers behavior

Identify the scan types for retrieving data from the database

Recognize how to work with bitmap and B*Tree indexes

Identify when to use different join methods

Identify common sort operations

Recognize how to manage and maintain indexes

Recognize how to reorganize tables

Use AUTOTRACE to analyze statistics and execution plans in a given scenario

Course Number:
od_odpt_a04_it_enus

Back to List

Oracle Database 11g: SQL Performance Management and Database Replay

Overview/Description
Database Replay allows you to test the impact of a system change by replaying a real-world workload on a test system before it is exposed to a production system. This course demonstrates how to use Database Replay to capture and replay workloads to test the impact of a system change. It also explains how to use SQL Performance Analyzer to ascertain performance gains following a database change and to test the impact of proposed changes. Maintaining SQL performance by managing changes to optimizer statistics, using Automatic SQL Tuning to automate the SQL tuning process, and setting up SQL plan management are also covered.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.5

Lesson Objectives

Oracle Database 11g: SQL Performance Management and Database Replay

Recognize the steps in the SQL Performance Analyzer process

Recognize how to use the SQL Performance Analyzer with PL/SQL

Recognize how to manage changes to optimizer statistics to maintain SQL performance

Recognize how to use Automatic SQL Tuning to automate the SQL tuning process

Recognize how to set up SQL plan management

Seed SQL plan baselines from SQL Performance Analyzer in a given scenario

Recognize the steps in using Database Replay to test the impact of a system change

Recognize how to use the Enterprise Manager to capture workloads

Recognize how to replay workloads using the Enterprise Manager

Recognize how to use PL/SQL to capture and replay workloads

Course Number:
od_odpt_a05_it_enus

Back to List

Oracle Database 11g: Shared Pool and Buffer Cache Tuning

Overview/Description
The buffer cache is an extremely important component for the performance, scalability, and reliability of the database. This course demonstrates how to identify the symptoms that indicate a buffer cache problem and how to use the various methods available to resolve common performance issues related to the buffer cache. It also discusses the sizing of the buffer cache and using views to analyze the buffer cache, and briefly covers multiple pool management. The fundamental purpose of the shared pool is to serve as a metadata cache. This course explains how to diagnose and resolve hard and soft-parsing problems and shared pool fragmentation issues. It also discusses various methods of tuning the shared pool, including sizing the shared pool, sizing the reserved area of the shared pool, keeping objects in the shared pool, and managing the results cache.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g: Shared Pool and Buffer Cache Tuning

Recognize the features of the shared pool

Identify the role of AWR and Statspack reports indicators when diagnosing problems

Recognize how to avoid hard parses

Recognize how to avoid soft parses

Recognize how to reserve space in the shared pool

Recognize how to manage the results cache

Recognize the features of the buffer cache architecture

Identify the symptoms that indicate a buffer cache problem

Identify methods to resolve common performance issues related to the buffer cache

Recognize how to properly size the buffer cache

Manage the buffer cache in given scenarios

Course Number:
od_odpt_a06_it_enus

Back to List

Oracle Database 11g: Tuning PGA, Temporary Space, and AMM

Overview/Description
Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data generated explicitly by the user and implicitly by the system. This course explains how to diagnose PGA memory and temporary tablespace issues and demonstrates how to size the PGA memory and manage temporary tablespaces. In addition, in Oracle 11g, Automatic Shared Memory Management (ASMM) uses dynamic System Global Area (SGA) and memory advisors to automatically adapt to workload changes. Automatic Memory Management (AMM) automates the sizing of PGA and SGA according to your workload. This course demonstrates the methods for enabling and configuring ASMM and AMM using Enterprise Manager, memory advisors, SQL, and V-dollar views for monitoring memory management.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g: Tuning PGA, Temporary Space, and AMM

Identify how to diagnose PGA memory issues

Recognize how to size the PGA memory

Recognize how to manage temporary tablespaces

Identify the components of Automatic Shared Memory Management

Recognize how to configure Automatic Shared Memory Management (ASMM)

Recognize how to configure Automatic Memory Management

Configure memory in a given scenario

Tune PGA memory in a given scenario

Create a temporary tablespace group in a given scenario

Course Number:
od_odpt_a07_it_enus

Back to List

Oracle Database 11g: Segment Space, I/O, and Performance Tuning

Overview/Description
Oracle Database 11g provides various methods for tuning segment space usage and input/output (I/O). This course explains how to use Automatic Segment Space Management (ASSM) to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage Management (ASM) capabilities save you time by automating manual storage and thereby increasing your ability to manage larger databases (and more of them) with increased efficiency. This course discusses the implementation and tuning of ASM using a variety of Redundant Array of Independent Disks (RAID) solutions, depending on the business requirements of the organization. This course also explores the performance tuning methodology and identifies industry-recognized best practices for performance tuning.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.5

Lesson Objectives

Oracle Database 11g: Segment Space, I/O, and Performance Tuning

Identify the characteristics of extents

Identify the characteristics of blocks

Identify the characteristics of Automatic Segment Space Management (ASSM)

Recognize how to manage row migration and chaining

Recognize how to shrink segments using SQL or the Enterprise Manager

Recognize how to use table compression

Identify the characteristics of I/O

Recognize how to tune I/O effectively

Identify the characteristics of RAID

Recognize how to manage and monitor ASM

Recognize best practices for performance tuning

Tune I/O in a given scenario

View I/O statistics in a given scenario

Course Number:
od_odpt_a08_it_enus

Back to List