Done. Chapter 14: Maintaining the Database and Managing Performance

Flashcards to help review key concepts related to maintaining the database and performance management in Oracle Database 12c.

Automatic Workload Repository (AWR)

A data repository that collects, analyzes, and maintains performance statistics of the database.

Automatic Database Diagnostic Monitor (ADDM)

A feature that automatically analyzes AWR data to identify potential performance issues.

SQL Tuning Advisor

An advisor that provides recommendations for improving SQL performance.

Optimizer Statistics

Statistical data that describe the contents of the database, used by the optimizer to determine the best execution plan.

Proactive Monitoring

Monitoring that allows DBA to identify and respond to performance issues before they impact users.

Reactive Monitoring

Monitoring done after a performance issue has occurred, often leading to delays in resolution.

Dynamic Performance Views

Views in Oracle that provide real-time information about various aspects of database performance.

Memory Management

The process of controlling and optimizing the allocation of memory resources within the database.

Automatic Memory Management (AMM)

A feature in Oracle 12c that automatically adjusts sizes of SGA and PGA based on workload.

Threshold Alerts

Alerts triggered when specified resource usage levels reach critical or warning conditions.

SQL Access Advisor

An advisor that provides recommendations for schema modifications to improve data access paths.

DBMS_STATS

A PL/SQL package in Oracle used to manage statistics for database objects.

Active Session History (ASH)

A mechanism that samples active sessions in real-time to provide insights into session activity.

Automatic Diagnostic Repository (ADR)

A storage framework for database diagnostic data, including alert logs and trace files.

SQL Profiles

Auxiliary statistics specific to a SQL statement created by the SQL Tuning Advisor to improve execution.

Data Dictionary Views

Metadata structures in Oracle that provide information about the database environment and objects.

Performance Statistics

Data used to measure and analyze the efficiency and effectiveness of database operations.