ISBN 0-9740716-0-9  ISBN 13 978-0974071602 Library of Congress Number: 2003097635 527 Pages - Perfect bind 9x7 PD 1103 Shelving: Databases/Oracle Oracle In-Focus Series # 12

Oracle Database 10g New Features  Oracle10g Reference for Advanced Tuning & Administration Mike Ault, Daniel Liu, Madhu Tumma Retail Price $34.95 / £20.75  Order now and get 40% off and get the online code depot! Only $19.95   (40% off)       Key Features About the Authors Table of Contents Index Reader Comments Errata       Get the RAC Pack - Half price! Six Pack RAC for $79.95 - A $168.00 value Oracle 10g Grid & Real Application Clusters $69.95 Personal Oracle RAC Clusters $27.95 Oracle on VMware $34.95 Oracle SQL Internals eBook $19.95 Oracle Space Management eBook $24.95 Oracle 10g DBA Reference Poster $8.95

Written by the world's most widely-read authors of best-selling Oracle books, Mike Ault, Daniel Liu and Madhu Tumma target their substantial knowledge of evaluating Oracle new features in this important book. With decades of experience evaluating new Oracle features, this book focuses on the most important new DBA features of Oracle 10g as they relate to database administration and Oracle tuning. This book provides honest feedback about those Oracle 10g features that you should use, and those you should not use. The text takes an in-depth look at those Oracle10g features that are the most important to system performance and Oracle10g database administration. Best of all, the authors have created dozens of working samples in the Oracle10g online code depot. Examples from all areas of Oracle10g are covered with working scripts and code snippets. Your time savings from a single script is worth the price of this great book.

* Receive an online code depot to get you started fast with Oracle10g. * Learn a complete conceptual framework for all areas of Oracle10g new features for DBAs. * Learn about important changes to the Oracle10g SQL optimizer. * Examine the automated SQLAccess Advisor for SQL tuning. * Automate your Oracle10g storage with Automated Storage Management (ASM). * See how to use the 20 new Oracle10g initialization parameters. * Load your Oracle10g database fast with the new Oracle10g data pump utility. * Understand important enhancements to Oracle Real Application Clusters 10g.

About the Authors:

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

Daniel Liu	Daniel Liu is a senior Oracle Database Administrator at First American Real Estate Solutions in Anaheim, CA. 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.  As an Oracle Certified Professional, he taught Oracle certified DBA classes at Elite Consulting Group in Chicago. Daniel also taught IOUG University Seminar in Orlando.  Daniel has published articles with DBAzine, Oracle Internals, and SELECT Journal.  Daniel has received SELECT Editorial Award for Best Article in 2001.  He has also given presentations at IOUG-A Live, LAOUG, OCOUG, NoCOUG, Oracle Open World and Oracle World.   Daniel has served as panelist on Oracles of Oracle at Oracle World and IOUG-Live.  Daniel holds a Master of Science degree in computer science from Northern Illinois University.
Madhu Tumma	Madhu Tumma has been working as Software Developer, IT Manager, Database Administrator, and Technical Consultant for about 18 years. He has worked on a wide variety of projects and environments ranging from mainframe, client-server, eBusiness to managed services. He has provided consultancy to variety of clients on database clusters, business continuity and high availability solutions. His experience ranges across multiple relational database systems. Madhu is frequent speaker at Oracle World and IOUG where he presented many technical papers. Madhu has Master Degree in science and attended Business Management graduate program. He lives in New Jersey with his wife Hema and two children Sandi and Sudeep.

Table of Contents:

