Forem

Pranav Bakare
Pranav Bakare

Posted on

AWR, ADDM, and ASH in Oracle SQL

AWR, ADDM, and ASH are not part of Oracle SQL constructs but are part of Oracle Database features designed for performance monitoring and tuning. These tools are built into the Oracle Database engine and leverage internal data and metadata to provide insights into database performance.


Clarification:

  1. Oracle SQL Constructs:
    These are core components of the SQL language (e.g., SELECT, INSERT, JOIN, subqueries, etc.) that are used to interact with and manipulate data in the database.

  2. Oracle Database Features:
    Tools like AWR, ADDM, and ASH are performance monitoring and diagnostic features provided by Oracle to help database administrators (DBAs) analyze and optimize database performance.

They rely on SQL to gather and display their data but are not themselves part of the SQL language.


Key Understanding:

AWR, ADDM, and ASH operate on the Oracle database layer, not the SQL construct layer.

They are enabled and managed using Oracle's internal systems (e.g., PL/SQL procedures, system views) and GUI tools like Oracle Enterprise Manager.

Speedy emails, satisfied customers

Postmark Image

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up

Top comments (0)

Billboard image

Create up to 10 Postgres Databases on Neon's free plan.

If you're starting a new project, Neon has got your databases covered. No credit cards. No trials. No getting in your way.

Try Neon for Free →