Reports

Predefined reports are SQL queries that run against the connected database instance.

The Reports feature provides many built-in reports to query and monitor the database and its objects. These reports cover a range of database administration, performance monitoring, and diagnostic needs.

The different types of reports available are Grid, Charts and PL/SQL DBMS_OUTPUT.

Some examples of predefined reports are:

• Top SQL by Execution Time: Displays the SQL queries with the highest execution times. Useful for performance tuning.

• Database Instance Details: Shows information about the database version, instance name, and startup time.

• Active Sessions: Lists currently active sessions along with key metrics like CPU usage and memory allocation.

Prerequisites

You require a database connection and relevant permissions to access the database views and objects queried by the report.

Accessing a Report

To open a report:

1. Expand the Reports panel in the left pane.

   The reports are organized into several categories to help users quickly locate relevant reports such as Database Administration, Data Dictionary, Security and so on.

2. Expand a report category and select a report. You are prompted to select the database connection for which to display the report.

   Some reports may prompt you to select binds (for example, date ranges, schema names) before generating the report. To specify a bind variable, type an entry in the Value column and click Apply.

User Actions on a Report

For more details if available, you can click on a row in a report to view more details about that entry in a bottom panel.

Click Open in Worksheet icon to display the SQL statement used to retrieve the information for a report in a SQL Worksheet pane, where you can view, edit, and run the statement.

The default options in the context menu for the report table are Single Record View and Export. Right-click in a report table and select Export to export a report to CSV, PDF, HTML or other formats. The context menu might include more options, which are based on the selected report.