application common object
application common user
ALTER PLUGGABLE DATABASE APPLICATIONstatement.
CREATE PLUGGABLE DATABASEstatement.
ALTER PLUGGABLE DATABASE APPLICATIONstatement.
An Oracle Database installation that contains at least one PDB. Starting in Oracle Database 21c, every Oracle database is a CDB.
A database administrator who manages a CDB. A PDB administrator manages individual PDBs within the CDB.
CDB restore point
In a multitenant container database (CDB), a collection of schemas, schema objects, and nonschema objects to which all PDBs belong. Every CDB has exactly one root container, which stores the system metadata required to manage PDBs. All PDBs belong to the CDB root.
clean restore point
In a multitenant container database (CDB), a database user that exists with the same identity in multiple containers. A common user created in the CDB root has the same identity in every existing and future PDB. A common user created in an application container has the same identity in every existing and future application PDB in this application container.
In a multitenant container database (CDB), either the root or a PDB.
container data object
In a CDB, a table or view containing data pertaining to multiple containers and possibly the CDB as a whole, along with mechanisms to restrict data visible to specific common users through such objects to one or more containers. Examples of container data objects are Oracle-supplied views whose names begin with
In a CDB, a DDL statement that affects the CDB itself, multiple containers, multiple common users or roles, or a container other than the one to which the user is connected. Only a common user connected to the root can perform cross-container operations.
In a PDB, an internal mechanism that points to data (not metadata) in the root. For example, AWR data resides in the root. Each PDB uses an object link to point to the AWR data in the root, thereby making views such as
DBA_HIST_BASELINE accessible in each separate container.
The general process of moving data from one or more non-CDBs into a multitenant container database (CDB).
data-linked common object
extended data-linked common object
A hybrid of a data-linked common object and a metadata-linked common object. For an extended data-linked object, each application PDB can create its own PDB-specific data while sharing the common data in the application root.
Fast Application Notification (FAN)
Applications can use FAN to enable rapid failure detection, balancing of connection pools after failures, and re-balancing of connection pools when failed components are repaired. The FAN notification process uses system events that Oracle Database publishes when cluster servers become unreachable or if network interfaces fail.
In a PDB, an internal mechanism that points to a dictionary object definition stored in the root. For example, the
OBJ$ table in each PDB uses a metadata link to point to the definition of
OBJ$ stored in the root.
metadata-linked common object
multitenant container database (CDB)
An Oracle database that is not a multitenant container database (CDB). Before Oracle Database 12c, all databases were non-CDBs. Starting in Oracle Database 21c, every database must be a CDB.
In a multitenant container database (CDB), a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a separate database.
A database administrator who manages one or more PDBs. A CDB administrator manages the whole CDB.
PDB archive file
A compressed file that contains both PDB data files and an XML metadata file. You can create a PDB by specifying the archive file, and thereby avoid copying the XML file and the data files separately.
PDB lockdown profile
A security mechanism to restrict operations that are available to local users connected to a specified PDB. A typical use is to limit the effect of a grant privilege. For example, you limit the grant of
ALTER SYSTEM to only those options whose names begin with
PDB performance profile
PDB restore point
Within a CDB, a restore point that usable only for a specific PDB. In contrast, a CDB restore point is usable by all PDBs.
A named, point-in-time copy of a PDB created using the
ALTER PLUGGABLE DATABASE SNAPSHOT command. At the file level, a PDB snapshot is an archive file containing the contents of the PDB copy.
If the underlying file system supports sparse files, then the first snapshot is full, and every subsequent snapshot is sparse.
pluggable database (PDB)
A PDB that references a PDB in a remote CDB using a database link. The remote PDB is called a referenced PDB.
The PDB that is referenced by a proxy PDB. A local PDB is in the same CDB as its referenced PDB, whereas a remote PDB is in a different CDB.
refreshable clone PDB
A read-only clone that can periodically synchronize with its source PDB. Depending on the value in the
REFRESH MODE clause, the synchronization occurs either automatically or manually.
A container for resource plan directives that specify how resources are allocated to resource consumer groups.
resource plan directive
A set of limits and controls for CPU, physical I/O, or logical I/O consumption for sessions in a consumer group.
In a multitenant container database (CDB), a default pluggable database (PDB) that the system uses as a template for user-created PDBs. A PDB seed is either the system-supplied
PDB$SEED or an application seed.
shared undo mode
snapshot copy PDB
A PDB that is created by running the
CREATE PLUGGABLE DATABASE ... FROM ... SNAPSHOT COPY command. A storage-managed snapshot is a copy of the underlying storage that is only supported on specific file systems.
A storage-managed snapshot, which is used to make a snapshot copy PDB, is different from a PDB-managed snapshot, which can be specified in a
CREATE PLUGGABLE DATABASE ... USING SNAPSHOT command. Storage-managed snapshots are not involved in clones from PDB snapshots.