ERPstuff - Oracle EBS Community

Posted: **Fri Feb 26, 2010 5:26 pm**

Hi,

Can anyone tell me the major difference between 9i, 10g and 11g as Oracle DBA.

The way the DBA carry out monitoring, Performance Tuning and Backup and Recovery process.

ta
Arvin

Posted: **Wed Mar 03, 2010 1:45 am**

Hello

Some drastic changes happened between 9i and 10g with DB automation to minimize the DBA manual intervention. Since the basic concepts are still same but couple of additional tools were introduced (e.g. Automatic Workload Repository AWR, in 11g some extra views are provided to enhance baseline features).

On the backup side, in 10g the RMAN has some extended features available to expedite backup and recovery (e.g. only changed blocks are backed up).

For further info please check Oracle sites below:

http://www.oracle.com/technology/deploy ... erview.htm