| help | account  


Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration
View Larger Image
Mike Ault, Daniel Liu, Madhu Tumma
Rampant TechPress, Paperback, Published January 2004, 528 pages, ISBN 0974071609
List Price: $34.95
Our Price: $22.50
You Save: $12.45 (36% Off)


FREE Shipping on Orders over $40!*
Availability: Out-Of-Stock

Customer Reviews: 8     Average Customer Rating:

Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:

Written by the world's top 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 is one of the leading names in Oracle technology.  The author of more than 20 Oracle books and hundreds of articles in national publications, Mike Ault has five Oracle Masters Certificates and was the first popular Oracle author with his landmark book "Oracle7 Administration and Management".  Mike also wrote several of the "Exam Cram" books, and enjoys a reputation as a leading author and Oracle consultant. Mike started working with computers in 1979 right out of a stint in the Nuclear Navy. He began working with Oracle in 1990 and has since become a World Renowned Oracle expert. Mike is currently a Senior Technical Management Consultant and has two wonderful daughters.  Mike is kept out of trouble by his wife of 29 years, Susan.

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 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
 


Customer Reviews

Customer Reviews: 8     Average Customer Rating:

Dec 24, 2004     Kavsek from Boston
Fairly complete coverage
I was on my way to write more or less a negative review of this book, however I changed my mind and now I really think that this book is a *good* reference after all. Why?

First title on Oracle 10g new features that I read was Robert Freeman's book. With modest 200+ pages it's an excellent introductory kind of text and nothing more, it's far from being considered as a reference (or complete) guide to 10g new features.

On the other hand Mr. Ault, Liu and Tumma's book has from the very beginning the ambition to be a true REFERENCE, as complete as possible (they even write some short introduction about new bioinformatics features included in 10g!!). It is amazing how many information they managed to compile and present in detail, especially considering the timing - short beta cycle of 10g and obvious "gold rush" of the publisher (shame on you ;-).

Oct 27, 2004     Rick from Knoxville, TN
Very average, not what I expect from these authors
It is a good introductory into the beta version of 10g. Unfortuneately it appears it was written with the goal of being the first 10g new features on the market sacrificing quality. There are numerous errors. It is probably still worth the purchase as there is a lot of useful information.

Aug 27, 2004     
Must read before planning 10g upgrade
This book is full of useful insight in planning your move 10g, more than worth the price of the book.

Jul 3, 2004     Hank
Ramblings
The book is more ramblings than writings. Information is scattered throughout the book. Disjointed. Numerous errors. Information didn't always match the production release. Needs a competent editor.

Jun 4, 2004     A review from Boston
reprint of beta documents
This book was nothing more then a reprint of the 10g beta e-studies. If you were not in the beta program then this is a good review of the first beta release. However you should note that a lot has changed in what is now the production release.

Mar 31, 2004     A review from Yuma, Az.
A good introduction but beware of errors!
A good introduction to 10g new feature that suffers from apparently having been written using the Beta version of the product. Some of the content does not map to the production version of 10g and some does not work at all. This fact does not make the book unusable, however, and there is a lot of meat to be gotten from it's pages.

Feb 16, 2004     Mladen Gogala (mgogala@adelphia.net) from Connecticut.,USA
Excellent and exhaustive book
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 databas

Jan 24, 2004     Sandi Freeman from Ft. Lauderdale, FL
Great Coverage
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.



Forgot your password?
FAQs
Shipping Options
Returns
Your Orders
Your Account