Oracle Glossary

Doyensys is an organization that lives and breathes Oracle. Here is our effort in building a resourceful Oracle community. Now you can learn Oracle concepts and terms through this glossary.

Oracle Cloud

Data center

A facility used to house computer systems and associated components.
Oracle provides data centers in various geographical regions. An identity domain and the services associated with that domain must belong to a specific data center.

Data region

A geographical region that’s associated with one or more data centers. When you sign up for an Oracle Cloud account, you select a default data region, where your services will be hosted.

Identity domain

A domain that controls the authentication and authorization of the users who can sign in to an Oracle Cloud service and which features they can access.
An Oracle Cloud service in a traditional cloud account must belong to an identity domain.

Oracle Account

Oracle Account is a unique customer account and can correspond to an individual, an organization, or a company that is an Oracle customer.
This account gives you access to the Oracle.com website, which includes your access to applications, communities, and Oracle Technology Network (OTN).
Note the following:
An Oracle Account is different from an Oracle Cloud Account that you use to access your cloud services.

For Oracle Infrastructure as a Service (Oracle IaaS) or Oracle Platform as a Service (Oracle PaaS) offerings, an Oracle account is no longer required if you’re signing up for the Free Oracle Cloud Promotion or for a new Oracle Cloud account.

An Oracle Account is required if you’re using Oracle Store to purchase services or if you sign up for certain traditional metered Oracle PaaS offerings that are part of the Free Oracle Cloud Promotion.

An Oracle Account is also required when logging support or service requests in My Oracle Support.

Oracle Cloud account

Use this account to access your cloud services and to sign in to the Infrastructure Classic Console or Applications Console, where you manage your account and your services.
There are two types of Oracle Cloud accounts: traditional cloud accounts (also known as Cloud Service accounts) and cloud accounts with Oracle Identity Cloud Service.

Service

A Software offered in Oracle Cloud

Service console

Service entitlements represent the right to use Oracle Cloud services, based on the resources you’ve purchased or the rights assigned to you by your Cloud Account administrator.

Service Entitlement

Service entitlements represent the right to use Oracle Cloud services, based on the resources you’ve purchased or the rights assigned to you by your Cloud Account administrator.

Service instance

The existence of a cloud service, for example, an instance of Oracle Java Cloud Service

Service instance URL

The web address (URL) that you use to access a provisioned service instance.

Service name

A name assigned to your Oracle Cloud service. The service name must be unique in the identity domain. You can add a longer description to help you identify the service after it’s activated.

Service notification

An event reported on the Infrastructure Classic Console or Applications Console in the Message center. Notifications provide information about upcoming events such as system outages or blackouts, service maintenance, promotion expiry, or resource quota breach.

Oracle Database

Access Driver

In the external table infrastructure, the API that interprets the external data for the database. The access driver runs inside the database, which uses the driver to read the data in the external table.

Access Path

The means by which data is retrieved from a database. For example, a query using an index and a query using a full table scan use different access paths.

Active Transaction

A transaction that has started but not yet committed or rolled back.

ADDM

Automatic Database Diagnostic Monitor. An Oracle Database infrastructure that enables a database to diagnose its own performance and determine how identified problems

ADR

Automatic Diagnostic Repository. A a file-based hierarchical data store for managing diagnostic information, including network tracing and logging.

Alert log

A file that provides a chronological log of database messages and errors. The alert log is stored in the ADR.

Antijoin

A join that returns rows from the left side of the predicate for which there are no corresponding rows on the right side of the predicate.

Application Architecture

The computing environment in which a database application connects to an Oracle database. The two most common database architectures are client/server and multitier.

Application Domain Index

A customized index specific to an application.

Archived Redo log file

A member of the online redo log that has been archived by Oracle Database. The archived redo log files can be applied to a database backup in media recovery.

ARCHIVELOG mode

A mode of the database that enables the archiving of the online redo log.

Ascending Index

