ISBN 0-9740716-0-9  ISBN 13 978-0974071602 Library of Congress Number: 2003097635 527 Pages - Perfect bind 9x7 Publication date: November 2003 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 RAC & Grid Tuning with Solid-state Disk $16.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