Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

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


 

 

 


 

 

 
 

Oracle10g competes with SQL Server

Oracle Tips by Burleson Consulting
March 9, 2004


In a new turn of events, Oracle10g reduced prices of Oracle 10g standard edition one, in what will likely be a clobbering of Microsoft's SQL Server product.

Oracle10g - Better Price

Oracle10g now has super-competitive pricing, making it a no-brainer decision when compared to the less robust SQL Server database:

http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci948364,00.html

According to Rob Westervelt of SearchOracle:

"The price for 10g Standard Edition One is $4,995 per processor, and the maximum server capacity has been extended to two processors. An alternate pricing plan offers Standard Edition One for $149 per user, with a minimum of five users.  The price of Oracle's Standard Edition will remain at $15,000 per processor. The price for the company's Enterprise Edition has not changed; it costs $40,000 per processor."

Oracle10g - Better Features

Oracle already the easiest to manage database with Oracle10g, and Oracle claims that it is so easy to install and configure that a 12-year-old child can do it.  In a brilliant strategy, Oracle10g continues to be the world's most complex database, but the new automation features hide the complexity.  These automation features are fully described in Mike Ault's new book on Oracle10g New Features:

http://www.rampant-books.com/book_2003_2_oracle10g.htm

Oracle 10g Oracle10g Automatic Workload Repository - The Automatic Workload Repository (AWR) defaults to a collection interval every 30 minutes and collects data that is the foundation for all of the other self-tuning features.

Automatic Maintenance Tasks - The Automatic Maintenance Tasks (AMT) automate the routine tasks of refreshing statistics as they become stale, and rebuilding indexes when they become sub-optimal.

Automatic Database Diagnostic Monitor - The Automatic Database Diagnostic Monitor (ADDM) analyzes the AWR data, much the same as a human DBA would analyze a STATSPACK report. ADDM searches for lock and latch contention, file I/O bottlenecks, and SGA shortages just like a human DBA.

SQL Tuning Adviser - The SQL Tuning Advisor (STA) works with the Automatic Tuning Optimizer (ATO) to analyze historical SQL workload (using data from the AWR), and generates recommendations for new indexes and materialized views that will reduce the disk I/O associated with troublesome SQL statements.

Server-Generated Alerts - Server Generated Alerts (SGA) interface with the OS to send e-mail messages when an external problem is impeding Oracle performance.

Automatic Memory Management - The Automated Memory Management (AMM) component manages the RAM inside the System Global Area, much the same way as the automatic PGA management feature in Oracle9i (pga_aggregate_target) automates the sort and hash areas with PGA RAM.

Automatic Storage Management - The Automatic Storage Management (ASM) features allow the automatic stripe-and-mirror everywhere approach to be used for automatically load balancing the disk I/O sub-system, and removes the need for the DBA to specify physical file locations when allocating a tablespace.


For more 10g new features information, you may want Mike Ault's best-selling book Oracle Database 10g new features.  It's 30% off at this link and you get immediate access to the working 10g scripts.

 



 

 

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