My Account  Cart Contents  Checkout  
  Top » Catalog » Rampant Books » My Account  |  Cart Contents  |  Checkout   
Categories
Consulting (2)
Equine Books (1)
Posters (7)
Rampant Books (68)
Redneck
Downloads-> (24)
Video (2)
Bundles (5)
Manufacturers
What's New? more
Job Interview Pack
Job Interview Pack
$59.95
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Gift Voucher FAQ
Oracle Database 10g New Features for the DBA $19.95

ISBN
0-9740716-0-9 
ISBN 13
978-0974071602
Library of Congress Number: 2003097635
527 Pages - Perfect bind 9x7  
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 on VMware $34.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.
 

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

For more information, please visit this products webpage.

This product was added to our catalog on Saturday 30 August, 2003.

Reviews

Customers who bought this product also purchased
Oracle Tuning:The Definitive Reference
Oracle Tuning:The Definitive Reference
Oracle 11g New Features
Oracle 11g New Features
Oracle Performance Troubleshooting
Oracle Performance Troubleshooting
Words of the Day
Words of the Day
Conducting the Computer Programmer Job Interview
Conducting the Computer Programmer Job Interview
Super SQL Server Systems
Super SQL Server Systems
Shopping Cart more
0 items
Manufacturer Info
Rampant TechPress
Rampant TechPress Homepage
Other products
Notifications more
NotificationsNotify me of updates to Oracle Database 10g New Features for the DBA
Tell A Friend
 

Tell someone you know about this product.
Reviews more
Write ReviewWrite a review on this product!
Languages
English Deutsch Español
Currencies

P. O. Box 511
Kittrell, NC, 27544

SAN: 2 5 5 - 1 3 1 4


osCommerce