OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050)

Name: OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050)
Brand: McGraw-Hill Companies,Inc.
Price: 93.79 EUR
Availability: OnlineOnly

Sam Alapati(Autor*in)

McGraw-Hill Companies,Inc. (Verlag)

1. Auflage

Erschienen am 28. April 2008

581 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-0-07-164372-6 (ISBN)

93,79 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

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

Systemvoraussetzungen

Als PDF speichern Als Link merken