A system global area (SGA) and the Oracle background processes constitute an Oracle instance. Every time a database is started, a system global area is allocated and Oracle background processes are started. The SGA is deallocated when the instance shuts down. See Also: background process, system global area (SGA)

A set of background processes and memory structures that access a database.

See Process Instance.

The combination of the System Global Area (SGA) and each process for the Oracle database. The memory and processes of an instance manage the associated database's data and serve the database users. Each instance has unique system identifier (SID), instance name, rollback segments, and thread ID.

a collection of processes and memory

a copy of an Oracle database

a group of proccesses that make your database accessable

a logical database manager environment where you catalog databases and set configuration parameters

a single installation of an Informix database engine, such as OnLine or Standard Engine

a standalone message-processing application with its own agents, rules, monitored e-mail addresses, and primary and secondary databases

a started database connected to those datafiles

As defined for the Oracle Server, A system global area (SGA) and the Oracle background processes constitute an Oracle instance. Every time a database is started, a system global area is allocated and Oracle background processes are started. The SGA is deallocated when the instance shuts down.

The Oracle instance consists of the SGA, the Oracle background processes, and the datafiles that make up your database.

The background processes and memory areas required to access an ORACLE database. A database system requires one instance and one database. Every ORACLE instance has a single system global area (SGA); a multiple-user instance also requires several background processes. See also type and instance.

The combination of the System Global Area (SGA) and the Oracle background processes. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the SGA and starts one or more Oracle processes. The memory and processes of an instance efficiently manage the associated database's data and serve the database users. You can connect to any instance to access information within a cluster database.

Combination of the background processes and memory buffers. An Oracle instance has two types of processes: user processes and Oracle Processes.

Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of computer type), Oracle allocates a memory area called System Global Area (SGA) and starts an Oracle process. This combination of SGA and an Oracle process is called an instance. The memory and the process of an instance manage the associated database's data efficiently and serve the one or more database users.

Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes. This combination of the SGA and the Oracle processes is called an instance. The memory and processes of an instance manage the associated database's data efficiently and serve the one or more users of the database.

The background processes and memory area required to access an Oracle database. A database system requires one instance and one database. An Oracle database server consists of an SGA and a set of Oracle database server system processes.

An instance of the running Oracle8 software referencing the database. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes. This combination of the SGA and the Oracle processes is called an instance. The memory and processes of an instance efficiently manage the associated database's data and serve the database users. You can connect to any instance to access information within a parallel server database.

An instance is essentially an installation of the controller. However, there is not necessarily a one-to-one relationship between the instance and the controller. The controller is clusterable, meaning that if a controller is installed on three servers in one cluster, those three controllers act as one; therefore, an instance can have more than one controller. Also, a controller can manage any infrastructure it has access to, across instances, so that there can be more than one instance per controller. A good example of this is an infrastructure in which there are intranet, internet, and test lab environments. The test lab and intranet may be on two separate instances, but still managed via one controller. All instances of Lokahi at an organization can connect, read, and write to a single database/schema.

An Oracle Instance is a running Oracle Database made up of memory structures ( SGA) and background processes ( SMON, PMON, LGWR, DBW0, etc.). An instance only exists while it is up and running. Simply put, a database resides on disk, while an instance resides in memory database is normally managed by one, and only one, instance. However, when using RAC, multiple instances can be started for a single database (on different nodes of a cluster). Each instance is identified with a unique identifier known as the ORACLE_SID.