An index in which data is stored in ascending order. By default, character data is ordered by the binary values contained in each byte of the value, numeric data from smallest

Automatic undo Management mode

A mode of the database in which it automatically manages undo space in a dedicated undo tablespace.

See also manual undo management mode.

AWR

Automatic Workload Repository (AWR). A built-in repository in every Oracle database. Oracle Database periodically makes a snapshot of its vital statistics and workload information and stores them in AWR.

B-tree index

An index organized like an upside-down tree. A B-tree index has two types of blocks: branch blocks for searching and leaf blocks that store values. The leaf blocks contain every indexed data value and a corresponding rowid used to locate the actual row. The “B” stands for “balanced” because all leaf blocks automatically stay at the same depth.

Background Process

A process that consolidates functions that would otherwise be handled by multiple Oracle programs running for each client process. The background processes asynchronously perform I/O and monitor other Oracle processes.

Bind Variable

A placeholder in a SQL statement that must be replaced with a valid value or value address for the statement to execute successfully. By using bind variables, you can write a SQL statement that accepts inputs or parameters at run time. The following example shows a query that uses v_empid as a bind variable:

SELECT * FROM employees WHERE employee_id = :v_empid;

Bitmap join index

A bitmap index for the join of two or more tables.

Bitmap merge

An operation that merges bitmaps retrieved from bitmap index scans. For example, if the gender and DOB columns have bitmap indexes, then the database may use a bitmap merge if the query predicate is WHERE gender=’F’ AND DOB > 1966.

Block header

A part of a data block that includes information about the type of block, the address of the block, and sometimes transaction information.

Block overhead

Space in a data block that stores metadata required for managing the block. The overhead includes the block header, table directory, and row directory.

Branch block

In a B-tree index, a block that the database uses for searching. The leaf blocks store the index entries. The upper-level branch blocks of a B-tree index contain index data that points to lower-level index blocks.

Buffer

A main memory address in the database buffer cache. A buffer caches currently and recently used data blocks read from disk. When a new block is needed, the database can replace an old data block with a new one.

Byte semantics

Treatment of strings as a sequence of bytes. Offsets into strings and string lengths are expressed in bytes.

Cache recovery

The phase of instance recovery where Oracle Database applies all committed and uncommitted changes in the online redo log files to the affected data blocks.

Cardinality

The ratio of distinct values to the number of table rows. A column with only two distinct values in a million-row table would have low cardinality.

Character encoding

A code that pairs each character from a given repertoire with a code unit to facilitate data storage.

Character semantics

Treatment of strings as a sequence of characters. Offsets into strings and string lengths are expressed in characters (character codes).

Character set

An encoding scheme used to display characters on your computer screen.

Checkpoint

1. A data structure that marks the checkpoint position, which is the SCN in the redo thread where database instance recovery must begin. Checkpoints are recorded in the control file and each data file header, and are a crucial element of recovery.

2. The writing of dirty data blocks in the database buffer cache to disk. The database writer (DBW) process writes blocks to disk to synchronize the buffer cache with the data files.

Client process

A process that executes the application or Oracle tool code. When users run client applications such as SQL*Plus, the operating system creates client processes to run the applications.

Client/server architecture

Software architecture based on a separation of processing between two CPUs, one acting as the client in the transaction, requesting and receiving services, and the other as the server that provides services in a transaction.

Cluster file system

A distributed file system that is a cluster of servers that collaborate to provide high performance service to their clients.

Cluster index

A B-tree index on the cluster key.

Cluster key

In a table cluster, the column or columns that the clustered tables have in common. For example, the employees and departments tables share the department_id column. You specify the cluster key when creating the table cluster and when creating every table added to the table cluster.

Column

Vertical space in a table that represents a domain of data. A table definition includes a table name and set of columns. Each column has a name and data type.

Commit

Action that ends a database transaction and makes permanent all changes performed in the transaction.

Composite index

An index on multiple columns in a table.

Composite partitioning

