SQL Tuning Health-Check Script (SQLHC)

SQL Tuning Health-Check Script (SQLHC)

Ahmet Duru?z Ahmet Duru?z

Ahmet Duru?z

Senior Oracle , PostgreSQL , MySQL DBA | Instructor | Exadata Administrator | Oracle ACE ??

发布日期: 2023年5月19日
+ 关注

Also known as SQLHC, this tool is used to check the environment in which a single SQL statement is running, Cost-based Optimizer (CBO) statistics, schema object metadata, configuration parameters, and other elements that can affect the performance of a SQL .

SQLHC does not require any license and is free.?You can download the script from the link below.

SQL Tuning Health-Check Script (SQLHC)

The health check with the script is carried out for the following elements.

  • CBO Statistics for schema objects accessed by an analyzed SQL statement
  • CBO Parameters
  • CBO system statistics
  • CBO Data Dictionary statistics
  • CBO Fixed-objects statistics

With this script, you can analyze a query in detail.?You can see system-wide recommended actions for better query operation.

You can run the script as follows.?The 1st parameter is the Oracle Pack license in the current database (in the form of Tuning, Diagnostics or None [T|D|N]), the 2nd parameter is the sql_id of the query to be analyzed. 

# sqlplus / as sysdba
SQL> @/home/oracle/sqlhc.sql T 9dhprx5z3m36h

要查看或添加评论，请登录

Ahmet Duru?z的更多文章

  • Exadata - Disk scrubbing
    2023年5月23日

    Exadata - Disk scrubbing

    Disk scrubbing exists on Exadata cell nodes to automatically repair bad sectors of the disk when the system is idle…

  • How to determine the last modified date of tables in Oracle ?
    2023年5月23日

    How to determine the last modified date of tables in Oracle ?

    For each row in a table, ORA_ROWSCN returns the SCN of the most recent change in the row. This pseudo-column can be…

  • Oracle Data Redaction
    2023年5月23日

    Oracle Data Redaction

    Available with the Oracle Advanced Security license, Oracle Data Redaction allows you to mask (redact) data returned…

  • Active requests on Exadata cell node
    2023年5月19日

    Active requests on Exadata cell node

    An active request represents a client- or application-centric view of I/O requests handled by the cell node. You can…

  • Principle of Least Privilege for Oracle databases
    2023年5月19日

    Principle of Least Privilege for Oracle databases

    An important concept in computer security, the principle of least privilege (POLP) is to limit users' access rights to…

  • Read Only Table Partitions
    2023年5月19日

    Read Only Table Partitions

    As of Oracle version 12.2, partitions or sub-partitions of a table can be marked as read-only.

  • Hybrid Columnar Compression
    2023年5月19日

    Hybrid Columnar Compression

    Hybrid Columnar Compression (HCC) is a feature that comes with Oracle Database 11g Release 2 and can be used with…

  • Usefully My Oracle Support (MOS) documentation on Oracle Exadata Database Machine
    2023年5月19日

    Usefully My Oracle Support (MOS) documentation on Oracle Exadata Database Machine

    There are MOS documents on many topics related to Exadata. You can find the most useful of these documents in the list…

社区洞察

其他会员也浏览了