Oracle Database 10G New Features

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780072229479 | 0072229470
Cover: Paperback
Copyright: 4/13/2004

Buy New

In Stock Usually Ships in 24-48 Hours

$40.33

Here is an invaluable overview of all the cutting-edge features of Oracle's latest database release, Oracle Database 10g. Includes expert commentary throughout from world-renowned Oracle guru Jonathan Lewis. This is an ideal resource for decision-makers and IT staff preparing for upgrades or migration.

ACKNOWLEDGMENTS

INTRODUCTION

xvii

1 Getting Started

(16)

Welcome to Oracle Database 10g and the "Grid"

(1)

Upgrading to Oracle Database 10g

(3)

The DBUA

(1)

Performing Manual Upgrades

(1)

About the compatible Parameter

(1)

The Database Configuration Assistant

(1)

The SYSAUX Tablespace

(3)

Introducing the SYSAUX Tablespace

(1)

Managing Occupants of the SYSAUX Tablespace

(1)

Automatic Storage Management

(5)

ASM Features

(1)

The ASM Instance

(1)

Setting Up ASM Disks

(1)

Addressing ASM Disks

(1)

ASM and Data Dictionary Views

(2)

Oracle Database 10g Real Application Clusters

(3)

Portable Clusterware

(1)

Rolling Upgrades

(1)

Cluster Ready Services

(1)

Database Assistants

(1)

The gcs_server_processes Parameter

(1)

2 Server Manageability

(22)

Statistics Collection

(5)

Automated Statistics Collection

(1)

Collecting Data Dictionary Statistics

(2)

New DBMS STATS Behaviors

(2)

New Table-Monitoring Behaviors

(1)

Flushing the Buffer Cache

(1)

Database Resource Manager New Features

(3)

Reverting Back to the Original Consumer Group

(1)

Setting the Idle Timeout

(1)

Creating Mappings for Automatic Assignment of Sessions to Consumer Groups

(2)

Scheduler Changes

(6)

Overview of The Scheduler

(1)

Practical Use of The Scheduler

(6)

User-Configurable Default Tablespaces

(1)

Tablespace Groups and Multiple Default Temporary Tablespaces

(3)

Assigning Temporary Tablespaces to Tablespace Groups

(1)

Defining a Tablespace Group as the Default Temporary Tablespace

(1)

Tablespace Group Data Dictionary View

(1)

Renaming Tablespaces

(1)

Dropping Databases

(1)

Larger LOBs

(1)

Automatic Undo Retention

(1)

Shrinking and Compacting Segments Online

(1)

Using New Online Redefinition Features

(1)

3 Performance Tuning

(28)

Improvements to the Wait Interface

(3)

Changes to the V$EVENT_NAME View

(1)

New Wait Information in V$SESSION

(1)

Using V$SESSION to Find Blocking Sessions

(1)

The V$SESSION_WAIT_HISTORY View

(1)

V$SESSION_WAIT_CLASS and V$SYSTEM_WAIT_CLASS Views

(1)

New Histogram Views

(1)

The Database Common Management Infrastructure

(18)

CMI Architecture Overview

(1)

The Automatic Workload Repository

(6)

Server-Based Advisors

(9)

Server-Generated Alerts

(2)

Automatic SGA Tuning

(1)

Self-Tuning Checkpointing

(1)

New Oracle Database 10g Trace Functionality

(1)

Sorted Hash Clusters

(2)

Example of Using a Sorted Hash Cluster

(2)

Shared Server Changes

(2)

Changes to Shared Server Configuration

(1)

MTS Parameters Obsoleted

(1)

The V$DISPATCHER_CONFIG View

(1)

Tracing Shared Server Sessions

(1)

4 Security

(6)

Virtual Private Database New Features

(2)

Column-Level Privacy

(1)

New VPD Policies

(1)

VPD Support for Oracle Parallel Query

(1)

Oracle Database 10g Auditing New Features

(2)

New Columns in DBA_AUDIT_TRAIL

(1)

Fine-Grained Auditing New Features

(1)

Directory (LDAP) Based New Features

(1)

5 Availability and Recoverability

(40)

General Database Recovery Improvements

(3)

Easier Recovery Through the resetlogs Command

(2)

Changes to the alter database archivelog Command

(1)

New and Changed Oracle Database 10g Database Backup Commands

(1)

RMAN Improvements

(15)

Using the Flash Recovery Area

(5)

Using Backup Copies and Fast Recovery

(2)

Use RMAN to Back Up the Current Control File

(1)

Using the catalog and uncatalog Commands

(1)

Dropping a Database in RMAN

(1)

Unregistering a Database in RMAN

(1)

Changes to Incremental Backups

(2)

Recovering Datafiles Not Backed Up

(1)

Automatic Channel Failover

(1)

Compressing RMAN Backups

(1)

Controlling Backup Rates and Duration

(1)

New Flashback Features

(10)

Flashback Database

(5)

Flashback Drop

(2)

Flashback Versions Query

(1)

Configuring Guaranteed Undo Retention

100

(1)

Flashback Transaction Query

101

(1)

Flashback Table

101

(1)

New Transaction Recovery Monitoring Features

102

(1)

New Data Guard Features

103

(10)

Apply Redo in Real Time

104

(1)

The valid_for Attribute

105

(2)

Redo Transmission Enhancements

107

(1)

New Standby Database Parameters

107

(1)

Changes to Standby Database Startups

108

(1)

ARCH Process Writes to Standby Redo Logs

108

(1)

Assign Threads to Standby Redo Log Groups

108

(1)

Logical Standby Database Enhancements

109

(4)

6 Business Intelligence

113

(48)

Oracle Data Pump

114

(20)

Oracle Data Pump Architecture

114

(4)

Data Pump Data Dictionary Views

118

(1)

Data Pump Interactive Mode

118

(2)

Data Pump API

120

(1)

Data Pump Export

120

(8)

Data Pump Import

128

(6)

Bigfile Tablespaces

134

(4)

What Are Bigfile Tablespaces?

134

(1)

Why Bigfile Tablespaces?

134

(1)

Bigfile Tablespace Management

135

(2)

Bigfile Tablespaces and Extended ROWIDs

137

(1)

Cross-Platform Transportable Tablespaces

138

(3)

Introduction to Cross-Platform Transportable Tablespaces

138

(1)

Datafile Byte Ordering: Endian Formats

139

(2)

Enhanced Merge Functionality

141

(5)

New merge Conditional Clauses and Extensions

141

(2)

Optional delete Clause in the merge Statement

143

(1)

Enhanced External Table Functionality

143

(1)

Writing to External Tables

143

(2)

Projecting Columns in External Tables

145

(1)

New Materialized View, Query Rewrite, and Summary Management DDL Features

146

(10)

Partition Change Tracking Enhancements

146

(1)

Query Rewrite Enhancements

147

(6)

Mview Fast Refresh Enhancements

153

(1)

Summary Management DDL Enhancements

154

(2)

New Partitioning Features

156

(5)

Index-Organized Table Partitioning Improvements

156

(1)

Hash-Partitioned Global Indexes

157

(2)

Partitioned Index Maintenance

159

(1)

Skipping Unusable Indexes

160

(1)

7 Application Development

161

(28)

Bulk Bind Improvements

162

(2)

Processing Sparse Collections

162

(2)

Exception Handling

164

(1)

SQL and PLSQL Regular Expressions

164

(8)

What Are Regular Expressions?

164

(1)

Using Regular Expressions in Oracle Database 10g

164

(8)

Case- and Accent-Insensitive Searches

172

(2)

User-Specified Quote Character Assignment

174

(1)

PLSQL New Packages of Note

174

(2)

The utl_compress Package

174

(1)

The utl_mail Package

175

(1)

Other New PLSQL Packages

176

(1)

Oracle Collections

176

(5)

Creating Temporary Tables with VARRAY Columns

176

(1)

Changing the VARRAY Size

177

(1)

Defining the Tablespace of a Nested Table

177

(1)

ANSI Support for Nested Tables and VARRAY Columns

178

(3)

The PLSQL Compiler

181

(6)

New PLSQL Compiler

181

(2)

Natively Compiled PLSQL New Features

183

(1)

Fine-Grained Debug Privileges

184

(1)

PLSQL Compile-Time Warnings

184

(3)

Improvements to the dbms_profiler Procedure

187

(1)

Table Function Enhancements

187

(1)

New Connect String Format

187

(2)

8 Other Database New Features

189

(22)

Calling Remote Stored Procedures

190

(1)

Workspace Manager Enhancements

190

(10)

New Functionality in the dbms_wm Package

191

(2)

Multiparent Workspaces

193

(3)

Workspace Manager Events

196

(1)

Exporting, Importing, and Loading Versioned Data

197

(2)

Workspace Continuous Refresh

199

(1)

Other Improvements for Workspace Manager

199

(1)

Streams Enhancements

200

(2)

SQL* Plus Enhancements

202

(3)

Enhancements to the describe Command

202

(1)

Enhancements to the spool Command

203

(1)

Changes to the Behavior of the SQL* Plus Profile Files

203

(1)

New define Variables

204

(1)

Capability to Do Variable Substitution at the SQL Prompt

204

(1)

The New SQL*Plus compatibility Command

205

(1)

Support for Whitespace in File- and Pathnames

205

(1)

Other SQL*Plus Enhancements and New Features

205

(1)

SQL Language New Features

205

(3)

Data Type Enhancements

206

(1)

Moving Data from BFILEs to a LOB

206

(1)

LOBs and the before row insert Trigger

206

(1)

New Functionality for the returning Clause

206

(1)

SQL Modeling

207

(1)

Using Aggregates in the returning Clause

207

(1)

Grouped Table Outer Joins

208

(1)

Removal of Aggregate and SQL Statement Length Limitations

209

(1)

New connect by Functionality

209

(2)

Example Using connect_by_iscycle

210

(1)

Example Using connect_by_isleaf

210

(1)

Example Using connect_by_root

210

(1)

9 Oracle Enterprise Manager 10g

211

(20)

Introducing the Redesigned OEM Architecture

212

(2)

Server Tier

213

(1)

Client Tier

213

(1)

Middle Tier

213

(1)

Communication Components

214

(1)

Changes to OEM Installation

214

(3)

Grid Control

215

(1)

Database Control

215

(1)

Studio Control

216

(1)

Connecting to OEM

216

(1)

Key New Features in OEM

217

(1)

Introducing the Revamped OEM Home Page

218

(2)

Consolidated Management with Target Home Pages

218

(2)

Server-Generated Alerts

220

(1)

Key New Management Features

220

(2)

Provisioning

220

(1)

Job Scheduler

221

(1)

New OEM Administration and Maintenance Features

222

(7)

Performance Tuning

225

(2)

OEM Grid Control

227

(1)

Top Sessions

227

(1)

Top SQL Assessment

227

(2)

Introducing Oracle EM2Go

229

(1)

EM2Go Home Page

229

(1)

Other New OEM Related Features

230

(1)

Baselining

230

(1)

History

230

(1)

Oracle Data Pump

230

(1)

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Oracle Database 10G New Features

Summary

Table of Contents

Supplemental Materials