In partitioning strategy in which a table is partitioned by one data distribution method and then each partition is further divided into subpartitions using a second data distribution method.

Compression unit

In Hybrid Columnar Compression, a logical construct that stores a set of rows. When you load data into a table, the database stores groups of rows in columnar format, with the values for each column stored and compressed together. After the database has compressed the column data for a set of rows, the database fits the data into the compression unit.

Concurrency

Simultaneous access of the same data by many users. A multiuser database management system must provide adequate concurrency controls so that data cannot be updated or changed improperly, compromising data integrity.

Condition

The combination of one or more expressions and logical operators in a SQL statement that returns a value of TRUE, FALSE, or UNKNOWN. For example, the condition 1=1 always evaluates to TRUE.

Connection

Communication pathway between a client process and an Oracle database instance.

Connection pooling

A resource utilization and user scalability feature that maximizes the number of sessions over a limited number of protocol connections to a shared server.

Consistent backup

A whole database backup that you can open with the RESETLOGS option without performing media recovery. In other words, the backup does not require the application of redo to be made consistent.

Context

A set of application-defined attributes that validates and secures an application. The SQL statement CREATE CONTEXT creates namespaces for contexts.

Control file

A binary file that records the physical structure of a database and contains the names and locations of redo log files, the time stamp of the database creation, the current log sequence number, checkpoint information, and so on.

Cube

An organization of measures with identical dimensions and other shared characteristics. The edges of the cube contain the dimension members, whereas the body of the cube contains the data values.

Cursor

A handle or name for a private SQL area in the PGA. Because cursors are closely associated with private SQL areas, the terms are sometimes used interchangeably.

Database

Organized collection of data treated as a unit. The purpose of a database is to store and retrieve related information. Every Oracle database instance accesses only one database in its lifetime.

Database access control

The restriction of data access and database activities. For example, a database administrator can restrict users from querying specified tables or executing specified database commands.

Database application

A software program that interacts with a database to access and manipulate data.

Database authentication

The process by which a user presents credentials to the database, which verifies the credentials and allows access to the database.

Database service

A named representation of one or more database instances. The service name for an Oracle database is normally its global database name. Clients use the service name to connect to one or more database instances.

Database server

A server that reliably manages a large amount of data in a multiuser environment so that users can concurrently access the same data. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Database security

The aspect of database administration that involves user authentication, encryption, access control, and monitoring.

Database object

An object in the database that can be manipulated with SQL. Schema objects such as tables and indexes reside in schemas. Nonschema objects such as directories and roles do not reside in schemas.

Database management system (DBMS)

Software that controls the storage, organization, and retrieval of data.

Database link

In a schema object, a schema object in one database that enables users to access objects on a different database.

Database instance

The combination of the system global area (SGA) and background processes. An instance is associated with one and only one database. In an Oracle Real Application Clusters configuration, multiple instances access a single database simultaneously.

Database buffer cache

The portion of the system global area (SGA) that holds copies of data blocks. All client processes concurrently connected to the instance share access to the buffer cache.

Database user

An account through which you can log in to an Oracle database.

Database writer (DBW)

A background process that writes buffers in the database buffer cache to data files.

Data block

Smallest logical unit of data storage in Oracle Database. Other names for data blocks include Oracle blocks or pages. One data block corresponds to a specific number of bytes of physical space on disk

Data consistency

A consistent view of the data by each user in a multiuser database.

Data corruption

An error that occurs when a hardware, software, or network component causes corrupt data to be read or written.

Data dictionary

A read-only collection of database tables and views containing reference information about the database, its structures, and its users.

Data dictionary cache

A memory area in the shared pool that holds data dictionary information. The data dictionary cache is also known as the row cache because it holds data as rows instead of buffers, which hold entire data blocks.

Data dictionary view

A predefined view of tables or other views in the data dictionary. Data dictionary views begin with the prefix DBA_, ALL_, or USER_.

Data file

A physical file on disk that was created by Oracle Database and contains the data for a database. The data files can be located either in an operating system file system or Oracle ASM disk group.

