20-07-2013, 03:35 PM
Difference b/w Oracle 10g and 11g
Oracle 10g and 11g[.pptx (Size: 299.66 KB / Downloads: 16)
Oracle
The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation.
Oracle DB is one of the most trusted and widely-used relational database engines.
The system is built around a relational database framework in which data objects may be directly accessed by users (or an application front end) through structured query language (SQL).
Oracle 10g
It provided grid computing by provision of CPUs and data.
Oracle Enterprise Manager (OEM) gave a powerful grid control mechanism.
This version also provided enhancements for advanced extensions such as Oracle RAC (Real Application Clusters), Oracle Data Guard and Oracle Streams.
This version introduced many self-managing features like automated database diagnostic monitor, automated shared memory tuning, automated storage management, and automated disk based backup and recovery.
Oracle 11g
It provided new components such as Oracle Application Express, Oracle SQL Developer, Oracle Real Application Testing, Oracle Configuration Manager (OCM), Oracle Warehouse Builder, Oracle Database Vault and Oracle Shadow Copy Service.
11g provides better performance and its release 2 has been geared for newer operating systems such as Windows 7, Server 2008 and latest versions of Linux, Unix, Solaris, etc.
Difference b/w oracle 10g and 11g
Compared with 10g, 11g provides more simplified, improved and automated memory management and better ability to diagnose faults through inbuilt infrastructure to prevent, detect, diagnose, help, and resolve critical database errors, as well as, low database performance issues.
It provides invisible indexes, virtual columns, table partitioning and the ability to redefine tables which have materialized view logs.
A major difference in the two are the new security features found in 11g such as better password-based authentication with mixed case passwords, encryption on tablespace-level and enhancements for data pump encryption and compression.
Conclusion
11g is a good upgrade from 10g with many positive enhancements on an evolving technology. The technical documentation which was good in 10g has become even better in 11g, a significant benefit for the DBAs, who depend on it daily.
It is common for organizations not to utilize the full features of an Oracle database.
Therefore, the benefits of an upgraded version must be properly utilized for the organization to reduce their cost of ownership, downtime and increase performance, which 11g can deliver.