What is the architecture of Oracle Database?

There are three major structures in Oracle Database server architecture: memory structures, process structures, and storage structures. A basic Oracle database system consists of an Oracle database and a database instance. The database consists of both physical structures and logical structures.

What type of database is Oracle 11g?

Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS).

What are the components of Oracle Database?

The following sections explain the physical database structures of an Oracle database, including datafiles, redo log files, and control files.

Datafiles. Every Oracle database has one or more physical datafiles.
Control Files.
Redo Log Files.
Archive Log Files.
Parameter Files.
Alert and Trace Log Files.
Backup Files.

What is meant by Oracle 11g?

Version 11g of the Oracle Database, which included built-in testing for changes, the capability of viewing tables back in time, superior compression of all types of data and enhanced disaster recovery functions. The “g” stood for “grid computing,” which supports clusters of servers that are treated as a single unit.

What are the memory structures associated with Oracle?

The basic memory structures associated with Oracle Database include: The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes.

How is the PGA created in Oracle Database?

The PGA is created by Oracle Database when an Oracle process is started. One PGA exists for each server process and background process. The collection of individual PGAs is the total instance PGA, or instance PGA. Database initialization parameters set the size of the instance PGA, not individual PGAs.

When does Oracle create the run time area?

Oracle Database creates the run-time area as the first step of an execute request. For DML statements, the run-time area is freed when the SQL statement is closed. This area contains bind variable values. A bind variable value is supplied to a SQL statement at run time when the statement is executed.