Data integrity

Business rules that dictate the standards for acceptable data. These rules are applied to a database by using integrity constraints and triggers to prevent invalid data entry.

Data mining

The automated search of large stores of data for patterns and trends that transcend simple analysis.

Data Recovery Advisor

An Oracle Database infrastructure that automatically diagnoses persistent data failures, presents repair options to the user, and executes repairs at the user’s request.

Degree of parallelism

The number of parallel execution servers associated with a single operation. Parallel execution is designed to effectively use multiple CPUs. Oracle Database parallel execution framework enables you to either explicitly choose a specific degree of parallelism or to rely on Oracle Database to automatically control it.

Deferrable constraint

A constraint that permits a SET CONSTRAINT statement to defer constraint checking until after the transaction is committed. A deferrable constraint enables you to disable the constraint temporarily while making changes that might violate the constraint.

Dedicated server

A database configuration in which a server process handles requests for a single client process.

Deadlock

A situation in which two or more users are waiting for data locked by each other. Such deadlocks are rare in Oracle Database.

DDL

Data definition language. Includes statements such as CREATE TABLE or ALTER INDEX that define or change a data structure.

Data warehouse

A relational database designed for query and analysis rather than for OLTP.

Data type

In SQL, a fixed set of properties associated with a column value or constant. Examples include VARCHAR2 and NUMBER. Oracle Database treats values of different data types differently.

Data segment

The segment containing the data for a nonclustered table, table partition, or table cluster.

Dependent object

In a schema object dependency, the object whose definition references another object. For example, if the definition of object A references object B, then A is a dependent object on B.

Descending index

An index in which data is stored on a specified column or columns in descending order.

Dimension

A structure that categorizes data to enable users to answer business questions. Commonly used dimensions are customers, products, and time.

Direct-path INSERT

An INSERT in which the database writes data directly to the data files, bypassing the database buffer cache. The database appends the inserted data to the existing data in the table.

Directory object

A database object that specifies an alias for a directory on the server file system where external binary file LOBs (BFILEs) and external table data are located. All directory objects are created in a single namespace and are not owned by an individual schema.

Dirty read

A transaction reads data that has been written by another transaction that has not been committed yet. Oracle Database never permits dirty reads.

Distributed database

A set of databases in a distributed system that can appear to applications as a single data source.

Distributed processing

The operations that occurs when an application distributes its tasks among different computers in a network.

Distributed transaction

A transaction that includes statements that, individually or as a group, update data on nodes of a distributed database. Oracle Database ensures the integrity of data in distributed transactions using the two-phase commit mechanism.

DML

Data manipulation language. Includes statements such as SELECT, INSERT, UPDATE, and DELETE.

Edition

A private environment in which you can redefine database objects. Edition-based redefinition enables you to upgrade an application’s database objects while the application is in use, thus minimizing or eliminating down time.

Encryption

The process of transforming data into an unreadable format using a secret key and an encryption algorithm.

Field

In a table, the intersection of a row and column.

Fast recovery area

An optional disk location that stores recovery-related files such as control file and online redo log copies, archived redo log files, flashback logs, and RMAN backups.

Fact table

A table in a star schema of a data warehouse that contains factual data. A fact table typically has two types of columns: those that contain facts and those that are foreign keys to dimension tables.

Fact

Data that represents a business measure, such as sales or cost data.

External table

A read-only table whose metadata is stored in the database but whose data in stored in files outside the database. The database uses the metadata describing external tables to expose their data as if they were relational tables.

Extent

Multiple contiguous data blocks allocated for storing a specific type of information. A segment is made up of one or more extents.

Expression

A combination of one or more values, operators, and SQL functions that evaluates to a value. For example, the expression 2*2 evaluates to 4. In general, expressions assume the data type of their components.

execution plan

The combination of steps used by the database to execute a SQL statement. Each step either retrieves rows of data physically from the database or prepares them for the user issuing the statement. You can override execution plans by using hints.

