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 







Sheila Jenkins

Oracle News Headlines


Don Burleson speaks on 11g gotchas

eWeek magazine has just published this article where we see some of the best and worst 11g new features. 

Here is Mr. Burleson's favorite 11g new features:

1 - The new Oracle data compression utility promises to save on disk storage up to three times over storing data in an uncompressed format, with relatively small overhead. This has a whole lot more benefit than just saving on disk space. It will allow companies to go solid state for far less money.

2 - ADR [Automatic Diagnostic Repository] is a re­­pository for critical errors. It's basically automating something that database administrators have been doing manually for decades.

3 - SPA [SQL Performance Analyzer] is one of the most exciting features. It's a holistic tuning tool that allows you to define and replay a representative workload on your database. You can then adjust the global parameters for optimal performance very quickly. It's the kind of task that database administrators have been doing manually for years.

4 - [Another feature is] the ability to do "hot updates," which Oracle has been working on for years. It's phenomenally difficult from a software engineering perspective to write software that can update itself while it's running.

5 - Automatic Memory Management [AMM] tuning dates back to Oracle Database 9i, when Oracle provided the first tools to dynamically tune memory pools.

The downside of Oracle11g

We also see some "gotchas" in 11g, mostly related to abuse by the under-trained DBA.  Mr. Burleson notes that Oracle's easy to use interfaces can allow Dangerous Dilettantes to Destroy Databases:

1 - Oracle has become so automated that you can end up with a DBA that doesn't really know what is happening, and that is getting a lot of companies in trouble.

2 - Oracle offers many kinds of data replication, including Oracle Streams, Multi-master and snapshot replication, and Oracle RAC, which is, in a sense, a type of replication.

3 - Oracle has created artificial intelligence to advise on self-healing operations, and these are often misunderstood and misapplied by people without the requisite background.

4 - Oracle has offered features in 11g that are geared to senior practicing DBAs that have a huge potential for abuse by dilettantes. Many times I see that people are using these automated tools beyond their level of understanding.

We all know that Don loves 11g, and these criticisms read like "praising with feint damn", but they are valid points.  Also see Don's other notes on Oracle 11g:



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