This chapter describes the memory structures used by an Oracle database system. This chapter describes the process structure of an Oracle instance and the different process configurations available for Oracle. Indexes and clusters, optional structures that make data retrieval more efficient, are also described. This chapter describes how partitioning can be used to split large tables and indexes into more manageable pieces. This chapter defines the concept of transactions and explains the SQL statements used to control them.
Transactions are logical units of work that are executed together as a unit.
This chapter describes the Oracle Advanced Queuing feature, which allows users to store messages in queues for deferred retrieval and processing by the Oracle server. This chapter describes the procedural language constructs called triggers, procedures that are implicitly executed when anyone inserts rows into, updates, or deletes rows from a database table. This chapter explains how Oracle manages the dependencies for objects such as procedures, packages, triggers, and views. This chapter explains how the optimizer works. The optimizer is the part of Oracle that chooses the most efficient way to execute each SQL statement.