Equijoin

A join with a join condition containing an equality operator.

file system

A join with a join condition containing an equality operator.

foreign key

An integrity constraint that requires each value in a column or set of columns to match a value in the unique or primary key for a related table. Integrity constraints for foreign keys define actions dictating database behavior if referenced data is altered.

Format model

A character literal that describes the format of a datetime in a character string.

Full table scan

A scan of table data in which the database sequentially reads all rows from a table and filters out those that do not meet the selection criteria. All data blocks under the high water mark are scanned.

Function-based index

An index that computes the value of a function or expression involving one or more columns and stores it in the index.

Granule

The basic unit of work in parallelism. Oracle Database divides the operation executed in parallel (for example, a table scan, table update, or index creation) into granules. Parallel execution processes execute the operation one granule at a time.

Grid computing

A computing architecture that coordinates large numbers of servers and storage to act as a single large computer.

Hard parse

The steps performed by the database to build a new executable version of application code. The database must perform a hard parse instead of a soft parse if the parsed representation of a submitted statement does not exist in the shared pool.

Hash collision

Hashing multiple input values to the same output value.

Hash join

A join in which the database uses the smaller of two tables or data sources to build a hash table in memory. The database scans the larger table, probing the hash table for the addresses of the matching rows in the smaller table.

Hash key value

In a hash cluster, an actual or possible value inserted into the cluster key column. For example, if the cluster key is department_id, then hash key values could be 10, 20, 30, and so on.

Hash table

An in-memory data structure that associates join keys with rows in a hash join. For example, in a join of the employees and departments tables, the join key might be the department ID. A hash function uses the join key to generate a hash value. This hash value is an index in an array, which is the hash table.

Implicit query

A component of a DML statement that retrieves data without a subquery. An UPDATE, DELETE, or MERGE statement that does not explicitly include a SELECT statement uses an implicit query to retrieve the rows to be modified.

Human error outage

An outage that occurs when unintentional or malicious actions are committed that cause data in the database to become logically corrupt or unusable.

Hint

An instruction passed to the optimizer through comments in a SQL statement. The optimizer uses hints to choose an execution plan for the statement.

High water mark

The boundary between used and unused space in a segment.

Hierarchical database

A database that organizes data in a tree structure. Each parent record has one or more child records, similar to the structure of a file system.

Heap-organized table

A table in which the data rows are stored in no particular order on disk. By default, CREATE TABLE creates a heap-organized table.

Hashing

A mathematical technique in which an infinite set of input values is mapped to a finite set of output values, called hash values. Hashing is useful for rapid lookups of data in a hash table.

Hash value

In a hash cluster, a unique numeric ID that identifies a bucket. Oracle Database uses a hash function that accepts an infinite number of hash key values as input and sorts them into a finite number of buckets. Each hash value maps to the database block address for the block that stores the rows corresponding to the hash key value (department 10, 20, 30, and so on).

Inconsistent backup

A backup in which some files in the backup contain changes made after the checkpoint. Unlike a consistent backup, an inconsistent backup requires media recovery to be made consistent.

Index

Optional schema object associated with a nonclustered table, table partition, or table cluster. In some cases indexes speed data access.

Index block

A special type of data block that manages space differently from table blocks.

Index cluster

An table cluster that uses an index to locate data. The cluster index is a B-tree index on the cluster key.

index clustering factor

A measure of the row order in relation to an indexed value such as last name. The more order that exists in row storage for this value, the lower the clustering factor.

Index-organized table

A table whose storage organization is a variant of a primary B-tree index. Unlike a heap-organized table, data is stored in primary key order.

Index range scan

An ordered scan of an index that has the following characteristics:

Index scan

The retrieval of a row by traversing an index, using the indexed column values specified by the statement.

Index segment

A segment that stores data for a nonpartitioned index or index partition.

Index skip scan

An index scan that uses logical subindexes of a composite index. The database “skips” through a single index as if it were searching separate indexes.

