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 








Oracle 10g Release 2 now available for download

July, 6, 2005

The long-awaited GA (general availability) released of 10gr2 has finally come, and Oracle geeks across the globe are ecstatic:

Download Oracle 10g r2

I have an article on SearchOracle about the general new features of Oracle 10g, but note that Oracle 10g release 2 has some fun new features to explore.

Arup Nanda, Author of Oracle Privacy Security Auditing: Includes Federal Law Compliance with HIPAA, Sarbanes-Oxley & The Gramm-Leach-Bliley Act GLB and respected Oracle expert, has a superb list of Oracle 10g release 2 features on OTN:

Nanda on Top Oracle10g r2 features for the DBA

My favorite 10g r2 new goodies include:

Direct SGA access with Memory Access Mode (MAM)

Sounds cool.  According to Nanda: - "In Oracle Database 10g Release 2, Oracle Enterprise Manager Grid Control can, under demanding circumstances, attach directly to the SGA at your request—and thereby collect data directly from the process state.

This so-called Memory Access Mode enhances your ability to use Oracle Enterprise Manager effectively even when the instance is experiencing severe problems. And best of all, this is done automatically when SQL access is virtually impossible. Note that the Memory Access mode is not a replacement for SQL access; it's intended only for emergencies when SQL access is unavailable. Furthermore, Memory Access mode provides only that subset of data that is useful for analyzing hung sessions. (More on that subject in the next installment, on Performance features.)"


DML error logging

The new Error Logging features allows you to capture DML errors (insert, update, delete).  Nanda notes that the DML logging can changes the behavior of the "all or nothing" nature of a DML statement, allowing some rows to be updated while other fail::

Without the error-logging clause, the whole statement would have failed, with no records rejected. Through this clause, only the invalid records were rejected; all others were successful.  

This is a Godsend to developers who used to have to code around DML errors with custom routines.

ASM command line scripting

ASM has been well-received by Oracle DBA experts and the Stripe-and-mirror-everywhere (SAME) had become the de-facto standard for Oracle datafile-disk mapping.  Dr. Arun Kumar covers ASM in great detail in his latest book "Easy Oracle Automation" and now Nanda notes that  and it now has a command-line interface:

"This interface, called asmcmd, lets you do a lot of things with the datafiles stored in ASM diskgroups, which are akin to filesystems and corresponding files. The tool is based on Perl, so the latter needs to be in the path. If the path to Perl is not set properly, you may want to create a soft link to the directory where Perl exists, or just modify the file asmcmd to reflect the correct path of the Perl executable."


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

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational