Oracle Database 11g: New Features for 9i OCPs

Oracle Database 11g: New Features for 9i OCPs

The Oracle Database 11g: New Features for 9i OCPs (1Z0-055) exam is primarily intended for Oracle Database 11g administrators, that have a strong foundation and expertise in the industry’s most advanced database management system.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. This certification helps their companies qualify for the Oracle Database Specialization. This is an upgrade exam. Certification can only be achieved with this exam if the candidate already holds the 9i DBA OCP.

Exam Number:
120 minutes
Associated Certifications:
Oracle Database 11g Administrator Certified Professional

OPN Certified Specialist
Number of
Exam Price:
US $195
Pricing may vary slightly by country or by localized currency. Check Pearson VUE’s website for exact pricing in your country.

Passing score subject to change. View Details
Click Here to Register:


Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy

Recommended Training
Oracle Database 11g New Features for 9i OCPs - Exam Study Guide

OPN Guided Learning Path
Oracle Database 11g Implementation Specialist

Oracle University Training
Oracle Database 11g: New Features for Administrators DBA Release 2 AND
Oracle Database 10g: New Features for Administrators Release 2 OR
Oracle Database 11g: New Features for Oracle 9i DBAs



Additional Information & Resources

Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)

Practice Exams

The exam has been validated against Oracle® Database 11g Release 2 version



Exam Topics

Installation and Upgrade Enhancements

  • Install Oracle Database 11g
  • Upgrade your database to Oracle Database 11g
  • Use online patching

Storage Enhancements

  • Create and maintain bigfile tablespaces
  • Rename tablespaces
  • Create a default permanent tablespace
  • Describe Automatic Storage Management (ASM)
  • Set up initialization parameter files for ASM and database instances
  • Execute SQL commands with ASM file names
  • Use ASMCMD Command-Line Interface
  • Start up and shut down ASM instances
  • Administer ASM disk groups
  • Setup ASM fast mirror resynch
  • Understand scalability and performance enhancements

SQL Performance Analyzer

  • Using SQL Performance Analyzer

SQL Plan Management

  • SQL Plan Baseline Architecture
  • Set up SQL Plan Baseline
  • Using SQL Plan Baseline

Database Replay

  • Overview of Workload Capture and Replay
  • Using Workload capture and replay

Miscellaneous New Features

  • Describe and use the enhanced online table redefinition
  • Use fine-grained auditing for DML statements
  • Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes
  • Use Query Result Cache and PL/SQL Result Cache
  • Create temporary tablespace groups
  • Assign temporary tablespace groups to users
  • Temporary Tablespace Enhancements

Oracle SecureFiles

  • Use Secure File LOBS to store documents with Compression, Encryption, De-duplication, Caching
  • Use SQL and PL/SQL APIs to access Secure File LOBS

SQL Tuning

  • Use the SQL Tuning Advisor
  • SQL Access Advisor Overview
  • Create SQL Access Advisor analysis session using PL/SQL
  • Setup and modify Automatic SQL Tuning
  • Interpret reports generated by Automatic SQL Tuning
  • Use SQL Repair Advisor

Intelligent Infrastructure Enhancements

  • Monitor and maintain the AWR
  • Creating and using AWR baselines
  • Control Automated Maintenance Tasks
  • Using Database Resource Manager New Features
  • Simplify management tasks by using the Scheduler
  • Create a job, program, schedule and window
  • View information about job executions and job instances
  • Monitor and manage server-generated alerts

Performance Enhancements

  • Use Automatic Database Diagnostic Monitor (ADDM)
  • ADDM Enhancements in 11g
  • Use Automatic Shared Memory Management
  • Setup Automatic Memory Management
  • Enhancements in statistics collection

Space Management and Partitioning

  • Reduce space related error conditions through proactively managing tablespace usage
  • Reclaim wasted space from tables and indexes using the segment shrink functionality
  • Use the Segment Advisor
  • Use the Undo Advisor
  • Use Automatic Undo Retention Tuning
  • Implement the new partitioning methods
  • Employ Data Compression

Load and Unload Data

  • Transport tablespaces across different platforms
  • Explain Data Pump architecture
  • Monitor a Data Pump job
  • Use Data Pump export and import
  • Create external tables for data population

Backup and Recovery Enhancements

  • Simplify file management for all recovery-related file
  • Reduce restore time by applying incremental backups to data file image copies
  • Simplify recovery after opening the database with the RESETLOGS option
  • Speed backup times by creating faster incremental backups
  • Minimize load requirements by specifying limits in backup time windows
  • Save storage space through writing compressed backup sets
  • Managing Archive logs

Using Flashback and Logminer

  • Configure and use Flashback Database
  • Recover dropped tables with the Flashback Drop feature
  • Retrieve row history information with the Flashback Versions Query feature
  • Audit or recover FROM transactions with the Flashback Transaction Query feature
  • Recover tables to a point in time with the Flashback Table feature
  • Back-out transactions using Flashback Transaction

Diagnosability Enhancements

  • Setup Automatic Diagnostic Repository
  • Use Support Workbench
  • Run health checks

Using the Data Recovery Advisor

  • Overview of Data Recovery Advisor
  • Repairing data failures using Data Recovery Advisor
  • Perform proactive health check of the database

Security: New Features

  • Configure the password file to use case sensitive passwords
  • Encrypt a tablespace
  • Configure fined grained access to network services



Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.


 E-mail this page  Printer View