Index unique scan

An index scan that must have either 0 or 1 rowid associated with an index key. The database performs a unique scan when a predicate references all of the columns in the key of a UNIQUE index using an equality operator.

In-flight transaction

A transaction that is running when an outage breaks the connection between a client application and the database.

Interested transaction list (ITL)

Information in the block header of every segment that determines whether a transaction was uncommitted when the database began modifying the block. Entries in the ITL describe which transactions have rows locked and which rows in the block contain committed and uncommitted changes.

Integrity constraint

Declarative method of defining a rule for a column. The integrity constraints enforce business rules and prevent the entry of invalid information into tables.

Instance failure

The termination of a database instance because of a hardware failure, Oracle internal error, or SHUTDOWN ABORT statement.

Instance

The combination of the system global area (SGA) and background processes. An instance is associated with one and only one database. In an Oracle Real Application Clusters configuration, multiple instances access a single database simultaneously.

Inner join

A join of two or more tables that returns only those rows that satisfy the join condition.

Initialization parameter file

A text file that contains initialization parameter settings for a database instance.

Initialization parameter

A configuration parameter such as DB_NAME or SGA_TARGET that affects the operation of a database instance. Settings for initialization parameters are stored in a text-based initialization parameter file or binary server parameter file.

Information system

A formal system for storing and processing information.

Invisible index

An index that is maintained by DML operations, but is not used by default by the optimizer. Making an index invisible is an alternative to making it unusable or dropping it.

Join

A statement that retrieves data from multiple tables specified in the FROM clause. Join types include inner joins, outer joins, and Cartesian joins.

Join condition

A condition that compares two columns, each from a different table, in a join. The database combines pairs of rows, each containing one row from each table, for which the join condition evaluates to TRUE.

Key compression

The elimination of repeated occurrence of primary key column values in an index-organized table.

Key values

Individual values in a key.

Large pool

Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA.

Leaf block

In a B-tree index, a lower-level block that stores index entries. The upper-level branch blocks of a B-tree index contain index data that points to lower-level index blocks.

Library cache

An area of memory in the shared pool. This cache includes the shared SQL areas, private SQL areas (in a shared server configuration), PL/SQL procedures and packages, and control structures such as locks and library cache handles.

Listener

A process that listens for incoming client connection requests and manages network traffic to the database.

Literal

A fixed data value.

LOB

Large object. An Oracle data type designed to hold large amounts of data.

Locally managed tablespace

A tablespace that uses a bitmap stored in each data file to manage the extents. In contrast, a dictionary-managed tablespace uses the data dictionary to manage space.

Master site

In a replication environment, a different database with which a materialized view shares data.

Master-detail tables

A detail table has a foreign key relationship with a master table. For example, the employees detail table has a foreign key to the departments master table. Unlike a lookup table, a master table is typically queried and then joined to the detail table. For example, a user may query a department in the departments table and then use this result to find the employees in this department.

Mantissa

The part of a floating-point number that contains its significant digits.

Log writer (LGWR)

The background process responsible for redo log buffer management—writing the redo log buffer to the online redo log. LGWR writes all redo entries that have been copied into the buffer since the last time it wrote.

Log sequence number

A number that uniquely identifies a set of redo records in a redo log file. When the database fills one online redo log file and switches to a different one, the database automatically assigns the new file a log sequence number.

Logical volume manager (LVM)

A software package, available with most operating systems, that enables pieces of multiple physical disks to be combined into a single contiguous address space that appears as one disk to higher layers of software.

Logical volume

A virtual disk partition.

Lock

A database mechanism that prevents destructive interaction between transactions accessing a shared resource such as a table, row, or system object not visible to users. The main categories of locks are DML locks, DDL locks, and latches and internal locks.

Master table

The table associated with a materialized view at a master site.

Materialized view

A schema object that stores the result of a query. Oracle materialized views can be read-only or updatable.

Media recovery

