Oracle 9i, also known as Oracle database, is a collection of information that is processed by the Oracle DBMS. It should be noted that there is not a clear distinction between the Oracle database, the data that is processed, and the Oracle database management software. The very first Oracle database software was designed by Larry Ellison, Ed Oates, and Bob Miner. Oracle 9i is composed to two primary elements, and these are the data storage and instance. The instance is made up of a number of OS procedures and memory elements, and these are used to interact with the data storage system.
The memory foundation for Oracle 9i is commonly called the SGA or System Global Area. The SGA will contain cache elements that may include data buffers or commands for SQL. While storage plays an important role in this database management tool, internet redo logs are important as well. Internet redo logs can be defined as the transaction history of various places over the internet. The redo logs can be used for either the recover of data or its duplication. The data that resides within Oracle 9i is logically stored. The logically stored form of this data is called tablespaces. The data can also be stored in a physical form, and this form of storage is called data files.
The tablespaces will be comprised of a number of different segments, and these segments are further broken down into extents. Extents can be further broken down into units that are called data blocks. The data blocks are the most basic form of storage within Oracle 9i. All the data files that exist in the system can be broken down into data blocks, though the size of these blocks may be different. To process the data that exists within the database, Oracle will use what is called the System tablespace. The System tablespace holds what is called the data dictionary. It may also have clusters as well.
The data dictionary holds a large number of tables that will have information about the various objects that reside within the database. Oracle 9i supports tablespaces that are locally managed. This means that the tablespaces can hold information that is related to space management. The space management data will be contained within bitmaps, and will not use the System tablespace. If the administrator chooses to use Oracle RAC, the various instances may be connected to a primary storage array system. There are a number of advantages to this, and some of the most powerful are enhanced system performance.
In addition to this, both redundancy and scalability are improved. However because of the complexities involved with using Oracle RAC, a large number of systems do nt use it. However resources may be shared with versions that use grid computing. Oracle 9i is capable of carrying out a number of different functions and procedures. Object oriented programming languages such as Java can be used to bring about code objects that can lead to procedures being carried out.