Chapter 1: New Features for Database Creation and Deletion SYSAUX Tablespace Automated Storage Management Configuration Automated RAC Services Configuration Simplified Upgrade for RAC and OPS Databases Drop Database   Chapter 2: Database Tuning and Performance Improvements Database Resource Manager Improvements Database Resource Manager Overview Adaptive Consumer Group Mapping Fixed CPU Quota Integration of Resource Manager and Profiles Tuning Improvements Buffer Cache Flushing - User Initiated Automated Checkpoint Tuning CPU Costing Dynamic Sampling Tuning Transaction Recovery Easy Transaction Recovery Monitoring Oracle Enterprise Manager Changes Overview of the changes SQL Reporting New Performance Overview Charts Single-Set Aggregates in DML Returning Clause New and Updated Optimizer Hints Wait Model Improvements Overview of enhancements Changes and updates Application Tuning Overview of improvements SQL Access Advisor Materialized View Tuning API - The new TUNE_MVIEW API New Static Data Dictionary Views Overview List of Views and Explanation New Dynamic Performance Views Overview List of Views Static data dictionary views have new columns Dynamic performance views have new columns   CHAPTER 3 - New Features for Tablespace Management Temporary Tablespace ·        Temporary Tablespace Group Overview ·        Temporary Tablespace Group Benefits ·        Examples Rename Tablespace ·        Tablespace Rename Overview ·        Tablespace Rename Benefits ·        Examples Bigfile Tablespace ·        Bigfile Tablespace Overview ·        Bigfile Tablespace Benefits ·        Extended ROWID Format ·        Examples Automated Storage Management (ASM) ·        Automated Storage Management Overview ·        Automated Storage Management Benefits ·        ASM Disk Group ·        ASM Disk ·        ASM Files ·        ASM Instance   Chapter 4: New Table and Index Features Creating a Sorted Hash Cluster Benefits Examples   Partitioning Improvement Overview of Improvements in Partitioning Global Partitioned Indexes - Hash Partitioning Enhancements for Partitioned Index-Organized Tables    - List Partitioning    - LOB Support    - Global Index Maintenance Local Partitioned Indexes Manageability Improvements Enhanced Partition Management in Enterprise Manager   Enhanced Bitmap Index Performance and Space Management   Chapter 5: New DML Features: Insert, Update and Delete Single-Set Aggregates in DML Returning Clause Upsert through SQL Interrow Calculations   Chapter 6: New SELECT features SQLAccess Advisor Materialized View Tuning API Grouped Table Outer Join Increased Number of Aggregates per Query SQL Interrow Calculations Remote Stored Functions in SELECT Statements Native Net Over Fast Interconnects Native Net Over TCP/IP Case-Insensitive and Accent-Insensitive Query and Sort Enhanced Collections Enhanced CONNECT BY Support Oracle Expression Filter SQL Regular Row Timestamp     Chapter 7: Improved Features: MERGE, EXTERNAL TABLES, MINSERT Asynchronous Change Data Cross-Platform Transportable Tablespaces Enhanced Table Functions External Tables Unload Enhanced MERGE Functionality     CHAPTER 8 – New Initialization Parameters Type of Initialization Parameters Twenty New Parameters             CREATE_STORED_OUTLINES             DB_ALLOWED_LOGIN_VERSION             DB_FLASHBACK_RETENTION_TARGET             DB_RECOVERY_FILE_DEST             DB_RECOVERY_FILE_DEST_SIZE             DDL_WAIT_FOR_LICKS             INSTANCE_TYPE             LDAP_DIRECTORY_ACCESS             LOG_ARCHIVE_CONFIG             OSM_DISK_REPARIR_TIME             OSM_DISKGROUPS             OSM_DISKSTRING             OSM_POWER_LIMIT             PLSQL_OPTIMIZE_LEVEL             PLSQL_WARNINGS             RESUMABLE_TIMEOUT             SKIP_UNUSABLE_INDESES             SMTP_OUT_SERVER             SP_NAME             STREAMS_POOL_SIZE     Chapter 9 - New Management Features Database Startup and Shutdown Overview of enhancements Database Automated Startup and Shutdown Configuration Database Install Simplified Database Install Improvements in Auditing Uniform Audit Trail Extended SQL Support in FGA Easier Database Registration Unified User Model   Chapter 10 – Utilities Improvements Data Pump Utilities ·        Data Pump Overview ·        Data Pump Benefits ·        Data Pump Export ·        Data Pump Export Examples ·        Data Pump Import ·        Data Pump Import Examples SQL*Loader Improvements ·        Direct Path Support for ROWID Datatype ·        Direct Path Support for VARRAY Datatype ·        Direct Path Support for XML Type Tables SQL*Plus Enhancements ·        Session Configuration ·        SQL Prompt Runtime Variable Substitution ·        DESCRIBE Command Improvements ·        SPOOL Command Improvements ·        Show Recycle Bin ·        SQL*Plus Compatibility iSQL*Plus Enhancements         ·        Input Prompting ·        Command Changes      New Scheduler Utilities ·        Introduction to Scheduler ·        Scheduler Architecture ·        Program and Job Concepts ·        Managing Jobs and Programs ·        Data Dictionary View for Scheduler                  ·        Examples   Chapter 11: New Network Features Back Up Directory Naming Entries to Local Naming File Dynamic Connection Manager Configuration Easy Connect Naming Method Easy OCI/JDBC Install Improved Network Outage Detection Simplified Directory Usage Configuration Improved Connection Manager Access Rules Automated Shared Server Configuration Simplified Shared Server Configuration Parameters Certificate Validation with Certificate Revocation Lists (CRLs) Centralized CRL Management Centralized User Management for Kerberos Users Kerberos-Enabled Database Links Operating System Credential Cache Access to Single Sign On Wallet Key Store Interface End-to-End Identity Propagation Database Authentication with Standard LDAP Password Verifiers Single Station Administration for Password Authentication to Oracle Database Smart Card Support for X509v3 Certificates .Transport Layer Security (TLS) Support SSL Session Renegotiation Performance Improvements 4096-Bit Key Size Support

