Lernkarten

Karten 300 Karten
Lernende 0 Lernende
Sprache English
Stufe Andere
Erstellt / Aktualisiert 23.02.2017 / 23.02.2017
Lizenzierung Keine Angabe
Weblink
Einbinden
0 Exakte Antworten 300 Text Antworten 0 Multiple Choice Antworten
Fenster schliessen

Active Session History (ASH)

 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.

Fenster schliessen

aggregate functions

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.

Fenster schliessen

alert log file

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

Fenster schliessen

anonymous block

An unnamed PL/SQL program.

Fenster schliessen

archived redo log file

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.

Fenster schliessen

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.

Fenster schliessen

ARCn

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

Fenster schliessen

arithmetic operators

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