Oracle10g new features book
Oracle Tips by Burleson Consulting
SearchOracle just announced free excerpts of the
Oracle Database 10g New Features book (
www.rampant-books.com/book_2003_2_oracle10g.htm on their site:
If you are planning to work with Oracle10g but don't
quite know what to expect from its functionality, below you'll find 12
excerpts from the only 10g new features book yet published,
Database 10g new features.
Written by the world's most widely-read authors of best-selling Oracle books, Mike
Ault, Daniel Liu and Madhu Tumma, this book focuses on the most
important new DBA features of Oracle10g as they relate to database
administration and Oracle tuning. It also provides honest feedback about
the Oracle10g features you should use, as well as those you should
avoid, and includes technical information and code samples to help you
Click on any of the following 12 excerpts for a technical overview
and how-to regarding a particular new feature or enhancement.
Adjusting the Oracle Database 10g shared pool
The library cache miss ratio tells the DBA whether to add space to the
shared pool, and it represents the ratio of the sum of library cache
reloads to the sum of pins. This excerpt describes how to work with this
feature and offers a Statspack script to compute the library cache miss
Automatic Shared Memory Management
The Automatic Shared Memory Management feature enables the Oracle
database to automatically determine the size of each of these memory
components within the limits of the total SGA size, solving allocation
issues you face in a manual method. Find out how this feature works in
Database tuning improvements
Oracle has introduced some good features that enhance self-tuning and
automated tuning. This excerpt will describe user-initiated buffer cache
flushing, automated checkpoint tuning, CPU costing, dynamic sampling,
tuning transaction, and recovery and easy monitoring.
Oracle Streams enhancement areas
Introduced in the Oracle 9.2, Oracle Streams has combined the advance
queuing technique, replication methodology, data warehousing and the
event management system in one. Oracle has made enhancements to Oracle
Streams in 10g, which are described in this excerpt.
This excerpt discusses the new features of Recovery Manager (RMAN) in
Oracle 10g provides a new package, dbms_scheduler, which has a number of
functions and procedures -- collectively called the Scheduler. This
excerpt describes the functionality provided by the Scheduler to
simplify management tasks.
This excerpt introduced new 10g features dealing with database security,
including column-level VPD, VPD static and dynamic policies and
fine-grained auditing (FGA) on DML.
SQL regular expressions
Oracle Database 10g supports POSIX-compliant regular expressions to
enhance search and replace capability in programming environments such
as Unix and Java. This excerpt explains how this functionality is
implemented in SQL.
The SQLAccess Advisor helps achieve higher performance goals by
recommending the proper set of materialized views, materialized view
logs and indexes for a given workload to create, drop or retain. Read
about the benefits and uses of this feature in this excerpt.
When solving tuning problems, session traces are very useful and offer
vital information. However, they involve many processes for shared
server sessions, making it difficult to get a complete picture of a
session's lifecycle. This excerpt describes a new command line utility
to help read trace files.
Virtual spreadsheets and upsert through SQL interrow calculations
Oracle Database 10g queries and subqueries can include new syntax that
provides highly expressive spreadsheet-like array computations with
enterprise-level scalability. This excerpt explains how these
computations work, and how you can use them on relational tables and
also in Oracle OLAP analytic workspaces.
Wait event model improvements
Originally introduced in Oracle 7, wait event analysis got the serious
attention of many DBAs in version 8 and was further improved in
Oracle9i. This excerpt explains what you need to know about wait event
interface changes, updates and improvements in 10g.
For more 10g information, purchase the Rampant TechPress book
Database 10g new features, by Mike Ault, Daniel Liu and Madhu Tumma.