Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

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

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

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 Excel
 
Oracle performance tuning software 
 

 

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

All rights reserved by Burleson

Oracle © is the registered trademark of Oracle Corporation.