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.
