Oracle Fachvokabular

The physical database files that store the database’s segments, such as tables, indexes, rollback, and partition.

A characteristic assigned to each column in a table that defines what type of data can be stored in the column and its valid values.

Datatype used to store date and time information.

A cumulative measure of time spent by the database responding to user requests, including wait times for access to resources such as memory, disk, and CPU for all nonidle user sessions.

The Procedural Language SQL (PL/SQL) package that is an API to Data Pump.

A special kind of lock conflict that prevents two or more transactions from completing because each transaction has a lock on a resource needed by the other transaction.

Constraints that are not enforced. These constraints will have a state of DISABLE NOVALIDATE.

A type of connection in which every client connection has an associated dedicated server process on the machine where the Oracle server exists. See also shared server process.

A role initially enabled for every user session.

The tablespace where a user’s tables and indexes are stored if not declared explicitly.

Constraint checking that is deferred to a transaction level. By default, constraints are checked at the statement level.

An optional schema object that restricts values in the dependent table to a specified condition. Constraints enforce business rules about data.

A small binary file that contains metadata about the physical structure of the database, such as the database name, locations of the data files and redo logs, and recovery information.

Single-row functions used to convert the datatype of input between numeric, character, and datetime values.

A subquery that references the column names of the parent query.

The Oracle optimizer mode that uses statistics about the size, selectivity, and dispersion of the tables and indexes in the database to formulate the most efficient execution plan.

A join that joins two tables with no common condition, also known as a Cartesian join. Each row from the first table is joined against every row in the second table.

The sequence pseudocolumn that will return the last number generated from the sequence-number generator.

The smallest unit of disk allocation in data or temp files, composed of one or more file-system blocks.

The category of SQL commands used to create objects in the database, including CREATE, ALTER and DROP.

The category of SQL commands used to create, modify, or remove data from a table, including INSERT, UPDATE and DELETE.

A tool to identify failures, recommend resolution, and perform recovery action.

A collection of control files, data files, and redo logs.

The portion of the system global area (SGA) where copies of the data blocks are cached in memory. See also system global area (SGA).

A Java-based tool you can use to create Oracle databases. The DBCA can store and manage definitions of your databases in the form of templates that can be used to make copies of a database.

SQL statement used to remove rows from a table.

Parameter specifying the location of the parent directory where all trace, log, and dump files will be written on the server.

A database object that identifies a file-system location. Directory objects are used by Data Pump jobs.

A process in an Oracle Shared Server environment that manages requests from one or more client connections.

A dummy table in the Oracle Database. DUAL has one column and one row. It is mainly used to query the system variables such as SYSDATE and USER.

The ability of an Oracle instance to automatically register its existence with a listener.

The command-line utility used to stop and start the Oracle Management agent.

The web-based GUI tool for managing Oracle environments.

Variables that define the SQL*Plus environment. These variables are set using the SET command. The SHOW command is used to display the value of the variables.