The application of redo or incremental backups to a data block or backup data file.

Mounted database

An instance that is started and has the database control file open.

Multitier architecture

An architecture in which one or more application servers provide data for clients and serves as an interface between clients and database servers.

Network database

A type of database, similar to a hierarchical database, in which records have a many-to-many rather than a one-to-many relationship.

Network encryption

Encrypting data as it travels across the network between a client and server.

Null

Absence of a value in a column of a row. Nulls indicate missing, unknown, or inapplicable data.

Object-relational database management system (ORDBMS)

An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism.

Object table

An special kind of table in which each row represents an object.

OLAP

Online Analytical Processing. OLAP is characterized by dynamic, dimensional analysis of historical data.

Online redo log

The set of two or more online redo log files that record all changes made to Oracle Database data files and control file. When a change is made to the database, Oracle Database generates a redo record in the redo buffer. log writer (LGWR) writes the contents of the redo buffer to the online redo log.

Oracle home

The operating system location of an Oracle Database installation.

Oracle Enterprise Manager

A system management tool that provides centralized management of an Oracle database environment.

Oracle Data Redaction

A security feature that enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications.

Oracle Database Vault

A database security feature that controls when, where, and how databases, data, and applications are accessed.

Oracle ASM

Oracle Automatic Storage Management (Oracle ASM). A volume manager and a file system for database files. Oracle ASM is Oracle’s recommended storage management solution, providing an alternative to conventional volume managers, file systems, and raw devices.

Oracle architecture

Memory and process structures used by Oracle Database to manage a database.

Optimizer

Built-in database software that determines the most efficient way to execute a SQL statement by considering factors related to the objects referenced and the conditions specified in the statement.

Operator

1. In memory management, operators control the flow of data. Examples include sort, hash join, and bitmap merge operators.

2. In SQL, an operator manipulates data items called operands or arguments and returns a result. The SQL operators are represented by special characters or by keywords. For example, the multiplication operator is represented by an asterisk (*).

Oracle Net

Communication software that enables a network session between a client application and an Oracle database. After a network session is established, Oracle Net acts as a data courier for the client application and the database.

Oracle Net Listener

A process that resides on the server whose responsibility is to listen for incoming client connection requests and manage the traffic to the server. When a client requests a network session with a database, Oracle Net Listener (typically called the listener) receives the request. If the client information matches the listener information, then the listener grants a connection to the database server.

Oracle Net Services

A suite of networking components that provide enterprise-wide connectivity solutions in distributed, heterogeneous computing environments. Oracle Net Services includes Oracle Net, listener, Oracle Connection Manager, Oracle Net Configuration Assistant, and Oracle Net Manager.

Oracle process

A process that runs Oracle Database code. Oracle processes include server processes and background processes.

Oracle SQL

An implementation of the ANSI standard for SQL. Oracle SQL supports numerous features that extend beyond standard SQL.

Oracle Virtual Private Database (VPD)

A security feature that enables you to create security policies to control database access at the row and column level. Essentially, VPD adds a dynamic WHERE clause to a SQL statement that is issued against the table, view, or synonym to which a VPD security policy was applied.

Outer join

A join that returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition.

Parallel execution

The application of multiple CPU and I/O resources to the execution of a single database operation.

partial index

An index that is correlated with the indexing properties of an associated partitioned table.

partition

A piece of a table or index that shares the same logical attributes as the other partitions. For example, all partitions in a table share the same column and constraint definitions.

partition key

A set of one or more columns that determines the partition in which each row in a partitioned table should go. Each row is unambiguously assigned to a single partition.

partitioning

The ability to decompose very large tables and indexes into smaller and more manageable pieces called partitions.

physical guess

The physical rowid of an index entry when it was first made. Oracle Database can use physical guesses to probe directly into the leaf block of any index-organized table, bypassing the primary key search.

Plan generator

The part of the optimizer that tries different access paths, join methods, and join orders for a given query block to find the plan with the lowest cost.

