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 Oracle10g as they relate to database administration and Oracle tuning.

This book provides honest feedback about those Oracle10g 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.

Key Features:

• 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
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 will soon have Oracle10g training classes and Oracle10g consulting, and Oracle10g tuning.