Draw a diagram of oracle architecture and explain it briefly.

The figure displays the architecture of the Oracle Database 9i. It is broadly divided into the memory components which form the Oracle instance and the physical database components where different kinds of data are stored. The Oracle server consists of physical files and memory components. The Oracle 9i Database product is made up three main components namely: ·

The Oracle Server: This is the Oracle database management system that is able to store, manage and manipulate data. It consists of all the files, structures, processes that form Oracle Database 9i. The Oracle server is made up of an Oracle instance and an Oracle database.

The Oracle Instance: Consists of the memory components of Oracle and various background processes.

The Oracle database: This is the centralized repository where the data is stored. It has a physical structure that is visible to the Operating system made up of operating system files and a logical structure that is recognized only the Oracle Server.