You are previewing OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050).
O'Reilly logo
OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050)

Book Description

A Fully Integrated Study System for OCP Exam 1Z0-050

Prepare for the Oracle Certified Professional Oracle Database 11g New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-050, including:

• Installation and upgrades

• Partitioning and storage

• Intelligent infrastructure

• Diagnostics and fault management

• Performance

• Oracle Recovery Manager and Oracle Flashback

• Security

• Oracle SQL Performance Analyzer

• SQL plan management

• Automatic SQL tuning

On the CD-ROM:

• One full practice exam that simulates the actual OCP exam

• Detailed answers and explanations

• Score report performance assessment tool

• Complete electronic book

• Bonus exam available free with online registration

The ebook version does not provide access to the companion files.

Table of Contents

  1. Cover 
  2. Copyright
  3. Dedication
  4. About the Author
  5. Contents at a Glance
  6. Contents 
  7. Acknowledgments
  8. Introduction
  9. 1 Installing, Upgrading, and Change Management
    1. Installing Oracle Database 11g
      1. Changes in the Optimal Flexible Architecture
      2. Automatic Diagnostic Repository
      3. Changes in the Installation Options
      4. New Database Components
      5. Role and Privilege Changes
      6. An Oracle Database 11g Installation
    2. New Features in Database Creation
      1. Summary of New Initialization Parameters
      2. DBCA Enhancements
      3. Using the DBCA to Create a Database
    3. Upgrading to Oracle Database 11g
      1. Moving Data as Part of the Upgrade
      2. New Privileges for Storage Management
      3. Upgrading to Oracle Database 11g
      4. Exercise 1-1 Scripts to Run for Upgrading a Database
    4. Real Application Testing
      1. Database Replay
      2. Exercise 1-2 Procedure for Capturing and Replaying a Database Workload
      3. The SQL Performance Analyzer
      4. Exercise 1-3 Testing SQL Performance Following a Database Upgrade
    5. Two-Minute Drill
      1. Self Test
      2. Lab Question
      3. Self Test Answers
      4. Lab Answer
  10. 2 Diagnosing and Resolving Problems
    1. Automatic Diagnostic Repository
      1. The Structure of the ADR
      2. ADRCI
    2. Incidents and Problems
      1. Incident Packaging Service
      2. Exercise 2-1 Creating an Incident Package with ADRCI
    3. Support Workbench
      1. Viewing Critical Error Alerts
      2. Examining Problem Details
      3. Collecting Additional Diagnostic Data
      4. Creating a Service Request
      5. Packaging and Uploading Diagnostic Data
      6. Tracking the Service Request
      7. Implementing Repairs
      8. Closing Incidents
      9. Generating a User-Created Problem
      10. Viewing the Alert Log
    4. Health Monitor
      1. Running a Health Check
      2. Exercise 2-2 Running a Health Check with Input Parameters
      3. Viewing the Health Monitor Reports
    5. SQL Repair Advisor
      1. Using the Support Workbench
      2. Using the DBMS_SQLDIAG Package
      3. Exercise 2-3 Exporting a SQL Patch to Another Database
    6. Data Recovery Advisor
      1. Repair Options
      2. Using RMAN to Manage the Data Recovery Advisor
      3. Proactive Checks
      4. Managing the DRA with Database Control
      5. New Parameter to Detect Database Corruption
      6. Viewing the Health Monitor Reports
    7. Two-Minute Drill
      1. Self Test
      2. Lab Question
      3. Self Test Answers
      4. Lab Answer
  11. 3 Intelligent Infrastructure and Database Security
    1. Enhancements in AWR Baselines
      1. Managing Baseline Templates
      2. Renaming a Baseline
      3. Setting AWR Baseline Metric Thresholds
      4. Moving Window AWR Baselines
      5. Managing the New Baseline Features
    2. Controlling Automated Maintenance Tasks
      1. Predefined Maintenance Windows
      2. Managing the Automatic Maintenance Tasks
      3. Implementing Automatic Maintenance Tasks
      4. Configuring Resource Allocation for Automatic Tasks
      5. I/O Calibration
      6. Exercise 3-1 Calibrating I/O Resources
    3. Database Resource Manager New Features
      1. Per Session I/O Limits
      2. Pre-Created Mixed Workload Resource Plan
    4. Using New Oracle Scheduler Features
      1. Lightweight Jobs
      2. Exercise 3-2 Creating an Array of Regular Scheduler Jobs
      3. Remote External Jobs
      4. Scheduler Support for Data Guard
    5. Security Enhancements
      1. Secure Password Support
      2. Configuring Fine-Grained Access to Network Services
      3. Encrypting Tablespaces
      4. Creating the Oracle Wallet
      5. Creating an Encrypted Tablespace
      6. Restrictions on Tablespace Encryption
    6. Two-Minute Drill
      1. Self Test
      2. Lab Question
      3. Self Test Answers
      4. Lab Answer
  12. 4 Automatic SQL Tuning and SQL Plan Management
    1. Automatic SQL Tuning Advisor
      1. SQL Profiles
      2. Limitations
      3. The Automatic SQL Tuning Process
      4. Exercise 4-1 Using Enterprise Manager to Access the SQL Tuning Advisor
      5. Interpreting Automatic SQL Tuning Reports
      6. Data Dictionary Views
    2. SQL Plan Management
      1. SQL Plan Baselines
      2. Capturing SQL Plan Baselines
      3. Fixed SQL Plan Baselines
      4. SQL Plan Baseline Attributes
      5. Managing SQL Plan Baselines
      6. The SQL Management Base
      7. Managing SPM with the Enterprise Manager
    3. SQL Access Advisor Enhancements
      1. New Procedures
      2. Partitioning Recommendations
      3. Publish Points
      4. Running a SQL Access Advisor Job Using PL/SQL
      5. Using Enterprise Manager
    4. Using the Cursor Cache to Get SQL Access Advisor
    5. Two-Minute Drill
      1. Self Test
      2. Lab Question
      3. Self Test Answers
      4. Lab Answer
  13. 5 Automatic Storage Management and Partitioning Enhancements
    1. Automatic Storage Management New Features
      1. ASM Architecture
      2. ASM Fast Mirror Resync
      3. ASM Preferred Mirror Read
      4. ASM Scalability and Performance Enhancements
      5. New SYSASM Privilege
      6. ASM Compatibility
      7. Changing ASM Disk Group Attributes
      8. New Manageability Options for Commands
      9. Exercise 5-1 Using the md_backup and md_restore Commands
    2. Partitioning Enhancements
      1. Interval Partitioning
      2. System Partitioning
      3. Virtual Column-Based Partitioning
      4. Reference Partitioning
      5. Composite Partitioning Enhancements
    3. Two-Minute Drill
      1. Self Test
      2. Lab Question
      3. Self Test Answers
      4. Lab Answer
  14. 6 Performance Enhancements
    1. ADDM Enhancements
      1. ADDM for Real Application Clusters
      2. New DBMS_ADDM Package
    2. Automatic Memory Management
      1. SGA, PGA, and the MEMORY_TARGET Parameter
      2. Exercise 6-1 Using Automatic Memory Management
      3. Monitoring Automatic Memory Management
      4. DBCA and Automatic Memory Management
    3. Enhancements in Optimizer Statistics Collection
      1. Statistics Preferences
      2. Partitioned Tables and Incremental Statistics
      3. New Sampling Technique
      4. Deferred Statistics Publishing
      5. Extended Statistics
    4. Result Cache
      1. Result Cache Memory Pool
      2. Managing the Result Cache
      3. Caching SQL Results with a Result_Cache Hint
      4. Using the DBMS_RESULT_CACHE Package
      5. Using Dynamic Performance Views
      6. The SQL Query Result Cache
      7. The PL/SQL Function Result Cache
      8. The Client Query Result cache
    5. Adaptive Cursor Sharing
      1. How Adaptive Cursor Sharing Works
      2. Monitoring Adaptive Cursor Sharing
    6. Two-Minute Drill
      1. Self Test
      2. Lab Question
      3. Self Test Answers
      4. Lab Answer
  15. 7 RMAN and Flashback Enhancements
    1. RMAN Enhancements
      1. Active (Network-Based) Database Duplication
      2. Parallel Backup and Restore of Large Files
      3. Archival (Long-Term) Backups
      4. Fast Incremental Backups
      5. Improved Block Media Recovery Performance
      6. New Persistent Configuration Parameters
      7. Backup Failover to Non-Flash Recovery Areas
    2. Recovery Catalog Management
      1. Merging Recovery Catalogs
      2. Virtual Private Catalogs
    3. New Flashback-Related Features
      1. Flashback Data Archive
      2. Flashback Transaction Backout
      3. Exercise 7-1 Using the TRANSACTION_BACKOUT Procedure
    4. Two-Minute Drill
      1. Self Test
      2. Lab Question
      3. Self Test Answers
      4. Lab Answer
  16. 8 Oracle SecureFiles and Miscellaneous New Features
    1. Oracle SecureFiles
      1. Enabling SecureFiles
      2. Capabilities of SecureFiles
      3. Storage Options for SecureFiles
      4. Creating SecureFiles
      5. Managing and Monitoring SecureFiles
      6. Migrating to SecureFiles
    2. Online Enhancements
      1. Locking Enhancements
      2. Minimal Invalidation of Dependent Objects
      3. Creating a Parameter File from Memory
      4. Hot Patching
    3. Miscellaneous New Features
      1. Invisible Indexes
      2. Shrinking Temporary Tablespaces
      3. Tablespace Option for Creating Temporary Tables
      4. PL/SQL and Java Automatic Native Compilation
      5. Exercise 8-1 Setting Up a PL/SQL Program Unit for Native Compilation
      6. OLTP Table Compression
      7. Direct NFS Client
    4. Two-Minute Drill
      1. Self Test
      2. Self Test Answers
      3. Lab Answer
  17. AppendixAbout the CD-ROM
    1. System Requirements
    2. Installing and Running MasterExam
    3. MasterExam
    4. Electronic Book
    5. Help
    6. Removing Installation(s)
    7. Technical Support
    8. LearnKey Technical Support
  18. Glossary
  19. Index