The New Oracle Database 11G- What’s It All About?

Produced and launched by Oracle Corporation as a flagship project, Oracle Database or Oracle RDBMS is an object-relational database management system. This has proprietary OTN standard license. Oracle provides its database management system in 63 language versions which include the variations between versions, say American English and British English. Some of the language versions are Arabic, Chinese, Czech, Dutch, Finnish, Portuguese, Russian, Spanish, Swedish, Thai, Turkish etc. Oracle also provides database developer tools and mechanisms which are referred as ‘Globalization’. Oracle Forms, Oracle JDeveloper, Oracle Reports are some of the tools offered.

TheOracle database management system consists of at least one instance of the application along with the data storage. In Oracle RDBMS, the data is stored physically in the form of data files and logically as tablespaces. Such tablespaces can have different types of memory segments like data segments and index segments. Oracle RDBMS also provides portioning feature which allows the partitioning of tables to manage larger data sets based on different set of keys. The monitoring or tracking of computer data storage is done using the information stored in ‘System’ tablespace. The ‘System’ tablespace comprises the data dictionary by default which in turn comprises indexes and clusters.

Process architecture of Oracle RDBMS depends on a collection of processes which simultaneously run in the background, interact with the monitor and perform database actions. The Oracle terminology differentiates the usually used computer terms based on the user interaction with the database.

(1)    Invocation of the software application based on user processes

(2)    Pathway linking the user processes to the Oracle instance

(3)    Sessions which connect to the Oracle instance using session identifiers called ‘SID’.

In the System Global Area, Oracle DBMS uses ‘locks’ and ‘latches’ to control simultaneous access to data resources and to protect shared data structures.Oracle DBMS uses various protocols to allow remote applications to access or interact with the Oracle database via network sessions.

The Oracle Database 11G provides a better business perspective as its server enables high-speed transactions and robust software. It provides options to build sophisticated and high-quality database applications. By implementing Oracle 11G database, one could guarantee high integrity and security of the Organization’s data. Oracle 11G version has provided a better version of RAC and ASM ClusterFile System.

The new 11G version of DBMS makes the database more robust, efficient and easy to manage. Here are few pointers which outline the working of new features in Oracle 11G.

• Database Replay

This tool has the capability to capture SQL statements and replay them when needed.

• Partitioning

It is a very compelling feature in 11G, which ensures ease of designing and managing the database tables. Internal, Referential, Virtual Column partitioning are the new sub-partitioning options which are introduced.

• Edition-Based Redefinition

One could update or patch application’s data objects making sure that the application is running without any interruption.

• Schema Management

One can easily add the columns with defaults values and check out virtual columns, invisible indexes, and read only tables.

• Patching and Upgrades, RAC One Node, and Clusterware

Enabling a single name for the cluster, enabling HA for a single-instance database, ASM updates, and much more.

• Data Warehousing and OLAP

Query Rewrite extensions, Cube Organized MVs, a new Analytic Workspace Manager etc.

• PL/SQL Performance and efficient coding

Explore in-lining of code, PLS timer, "real" native compilation etc.

• Transaction Management

Provides Flashback Data Archive and Enterprise Manager's LogMiner interface

• Security

Provides Tablespace Encryption, case-sensitive passwords, data masking, and other security features

• SQL Performance Analyzer & Real-Time SQL Monitoring

Predict changes on the actual SQL statements and monitor real-time SQL performance.

• Oracle Exadata Simulator


• SQL Plan Management


• Automatic memory management, multicolumn statistics, online patching, and many more features.


• SQL Access Advisor to advise on optimal table design


• SQL Operations: Pivot and Unpivot


• Backup and Recovery using Data Recovery Advisor


• Achieve Resiliency using Automatic Health Monitor and Automatic Diagnostic Repository.


• Automatic Storage Management and advanced data compression techniques


• Caching and Pooling


• Data Guard


• SecureFiles and much more extensive features.

It is the most appropriate time for the professionals to opt for Oracle database 11G training to take their career to the next level.