gaqtrain.blogg.se

Oracle 10g is proven to be more manageable than oracle 9i. These two versions have many differences including the following:

SYSAUX table space and rename table space command.Īutomatic Database Diagnostic Monitor (ADDM). Recycle bin for storing objects and new purge command. SQL apply feature and regular expression support. Oracle 10g Data Guard Broker and RAC to support Redo Log Transport. New drop database and alter database begin backup syntax. Oracle 10g, on the other hand, was released in 2003 to support regular expressions with the letter “g” standing for “grid” to emphasize Oracle 10g as grid computing ready. New data sharing and replication features.Ĭompresses keys in tables when loading data.

In 2001, Oracle 9i was released, the “i” standing for the word “Internet” meaning that it is Internet ready. The Oracle Database software includes a set of operating system processes such as PMON or process monitor and SMON or system monitor together and memory with data storage. It is an Object-Relational Database Management System (ORDMBS) which is identified by an alpha numeric system identifier (SID). In 1977 Software Development Laboratories (SDL) developed the Oracle Database software which is simply known as Oracle.