| Oracle 10G is the last word in the db business. While 11G is coming fast there are still production sites using Oracle 9i that debating if to upgrade to 10G or not.. Here is some info to help decide..
Reasons to Upgrade to 10g: Ensure adequate vendor support.
Reduce maintenance costs by taking advantage of the many 10g automation utilities.
Obtain better performance and greater functionality by utilizing new features.
Advance customer technology edge via new productive features.
New Features in oracle 10g:
Oracle 10g comes with many new features most aimed at automating what have been time-consuming DBA functions in the areas of maintenance and monitoring.
10g Major Features:
1. Online Segment Shrink
Works only under ASSM (Automatic Segment Space Management).
Activated via "ALTER TABLE xx SHRINK SPACE [CASCADE]".
Compresses space, readjusts HWM and releases space.
Relevant for indexes, partitions, materialized views and LOBs.
Helpful in saving snapshot log space and lowering the High Water Mark of incremental snapshot logs.
Should run Analyze after Shrink.
2. COMMIT with WRITE IMMEDIATE NOWAIT
Allows Commit to return before writing in redo log, thus eliminating costly I/O waits.
OLTP applications should be tested to guarantee no transaction losses.
Most effective in high volume update transactions that generate extensive redo log writes.
Does not affect distributed transactions.
Dramatically reduces log_file_sync event wait time.
3. DBMS_MONITOR
DATABASE_TRACE_ENABLE displays Waits and Binds.
More user-friendly, more informative, more flexible tracing.
The client_id may be defined to aid in monitoring Java module connections.
4. Enterprise Manager 10.2
Much more useful and more efficient than OEM in previous versions.
Mandatory to use with the more sophisticated tools of 10g.
Best utilized after gaining experience.
5. ADDM (Automatic Database Diagnostic Monitor)
All-encompassing in analyzing and advising.
Potentially very helpful, but must be critically reviewed.
More user-friendly version via the Enterprise Manager.
More info can be found on: http://mysite.verizon.net/resnwm24/newfeaturesinoracle10g/index.html
Good luck |
Article Details
