Oracle Database 11g New Features | Oracle Press

Oracle Database 11g New Features

Authors: Robert Freeman

Published: November 2007

eISBN: 9780071595780 0071595783 | ISBN: 9780071496612

Contents

Foreword

Acknowledgments

Introduction

1 Oracle Database 11g Getting Started

Installing Oracle Database 11g

The Database Configuration Assistant

Upgrading to Oracle Database 11g

Saving Time When Upgrading

Supported Upgrade Paths

Supported Upgrade Methods

Upgrade with DBUA

Manual Upgrades

Using Export/Import for Upgrades and Rollback

Upgrade Using Data Copying

Oracle Parameter Changes

New Parameters

Deprecated Parameters

Obsolete Parameters

Undo_Management Parameter Madness

Oracle Dictionary View Changes

End of Line

2 Oracle Database New Management Features

ASM-Related Changes and New Features

New ASM-Related Documentation

ASM Disk Group Attributes

ASM Fast Disk Resync

ASM Compatibility Settings

ASM Preferred Mirror Read

ASM Rolling Upgrades

ASM Support for Variable Allocation Unit Sizes

New SYSASM Role

New asmcmd Commands

Automatic Memory Management

Overview of Automatic Memory Management

New Memory Advisor Functionality and Views

How Is Oracle Managing My Memory?

Automatic Memory Management and OEM

Converting to Automatic Memory Management

ADDM New Features

ADDM New Views

ADDM Now RAC-Aware

Managing ADDM Through DBMS_ADDM

Finding Classifications

Directives

AWR New Features

Default Retention of AWR Snapshots Changed

AWR Baseline New Features

Adaptive Metric Thresholds

Scheduler AutoTask Automated Maintenance Tasks

AutoTask Architecture

AutoTask Dictionary Views

Managing AutoTask Tasks via OEM

Managing AutoTask Tasks Manually

AutoTask Maintenance Windows

Parameter File Management Changes and New Features

Read/Write Error Handling of SPFILES

Easier Conversion to the Use of SPFILES

Users Are Prevented from Setting Invalid Values in SPFILES

Resource Manager Changes and New Features

IO Calibration

Default Maintenance Plan

Built-In Resource Plans

Resource Manager Statistics in AWR

Resource Manager Plan Directive New Features

Finer-Grained Dependencies

DDL WAIT Option Now Default

New Add Column Functionality

End of Line

3 Oracle Database New Availability and Recovery Features

Fault Diagnosability Infrastructure

The Automatic Diagnostic Repository (ADR)

The Alert Log

Trace, Dump, and Core Files

The Support Workbench

RMAN New Features

Interfile Backup Parallelism

Faster Backup Compression

Active Database Duplication

Improved Handling of Long-Term Backups

Backup Failover for Archived Redo Logs

Archived Redo Log Deletion Policy Enhancements

Recovery Catalog Enhancements

Undo Backup Optimization

Block Media Recovery Performance Improved

Other RMAN New Features

Oracle Flashback-Related New Features

Oracle Flashback Transaction Backout

Oracle Flashback Data Archives

Oracle Standby Database New Features

Lost-Write Detection

Compression of Archived Redo Logs

Real-Time Query Capabilities from a Physical Standby Database

Snapshot Databases

Oracle Data Pump New Features

Exp Utility Deprecated

Compression of Dump File Sets

Data Pump Encryption Enhancements

Data Pump Data Remapping (Obfuscation)

Data Pump Rename Table

Data Pump and Partitioned Tables

Overwrite Dump Files

Data Pump Data_Options Parameter

The Transportable Parameter

End of Line

4 Oracle Database Advisors

The Data Recovery Advisor

The SQL Repair Advisor

The SQL Access Advisor

The Streams Performance Advisor

Oracle Database 10g Database Advisor Views

End of Line

5 Oracle Database Change Management

Database Replay

Using Oracle Database Replay

Database Replay—Overview

Database Replay Workload Support and Limitations

Database Replay—Capture Workload

Database Replay—PreProcess the Captured Workload

Database Replay—Replay Workload

The SQL Performance Analyzer

Overview of SQL Performance Analyzer

SQL Performance Analyzer via OEM

SQL Performance Analyzer via PL/SQL

End of Line

6 Oracle Database 11g Security

Auditing

Password-Related Features

Password Settings and the Default Profile

Password Complexity

Password Case Sensitivity

Hacking Prevention with Failed Logon Delays

Password Hashing Changes

Default Password Use

Fine-Grained Access Control on Network Services

Create the ACL and Define the Associated Privileges