Chapter 12 – Backup and Recovery New Features Extended Flashback Functions ·        Flashback Database ·        Flashback Standby Database ·        Flashback Re-instantiation ·        Flashback Drop ·        Flashback Table ·        Flashback Row History ·        Flashback Transaction History RMAN Enhancements ·        Automated Channel Failover for Backup and Restore ·        Automated File Creation During Recovery ·        Simplified Backups to Disk ·        Proxy Copy Backup of Archivelogs ·        Incrementally Updated Backups ·        Simplified Recovery Through Resetlogs ·        Restore Tolerates Corrupt or Missing Backups ·        Full Database Begin Backup Command ·        Change-Aware Incremental Backups ·        Automated Disk-Based Backup and Recovery ·        RMAN Database Deregistration ·        Backup of Standby Control File ·        Automated TSPITR Instantiation ·        Simplified Recovery Manager Cataloging of Backup Files   Chapter 13 - High Availability Improvements Log Miner Overview of the improvements Automated LogMiner Configuration Support for Index-Organized Tables Support for Additional Types LONG, Multibyte CLOB and NCLOB Real Application Clusters Overview of the Improvements Data guard broker support CRS (Cluster Ready Services) workload management improvements - manage, and monitor application workloads as a service Improved Streams RAC Support - supports hot mining, - automatically restart processes after failover - supplemental logging Installtion and configuration - Overview of the improvements - Changes to OUI - Changes to DBCA             - suppot for ASM             - Support for OMF - Virtual Internet Protocol Assistant (VIPCA) Improvements to adding a node Support for rolling upgrades for one-off patches - using Cluster File System Optimizing the Cache Fusion - Dynamic affinity policy enhancements Enhancements to SRVCTL utility New Cluster Database Management Tools OEM enhancements Data Guard Simplified Zero Data Loss for Data Guard SQL Apply Real Time Apply Named Data Guard Configurations Secured Redo Transmission Zero Downtime Instantiation for SQL Apply Supplemental Logging Fine-Grained Enhanced Online Redefinition Improved Handling of DDL Locks on Busy Tables Signature-Based Dependency Tracking Using Synonyms   Chapter 14 - Oracle Streams Overview of Streams Batch Enqueue/Dequeue Downstream Capture Downstream Capture Overview Creating a Downstream Capture Process Performance Enhancements for greater work loads Enhanced Capture and Apply Performance Performance Enhancements for AnyData Queues, Rules, and Propagation Updates to the Rules Easy Rules Engine Transformation Management Negative Rules Tuning Rules Improved Enqueue Handler Access to Additional LCR Attributes Row Subsetting Additional Support for Long and NCLOB datatypes for IOT Support High-Level API for Message Queuing LCR.EXECUTE procedure improvements Streams packaged procedures Enhancements Set Instantiation SCN at Apply Site Clean Up Rules Sets Instantiation Through Transportable Tablespaces New APIs to Grant Privileges Improved Capture and Apply Error Handling Methods for providing faster instantiation Using RMAN Expose Commit Order of Changes  Advanced Replication to Streams Migration Tool Improved Monitoring methods Better interoperation with Oracle RAC capture changes from redo log as well as the archived redo log automatic transfer of the queue New streams related dynamic performance views New streams related initialization parameters   Chapter 15: Security Enhancements VPD Support for Parallel Query VPD Static and Dynamic Policies Column-level VPD   Chapter 16 - Business Intelligence Data Warehousing Enhancements Interrow Calculations SQLAccess Advisor tool DBMS_ADVISOR package for Indexing for materialized view Partitioning Enhancements partitioning for index-organized tables. partitioning materialized views in OLAP Hash-partitioned global indexes. ETL Enhancements SQL Support for Analytic Applications Grouped Table Outer Join Size of aggregations in a single SQL statement. SQL Inter-row Calculations Summary Management Enhanced Partition-aware Materialized View Refresh EXPLAIN PLAN Shows Materialized View Access The Enhanced Dimensions Nested Materialized View Refresh Materialized Enhanced PCT Refresh Partition Query Rewrite Uses Multiple Materialized Views New OLAP capabilities Parallel AGGREGATE Command Parallel SQL IMPORT Command PL/SQL Creation of Analytic Workspaces Intra-Dimensional (Attribute) Aggregation Enhanced Composite Dimensions Indexing PL/SQL OLAP Measure Calculation Definition Complete Analytical Workspace Management Multi-Writer Support XML Interface for Analytic Workspace Support for Bioinformatics DOUBLE and FLOAT Datatypes Blast Queries Statistical Functions Document Clustering Document Named Entity Extraction Support Vector Machines Document Clustering Non-negative Matrix Factorization Document Clustering Neural Nets Taxonomy Builder Data Mining for Analytical  Attribute Importance Algorithms Enhanced Data Preprocessing PMML Producers / Consumers Data Mining Rapid Application Development Multi-User Access Control JSR-73 RI & TCK (Java Data Mining) Complete Oracle Data Mining Management GUI Enhanced Adaptive Bayes Network Enhanced Model Seeker   Chapter 17: Globalization Improvements Globalization Development Kit Enhanced Character Set Scanner and Converter CLOB and NCLOB Implicit Conversions Unicode 3.2 Support Expanded Locale Coverage

