All Products
Search

This Product

    PolarDB:dbms_sql.flush_trace

    Document Center

    PolarDB:dbms_sql.flush_trace

    Last Updated:Dec 22, 2022

    You can use the dbms_sql.flush_trace stored procedure to clear all statistics and trace records generated by the SQL Trace feature in the information_schema.sql_sharing system table.

    Syntax

    dbms_sql.flush_trace()

    Example

    You can execute the following statement to clear all statistics and trace records generated by the SQL Trace feature in the information_schema.sql_sharing system table: 

    call dbms_sql.flush_trace();

    You can execute the following statement to query all statistics and trace records in the information_schema.sql_sharing system table: 

    select * from information_schema.sql_sharing\G

    The following output is returned:

    Empty set (0.00 sec)