Assign the ACL to Network Hosts

ACL-Related Data Dictionary Views

Tablespace Encryption

Overview of Oracle Tablespace Encryption

Preparing the Database for Tablespace Encryption

Creating Encrypted Tablespaces

Encryption and Database Performance

TDE and Log Miner, Logical Standby, and Streams

Oracle SECUREFILE LOBS

End of Line

7 Oracle Database BI and Data Warehousing New Features

Partitioning

Interval Partitioning

Extended Composite Partitioning

Reference Partitioning

System Partitioning

System-Managed Domain Indexes

Virtual Columns

About Virtual Columns

Creating Tables with Virtual Columns

Partitioning Tables with Virtual Columns

Data Pump Single-Partition Imports

Materialized Views and Query Rewrite

Online Redefinition for Tables with Materialized View Logs

Query Rewrite During Refresh

Partition Change Tracking Refresh for Union All Mviews

New and Enhanced Materialized View Catalog Views

Query Rewrite Enhancements

The Pivot and Unpivot Clauses

The Pivot Clause

The Unpivot Clause

Table Compression

End of Line

8 Application Development

SQL*Plus

New set Commands

Fast Application Notification Events in an RAC Database

Online Application Maintenance and Upgrade

New lock table Parameter

Fewer Exclusive Locks Taken During Online Operations

Invisible Indexes

SQL

Read-Only Tables

SQL Query Result Cache

Client Side Result Cache

Regular Expression Enhancements

Named and Mixed Notation from SQL

PL/SQL

Create Triggers as Enabled or Disabled

Create Trigger Follows Clause

Compound Triggers

Inlining

SIMPLE_INTEGER Datatype

PL/SQL Function Result Cache

Dynamic SQL

Dynamic SQL and REF Cursors

PLW 06009 Warning

PL/SQL Sequence Enhancement

PL/SQL Continue Statement

End of Line

9 Performance Tuning

Enhanced Oracle Process Monitoring

Statistics

Pending and Published Statistics

Recovering Previous Statistics

Extended Statistics

PL/SQL Native Compilation

SQL Plan Management

SQL Plan Management Overview

Plan Capture

Use of SQL Plan Baselines

Querying SQL Plan Baselines

Evolving SQL Plan Baselines

Managing SQL Plan Baselines

Automatic SQL Tuning

Overview of Automatic SQL Tuning

Automatic SQL Tuning with OEM

Manage Automatic SQL Tuning Manually

Manual Creation and Use of SQL Tuning Sets

Create the Task

Create the SQL Tuning Set

Load the SQL Tuning Set

Link the SQL Tuning Set and the Task

Set Any Task Parameters

Execute the Task

Review the Results

Intelligent Cursor Sharing (Bind-Aware Peeking)

About Bind-Aware Peeking

Bind-Aware Peeking Views

Starting a System with Bind-Aware Peeking

Temporary Tablespace Features

Temporary Tablespace Shrink

The DBA_TEMP_FREE_SPACE View

Real-Time SQL Monitoring

Real-Time SQL Monitoring Overview

Real-Time SQL Monitoring Views

Real-Time SQL Monitoring Report

Control Real-Time SQL Monitoring

Control the Use of OEM Management Packs

End of Line

10 Other New Features and Enhancements

Real Application Clusters

OCI Runtime Connection Load Balancing

Using XA Transactions with RAC

RAC Configuration Assistants

Network Configuration Assistant (NetCA)

Database Rolling Upgrade

Parallel Execution Honors Service Placement

Direct NFS

XMLDB New Features

Binary XML Storage

Partitioning Support for XMP

XQuery Enhancements

Database Native Web Services

XML DB Repository Enhancements

XML Developers Kit

Java

Oracle JVM-Related Features

Enhancements to Existing Utilities

The ojvmtc Utility

JDBC 4.0 Support

JDK Support in Oracle Database 11g

New Oracle Supplied Packages and Procedures

A: Arup’s Top Ten Features

Arup’s Top Feature # 1: Database Replay

Arup’s Top Feature # 2: SQL Performance Analyzer

Arup’s Top Feature # 3: Partitioning

Arup’s Top Feature # 4: Transparent Tablespace Encryption

Arup’s Top Feature # 5: Flashback Data Archive

Arup’s Top Feature # 6: SQL Plan Management

Arup’s Top Feature # 7: Private Statistics

Arup’s Top Feature # 8: More Concurrency

Arup’s Top Feature # 9: Result Cache

Arup’s Top Feature # 10: Better-Quality PL/SQL Code

Index