Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
 Search:   
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
I.T
 .NET
 Windows 8
 Adobe CS6
 Cisco
 CCNA 2012
 CCNP 2012
 Java
 VB
 ASP
 Web Design
 E-Commerce
 Project Management
 ITIL
 Macintosh
 Mobile Devices
 Linux
 Windows Server 2012
 SQL Server 2012
 SAP
Certification
 MCITP
 MCTS
Economics and Business
 Accounting
 Business Information Systems
 Economics
 Finance
 Management
 Marketing
 TAX
 Human Resources
Academic
 Law
 Nursing
 Medical
 Psychology
 Engineering

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


  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.