Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
Call our store: 9955 5567 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
Browse by Subject
 TAFE Accounting
 TAFE I.T./Computing
 TAFE - Other
 Windows 8
 Adobe CS6
 CCNA 2012
 CCNP 2012
 Web Design
 Project Management
 Mobile Devices
 Windows Server 2012
 SQL Server 2012
Economics and Business
 Business Information Systems
 Human Resources

Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning & Administration

by: Mike Ault, Daniel Liu, Madhu Tumma

On-line Price: $9.95 (includes GST)

Paperback package 272

86%Off Retail Price

You save: $60.00

CLEARANCE Item - Special discount - limited stock!
N.Sydney : In Stock

Retail Price: $69.95

Publisher: Rampant Techpress,30.12.02

Category: ORACLE Level: B/I/A

ISBN: 0974071609
ISBN13: 9780974071602

Add to Shopping Cart

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

  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.

  Mike Ault's 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


List of Views and Explanation

  New Dynamic Performance Views


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


  Rename Tablespace


          Tablespace Rename Overview

          Tablespace Rename Benefits


  Bigfile Tablespace


          Bigfile Tablespace Overview

          Bigfile Tablespace Benefits

          Extended ROWID Format


  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



  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





















      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


      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


  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


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.