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 Rampant TechPress book, Oracle Database 10g new features.
Written by the world's top 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.