Lernkarten

 Sampled data at specified intervals from the current state
of all active sessions. The data is collected in memory and can be accessed by v$ views.

Functions that operate on groups of rows, also known as group
functions. The exact number of inputs for aggregate functions is not determined until the
query is executed and all rows are fetched. This differs from single-row functions, in which
the number of inputs is known at parse time, before the query is executed.

A file where Oracle Database writes information about the database startups,
shutdown, check points, redo log switches, errors, and warning information.

An unnamed PL/SQL program.

A file that contains the contents of a previously used redo log file.
It’s created only when the database is operating in ARCHIVELOG mode.

A database configuration in which redo log files are copied to the
archive log destination, which ensures that they won’t be overwritten and lost. These
archived logs are used primarily for media recovery.

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.