1.Simplified and improved automatic memory management
2.New fault diagnosability infrastructure to prevent, detect, diagnose, and help
resolve critical database errors
3.Invisible Indexes
4.Virtual columns
5.Enhanced security for password-based authentication by enabling use of mixed
case in passwords.
6.Tablespace-level encryption
7.Ability to online redefine tables that have materialized view logs
Thease are only few enhancements , you can find more detail in the doc suggested by SaRa.
Oracle 11i refers to the Oracle ERP Application Suite (often called Oracle E-Business Suite) and really has nothing to do with the database. The latest release (12) will be referred to as 12i. The confusing part is that Oracle used to call its database "i" for "internet" in releases 8 and 9, but now calls the database "g" for "grid".
So, to summarize, Oracle 11i refers to the apps and Oracle 11g refers to the database.
Grid Infrastructure is present in 11gr2 but not in 11gr1
There really is not a big difference between Oracle 8i and Oracle 11G. They are both the same product, just different versions.
.
Oracle 11i Oracle 11i
G - Grid Technology I - Internet Applications
To get Oracle 9i, go to www.oracle.com. Go to the downloads page for 11g, scroll to the bottom, and select Previous database releases, Oracle 9i.
11i features is index rebuild eg: alter index index_name rebuiled and @db_link by using dblink we can access the data from multiple servers
Oracle 8i and 9i were databases with 'i' referring to the Internet. For version 10 onwards, Oracle named the database as 10g, 'g' referring to the grid. 10i and 11i are ERP systems, nothing to do with the database.
11i
dgfbfg
Procure to pay
Oracle is a Relational DataBase Management System Software (RDBMS) Oracle Application is a s/w that Operates on the Data Existed in the DataBase. e.g:- Oracle 8i,9i,10g,11g are DataBases. Oracle Fusion,Siebel CRM etc. are Applications. Simple Scenario where exactly we found the differences b/w these two:- ================================================== For example,the Data Related to Customers of a Bank is Stored inside the DataBase(either 10g,8i,or 9i) and after every month the Bank has to Generate the Reports for each Customer in word (or) PDF (or)html exactly in this scenario the Oracle Application(11i,12i) comes into the Picture it Generates the Reports based on the DataStored inside the DataBase by connecting to the DataBase.
17
In the underlying table structure, the MTL is short for 'materials'. For example, the MTL Transaction Interface table is used to issue and receive items in an out of inventory.
| 3-i - 1/(3-i)| = | 3-i - (3+i)/10|= | (27-11i)/10| = sqrt(17/2)