Please note that the correct name for the new Oracle Database is "Oracle Database 10g". Incorrect  references to the new Oracle Database 10g include: Oracle Database 10g, Oracle 10g, Oracle Database10 g, OracleDB 10g, The Oracle Database 10g, Oracle  RAC 10g, Oracle10g.

BEI offers Oracle10g training classes, Oracle10g consulting, and Oracle10g tuning.

This book has Oracle10g database administration and Oracle10g DBA concepts.

Reviews:

Sandi from Ft. Lauderdale, FL says:
This is one of the best new features book that I have seen in quite some time. It goes beyond the high-level overview of the new 10g features and give working examples about how the features relate to existing Oracle9i systems.

This is one book that I expect to use very frequently as I get started in 10g.

Mladen from Connecticut says:

This is an excellent and exhaustive review of oracle 10g new features. It contains a great list of new features, together with clear explanations and numerous examples. Being a senior DBA, I find this book to be a great help in my study of 10g.

Coming from Mike Ault, a well known author of database management books and a long time DBA himself, I expected nothing short of excellence, and, once again, Mike and his co-authors delivered. Excellent book, a must have for anybody who wants to learn about the oracle latest and the greatest database software.

Dan Hotka from Iowa says:

Rating: *****

I purchased this book to get a jump-start on the new features of the latest Oracle database product…and reading this book…that is exactly what I received. The book is organized into general topics about the new database product. DB Management, Tuning & Performance, and various features including backup and recovery, high availability, and topics including new RAC features, initialization parameters, Streams, Enterprise Manager, and more.

Like all books Mike Ault is involved with, this book is loaded with scripts and practical examples for each topic. I found this book an essential part of my Oracle10g learning process.

Thank you Mike, Daniel, and Madhu for assembling a fine book in a timely manner.

Errata:

The index in the Oracle 10g New Features book has various broken page number links.  The page numbers should correspond to the correct indexed term in this version.  The corrected index is in PDF form and should be formatted to print, cut and insert the new index into the back cover of the book.

Note: Oracle changed the names of the following views from v$osm to v$asm, and they may be different, depending on your release level of Oracle10g:

http://otn.oracle.com/pls/db10g/db10g.drilldown?word=v$osm_alias

Index Topics: