Summary

This book focuses on the most important new DBA features of Oracle 10g as they relate to database administration and Oracle tuning. It provides honest feedback about those features that you should use, and those you should not use. The text takes an indepth look at the features that are the most important for system performance and Oracle 10g database administration. Best of all, dozens of working samples are in the Oracle 10g online code depot. Examples from all areas of Oracle 10g are covered with working scripts and code snippets. Book jacket.

Author Biography

Mike Ault is a senior technical management consultant with TUSC and holds five Oracle master certificates. He is the author of 14 Oracle-related books, including Oracle 9i RAC and Oracle DBA Exam Cram. He lives in Alpharetta, Georgia. Madhu Tumma has been a software developer, IT manager, database administrator, and technical consultant and has worked on a wide variety of projects and environments, including mainframe, client-server, eBusiness, and managed services. He has consulted a variety of clients on database clusters, business continuity, and high availability solutions. He is a frequent speaker at Oracle World and IOUG, where he presented many technical papers and is the author of Oracle 9i RAC. He lives in Princeton, New Jersey. Daniel Liu is a senior Oracle Database Administrator at First American Real Estate Solutions. He has many years of industry experience in database administration and software development. He has worked with large-scale databases in multi-platform environments. His expertise includes Oracle database administration, performance tuning, Oracle networking, and Oracle Application Server. He lives in Anaheim, California. Donald K. Burleson is the author of 16 Oracle database books and is the editor in chief of Oracle Internals. He is an Oracle consultant with extensive experience designing and implementing Oracle8 databases, including systems architecture, project management, data warehouse design, implementation and tuning, tuning massively parallel Oracle databases, Oracle SQL tuning, using Oracle with SAP, and tuning very large Oracle databases. He lives in Kittrell, North Carolina.

Using the Online Code Depot	p. 1
Conventions Used in this Book	p. 2
Acknowledgments	p. 3
Preface	p. 5
Database Management	p. 7
New Features	p. 7
SYSAUX Tablespace	p. 8
What is Automated Storage Management?	p. 10
Automated Memory Management	p. 18
Oracle Database 10g Automation Features	p. 18
Automated RAC Services Configuration	p. 33
Simplified Upgrade for RAC and OPS Databases	p. 39
Drop Database	p. 39
Conclusion	p. 39
Database Tuning and Performance	p. 41
Database Resource Manager	p. 41
Database Tuning Improvements	p. 48
Application Tuning Improvements	p. 52
Self-Tuning Features	p. 62
Automatic SQL Tuning Process	p. 65
Wait Event Model improvements	p. 68
Conclusion	p. 71
Tablespace Management	p. 72
Temporary Tablespace	p. 72
Rename Tablespace	p. 75
Bigfile Tablespace	p. 76
New Cross-Platform Transportable Tablespaces	p. 81
Conclusion	p. 83
Table and Index Features	p. 84
Table and Index Partitions	p. 84
Sorted Hash-Clustered Tables	p. 96
Conclusion	p. 98
DML Features	p. 100
Single-Set Aggregates in DML Returning Clause	p. 100
Conclusion	p. 117
SELECT Features	p. 118
Grouped Table Outer Join	p. 118
Increased Number of Aggregates per Query	p. 119
Remote Stored Functions in SELECT Statements	p. 120
Case-Insensitive and Accent-Insensitive Query and Sort	p. 122
Enhanced CONNECT BY Support	p. 124
Oracle Expression Filter	p. 127
SQL Regular Expressions	p. 142
Row Timestamp	p. 149
Conclusion	p. 151
Improved Existing Features	p. 153
Existing Features That Have Changed	p. 153
Asynchronous Row Change Data Capture	p. 154
Cross-Platform Transportable Tablespaces	p. 173
Enhanced Table Functions	p. 182
External Tables Unload	p. 185
Enhanced MERGE Functionality	p. 202
Conclusion	p. 206
Initialization Parameters	p. 207
Basic Parameters	p. 207
Old Parameters	p. 210
New Parameters	p. 211
Conclusion	p. 226
Manageability Features	p. 227
Easy Management	p. 227
Self-Managing Database	p. 228
Overview	p. 228
Automatic Workload Repository (AWR)	p. 229
Advisory Framework - ADDM	p. 237
Server Alert Mechanism	p. 238
Shared Server Configuration	p. 240
Transaction Manageability	p. 243
Statistics Collection	p. 245
Audit Enhancements	p. 250
Response File	p. 252
Conclusion	p. 253
Utilities Improvements	p. 254
Data Pump Utilities	p. 254
New Scheduler Utilities	p. 272
SQL*Plus Enhancements	p. 280
Conclusion	p. 282
Network Features	p. 283
Enhanced Oracle Networking	p. 283
Export Directory Naming Entries to Local Naming File (tnsnames.ora)	p. 285
Dynamic Connection Manager Configuration	p. 287
Easy Connect Naming Method	p. 288
Improved Network Outage Detection	p. 292
Improved Connection Manager Access Rules	p. 295
Automated Shared Server Configuration	p. 297
Simplified Shared Server Configuration	p. 298
Certificate Validation with Certificate Revocation Lists (CRLs)	p. 301
Centralized CRL Management	p. 305
Single Station Administration for Password Authentication	p. 321
Transport Layer Security (TLS) Support	p. 324
Conclusion	p. 324
Backup and Recovery Features	p. 325
Flashback and RMAN	p. 325
Extended Flashback Functions	p. 327
RMAN Enhancements	p. 342
Conclusion	p. 358
High Availability and Scalability	p. 359
Avoiding Disruption	p. 359
Online Redefinition	p. 360
Synonyms and Views	p. 365
LOGMINER	p. 366
Data Guard Environment	p. 368
Supplemental Logging	p. 380
Real Application Clusters	p. 381
Conclusion	p. 384
Oracle Streams	p. 385
Enhancement Areas	p. 385
Streams Overview	p. 386
Configuration and Management	p. 388
Downstream Capture	p. 395
Asynchronous Change Data Capture	p. 400
Rule Interface Improvements	p. 401
Replication Enhancements	p. 406
Migration from Advanced Replication	p. 415
Messaging Enhancements	p. 416
Conclusion	p. 421
Security Enhancements	p. 422
Virtual Private Database	p. 422
Audit Enhancements	p. 428
Conclusion	p. 435
Business Intelligence	p. 436
New Features and Enhancements	p. 436
Materialized View Enhancements	p. 437
Query Rewriting	p. 439
Summary Management Improvements	p. 443
SQLAccess Advisor	p. 447
OLAP Enhancements	p. 456
Support for Bioinformatics	p. 460
Data Mining for Analytical	p. 462
Conclusion	p. 464
Globalization Improvements	p. 465
New Features	p. 465
Globalization Development Kit Enhancements	p. 466
Enhanced Character Set Scanner and Converter	p. 478
Conclusion	p. 497
Oracle Enterprise Manager	p. 498
Installation of OEM	p. 498
Starting and Navigating in OEM	p. 500
The EM2GO Interface	p. 510
Conclusion	p. 516
Index	p. 517
About the Authors	p. 526
Table of Contents provided by Ingram. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.