PL/SQL

Procedural Language/SQL. The Oracle Database procedural language extension to SQL. PL/SQL enables you to mix SQL statements with programmatic constructs such as procedures, functions, and packages.

PL/SQL package

A logical grouping of related PL/SQL types, variables, and subprograms.

PL/SQL procedure

A schema object that consists of a set of SQL statements and other PL/SQL constructs, grouped together, stored in the database, and run as a unit to solve a specific problem or perform a set of related tasks.

PL/SQL subprogram

A named PL/SQL block that can be invoked with a set of parameters

precision

The total number of digits in a floating-point number. You specify a fixed-point number in the form NUMBER(p,s), where p represents the precision.

Precompiler

A programming tool that enables you to embed SQL statements in a high-level source program written in a language such as C, C++, or COBOL.

Predicate

The WHERE condition in a SQL statement.

Private SQL area

An area in memory that holds a parsed statement and other information for processing. The private SQL area contains data such as bind variable values, query execution state information, and query execution work areas.

privilege

The right to run a particular type of SQL statement, or the right to access an object that belongs to another user, run a PL/SQL package, and so on. The types of privileges are defined by Oracle Database.

Privilege analysis

A security mechanism that captures privilege usage for a database according to a specified condition. For example, you can find the privileges that a user exercised during a specific database session.

Process

A mechanism in an operating system that can run a series of steps. By dividing the work of Oracle Database and database applications into several processes, multiple users and applications can connect to a single database instance simultaneously.

Pseudocolumn

A column that is not stored in a table, yet behaves like a table column.

Query

An operation that retrieves data from tables or views. For example, SELECT * FROM employees is a query.

Query block

A top-level SELECT statement, subquery, or unmerged view.

Query coordinator

In parallel execution, the user session or shadow process that coordinates the parallel execution servers. The parallel execution servers performs each operation in parallel if possible. When the parallel servers are finished executing the statement, the query coordinator performs any portion of the work that cannot be executed in parallel. Finally, the query coordinator returns any results to the user.

Read-only database

A database that is available for queries only and cannot be modified.

Recoverable error

A class of errors that arise because of an external system failure, independently of the application session logic that is executing. Recoverable errors occur following planned and unplanned outages of networks, nodes, storage, and databases. An example of a nonrecoverable error is submission of invalid data values.

Recursive SQL

SQL that the database executes in the background to obtain space for database objects. You can think of recursive SQL as “side effect” SQL.

Redo log

A set of files that protect altered database data in memory that has not been written to the data files. The redo log can consist of two parts: the online redo log and the archived redo log.

Redo log buffer

Memory structure in the SGA that stores redo entries—a log of changes made to the database. The database writes the redo entries stored in the redo log buffers to an online redo log file, which is used if instance recovery is necessary.

Referenced object

In a schema object dependency, the object that is referenced by another object’s definition. For example, if the definition of object A references object B, then B is a referenced object for A.

Relational database

A database that conforms to the relational model, storing data in a set of simple relations.

Relational database management system (RDBMS)

A management system that moves data into a relational database, stores the data, and retrieves it so that applications can manipulate it.

Replication

The process of sharing database objects and data at multiple databases.

Reverse key index

A type of B-tree index that physically reverses the bytes of each index key while keeping the column order. For example, if the index key is 20, and if the two bytes stored for this key in hexadecimal are C1,15 in a standard B-tree index, then a reverse key index stores the bytes as 15,C1.

RMAN

Recovery Manager. An Oracle Database utility that backs up, restores, and recovers Oracle databases.

Role

A set of privileges that can be granted to database users or to other roles.

Row

A set of column information corresponding to a single record in a table. The database stores rows in data blocks.

Row chaining

A situation in which Oracle Database must store a row in a series or chain of blocks because it is too large to fit into a single block.

Row major format

A type of table storage in which all columns of one row are stored together, followed by all columns of the next row, and so on.

Rowid

A globally unique address for a row in a database.