Free Oracle Tips

HTML Text
Oracle Consulting Oracle Support
Oracle Training
SQL Tuning Consulting
Oracle Tuning Consulting
Data Warehouse Consulting
Oracle Project Management
Oracle Security Assessment
Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Internals Magazine
Oracle Links
Oracle Monitoring
Remote Support Benefits
Remote Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices
 

Free Oracle Tips


 
HTML Text AOL
 
 

Mike Ault best Oracle10g new features

Mike Ault

 


An exclusive interview with Mike Ault:

http://www.thechannelinsider.com/article2/0,1895,1620193,00.asp

Ault is a senior consultant with Burleson Oracle Consulting and the author of some 20 Oracle books, the most recent of which is titled "Oracle Database 10g New Features."

First, I asked Ault what the Top 5 features of 10g are vis--vis the ability to save DBAs time. Here's his list:

 

     

  • AMM (Automatic Memory management). "Because DBAs spend a large amount of time monitoring and tuning the SGA areas in Oracle, AMM relieves them of a majority of this chore," Ault said.

     

  • Automated diagnostics through ADDM ("Adam"). "This process collects the needed statistics, SQL statements and other required data to analyze performance bottlenecks and provide detailed recommendations to the DBA," he said. "In addition, ADDM can be used to do detailed analysis of SQL statements to develop a SQL profile that can be used to tune previously 'un-tunable' SQL such as third-party application SQL."

     

  • ASM (Automated Storage management). "This allows the DBA to set and forget datafile, redo log and other file areas," Ault said. "ASM provides for automated striping and mirroring as well as backup of Oracle-related files. ASM replaces more expensive disk management software (as related to Oracle data files)."

     

  • Enterprise manager and Grid Control. "There are so many enhancements in EM that it is difficult to pinpoint one that really shines," Ault said. "However, the automation of backups via a simple point-and-click interface has to be right up there. In addition, the fully Web-compliant interface that allows a DBA to manage [his or her] environment from anywhere they have access to the Internet is also a great convenience.

     

  • Improvements to the wait interface. This eliminates the need to dig for child wait information and the grouping of related waits by category, Ault said.
If you like Oracle tuning, check-out my latest book "Oracle Tuning: The Definitive Reference". 

Packed with almost 1,000 pages of Oracle performance tuning techniques, it's the foolproof way to find and correct Oracle bottlenecks.


 


Need Oracle Tuning Support?

Burleson Consulting now offers a one-day performance review for your Oracle database.  Working with top experts who tune hundreds of databases each year, you can get fast expert tuning advice to hypercharge your Oracle database.

We also provide expert upgrades to Oracle9i and Oracle10g, and our DBAs can quickly show you how to implement the important new features of new Oracle releases.

Call now for remote Oracle support.



 

Burleson Consulting

Email: info@remote-dba.net • Phone (800) 766-1884

Copyright 1996 - 2011 by Burleson Enterprises. All rights reserved.