SQL Explorer

Procedure

1. Log in to the DAS console using your username and password.
2. On the Overview page, click Go to CloudDBA.
3. Locate your desired instance and click Details to go to the Cloud DBA overview page.
4. On the SQL tab page, click SQL Explorer to view the full SQL details of the current instance.
5. On the SQL Statements tab page, click Enable DAS SQL Explorer. Query the SQL statements executed by the current instance by different criteria, including time range, user, keyword, and database.
   Note

   A maximum of 10,000 SQL statements can be displayed. If you need to view more, click Export to export them.

   A maximum of 100,000 records can be exported.

6. On the SQL Templates tab page, select a time range as required to view SQL templates and their statistical information, such as the average execution duration.
7. On the SQL Statement Types tab page, view the historical executions of SQL statements, including SELECT, UPDATE, and DELETE statements.