Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 








Oracle10g new features book excerpts

Oracle Tips by Burleson Consulting

SearchOracle just announced free excerpts of the Oracle Database 10g New Features book ( on their site:,289483,sid41_gci948662,00.html

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, Oracle 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 get started.

Click on any of the following 12 excerpts for a technical overview and how-to regarding a particular new feature or enhancement.

1. 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 ratio.

2. 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 this excerpt.

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

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

5. RMAN enhancements
This excerpt discusses the new features of Recovery Manager (RMAN) in Oracle10g.

6. Scheduler utilities
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.

7. Security enhancements
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.

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

9. SQLAccess Advisor
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.

10. trcsess utility
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.

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

12. 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 Oracle Database 10g new features, by Mike Ault, Daniel Liu and Madhu Tumma.

If you like Oracle tuning, you may enjoy my new book "Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.