This chapter also describes the different process configurations available for Oracle. This chapter also describes the parameters that control how the database operates. 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.