|
ISBN
0-9740716-0-9
ISBN 13
978-0974071602 |
Library of
Congress Number: 2003097635 |
|
527 Pages - Perfect bind 9x7 |
Publication date: November 2003 |
|
Shelving: Databases/Oracle |
Oracle In-Focus Series # 12 |
|
|
Oracle Database
10g New Features
Oracle10g Reference for Advanced Tuning &
AdministrationMike
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) |
 |
Get the RAC Pack - Half price!
Six Pack RAC for $79.95 - A $168.00 value |
|
|
|
|
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.
|
|
* 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
-
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
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
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)
-
workl
| | |
