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:
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.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.
Top comments (0)