Oracle Fachvokabular

The default name of the callout process that is used when executing external procedures from Oracle.

An initialization parameter that specifies the desired amount of time, in seconds, to perform instance recovery after an instance failure.

Special auditing that allows custom rules to be used in monitoring and capturing audit records.

Generally, a combination of hardware and software that controls network traffic and prevents intruders from compromising corporate network security.

A single, unified storage area for all recovery-related files and recovery activities in an Oracle database.

A flashback feature that lets you recover the entire database to a specific point in time in the past.

A flashback feature that retrieves a table after it has been dropped without using other more complicated and disruptive recovery techniques such as point-in-time recovery or flashback database.

A feature of the Oracle database that allows a user to view the contents of a table as of a user-specified point in time in the past. How far in the past a flashback query can retrieve rows depends on the size of the undo tablespace and on the setting of the UNDO_RETENTION system parameter.

A flashback feature that allows you to recover one or more existing tables to a specific point in time. Flashback table is done in place by rolling back only the changes made to the table or tables and their dependent objects, such as indexes.

A relationship between two tables. The foreign key defined on a table refers to the primary key or unique key of another table.

A backup that includes all blocks of every data file backed up in a whole or partial database backup.

A join between two tables that returns rows based on the matching condition, as well as unmatched rows from the table on the right and left of the JOIN clause.

A PL/SQL program that returns a value and is called in an expression.

One of the Heterogeneous Services offered by Oracle that allows for connectivity solutions based on third-party connection options such as OLEDB (a Microsoft standard) and Open Database Connectivity (ODBC). See also Heterogeneous Services.

A backup that makes a copy of all data blocks that have changed since a previous baseline backup.

A backup that applies an incremental backup to an image copy, reducing the amount of time required in the event of media recovery.

A data structure that physically organizes data from a table in order to improve table access speed.

A single occurrence of an index value.

A subquery that appears in the FROM clause. This type of subquery is similar to selecting from a view.

A join that selects only matching rows of both tables. This is the default type of join.

SQL statement used to add rows to a table.

The Oracle system global area (SGA) and all the Oracle background processes.
See also system global area (SGA).

A circumstance in which the database instance fails unexpectedly because of a power outage or the failure of an Oracle background process.

The process of synchronizing the contents of each data file with the control file during instance startup using the online redo log files and data in the undo tablespace.

Constraints that protect the data integrity. They are business rules defined in the database.

A type of firewall that monitors the network packet traffic on IP networks and filters out packets that either originated or did not originate from specific groups of machines.

The system global area (SGA) memory structure where Java code is cached. See also system global area (SGA).

The software that interprets and executes Java code inside the database.

A relationship between two tables specified by using common columns or a condition to join two tables together.

The unit of contiguous memory used within the system global area (SGA) for allocating space to the shared pool, database buffer cache, Java pool, and large pool.

The concept of spreading Oracle’s memory structures across two or more computers on an as-needed basis in order to maximize the performance of the application during peak usage and minimize the use of resources during low usage.

A web-based user interface that communicates with and centrally manages all the components within the Oracle enterprise. From a centralized location, Grid Control lets you monitor and administer the entire computing environment, including hosts, databases, listeners, application servers, HTTP servers, and web applications.

Clause used in queries to group aggregate data.

Clause used in queries to filter out aggregated results.