A

ADDM

See Automated Database Diagnostic Monitoring (ADDM).

anonymous block

An unnamed PL/SQL program.

Application Server Control

A web-based component of Enterprise Manager (EM) that monitors Oracle Application Server 10g (9.0.4). The Application Server Control lets you monitor and administer a single Oracle Application Server instance, a collection of Oracle Application Server instances, or Oracle Application Server clusters.

archived redo log file

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

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.

ARCn

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

ASM

See Automated Storage Management (ASM).

auditing

The monitoring and recording of specific database activities.

Automated Database Diagnostic Monitoring (ADDM)

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

Automated Storage Management (ASM)

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.

Automatic Workload Repository (AWR)

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

AWR

See Automatic Workload Repository (AWR).