Oracle Fachvokabular

An Oracle background process that copies the online redo log files to an archived
log destination.

Operators used to manipulate information in the arithmetic expressions.
Addition (+), subtraction (–), multiplication (*), and division (/) are the arithmetic
operators.

The monitoring and recording of specific database activities.

The process that analyzes the data in the Automatic Workload Repository (AWR) to identify
sources of potential performance bottlenecks and that recommends solutions for correcting
the problem. See also Automatic Workload Repository (AWR).

Tasks performed by Oracle Database to gather database
statistics, run the segment-space advisor periodically, and so on.

A type of storage mechanism that is new in
Oracle 10g. Oracle manages the storage definitions of the database within a second database
used exclusively by ASM to keep track of the disk allocations for your databases.

A mechanism to manage the memory requirement automatically by allocating the total memory to Oracle. Oracle will manage the SGA and PGA based on demand.

mechanism to manage the shared memory requirement automatically by allocating the memory to Oracle. Oracle will manage
the individual pools in SGA based on demand.

The collection of tables, owned by the SYSMAN schema, that stores the performance statistics gathered from the system global area (SGA)
by the Memory Monitor (MMON) background process.

An index database object that organizes table data in a binary tree format.

A method of backing up the control file contents to a text file in the location specified.

A set of Recovery Manager (RMAN) files that contains the saved data from a backup.

The tables used to define a view.

A collection of performance statistics against which current or future database performance is measured to determine whether a significant performance deviation has occurred.

A tablespace built on a single data file that can be up to 232 data blocks in size.

Operators that take two operands. All operators are binary, except the + or – used to represent the sign of a numeric value.

An index database object that organizes table data in a series of bitmaps. A bitmap index is analogous to a two-dimensional matrix, where index keys and table rows are the axes.

The smallest unit of data storage in the database.

A file that tracks the blocks changed since the last incremental backup, saving time during an incremental backup because not all blocks in every data file need to be checked for changes.

The number of distinct values. If a table has a cardinality of 1,000, it has 1,000 rows. If a column has a cardinality of 30, it has 30 distinct values (there may be 1,000 rows but only 30 distinct values).

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

An expression that can be used to derive IF... THEN... ELSE logic in SQL.

A description of a change made to a single block in the database.

Datatype used to store fixed-length character data.

An event during which the dirty data-block buffers are flushed to disk and database files are updated to reflect this action. The database is put into a consistent state.

process The Oracle background process that updates the control file and the data file headers to reflect the last successful transaction by recording the last system change number (SCN).

The vertical space in a table or a view that holds a specific domain of data. In the relational model, an entity has attributes. When this model is implemented in an Oracle Database, an entity becomes a table, and an attribute becomes a column.

Another name for the column to display with the query results. Alias names can provide meaningful names for the result set.

The SQL command for making permanent the changes made during a transaction.

Operators that compare two values or expressions and give a Boolean result of TRUE, FALSE or NULL.

A join that includes additional filter criteria along with the join conditions in the WHERE clause.

A query that includes a set operator to join two or more queries.

Operator used to join two text strings. The operator is ||.

The condition where many users/sessions can access and modify data at the same time.