Glossary

A

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.

ADDM

See Automated Database Diagnostic Monitoring (ADDM).

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.

alert log file

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

anonymous ...

Get OCA Oracle® Database 11g Administrator Certified Associate: Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.