Create a TimesTen Performance Metrics Report

TimesTen performance metrics reports use the data from two specified snapshots of TimesTen metrics to produce a report in HTML format. TimesTen metrics reports include information for each metric. For more information about the various metrics displayed in the report, see "Report examples" in the Oracle TimesTen In-Memory Database Reference.

To generate a new report for a database, make sure you are on the main SQL Developer page.

  1. Right-click the name of the database and select TimesTen Performance Metrics, then select Report.

    The Create TimesTen Metrics Report dialog displays.

  2. By default, the Report generator tab of the Create TimesTen Metrics Report dialog is selected. In the Selector column, select two snapshots to compare.

    You can also click on the column header to sort the table based on the column. A description of each column follows:

    • Selector

      The check box that determines the snapshots that are compared in the metrics report. Make sure to only select two snapshots with the same capture level. An error dialog displays if you attempt to generate a report that compares more than two snapshots.

    • Snapshot

      The snapshot ID of the snapshot.

    • Timestamp

      The timestamp of when the snapshot was captured.

    • Capture Level

      The capture level of the snapshot. This value can be TYPICAL, NONE, BASIC, or ALL.

  3. Once you have selected two snapshots with the same capture level, click the Generate report button. An error dialog displays if you attempt to generate a report that compares snapshots with different capture levels.

    TimesTen generates your TimesTen metrics report. You can view the generated TimesTen metrics report in the pane located below the Generate report button.

    For more information about the various metrics displayed in the report, see "Report examples" in the Oracle TimesTen In-Memory Database Reference.

  4. If you do not want to save the report, click Close. If you want to save the report, see Save a report.

Save a report

If you want to save the report for future reference, follow these steps:

  1. Click Save.

    The Save dialog displays.

  2. Select the directory where you want to save the TimesTen metrics report.

  3. In the File Name field, define the name of your TimesTen metrics report.

    The default filename of the TimesTen metrics report is ttstats-snapshot_id_1-snapshot_id_2-YYYYMMDDHHMISS.html, where snapshot_id_1 and snapshot_id_2 are the snapshot IDs of the two snapshots you are comparing in your report. YYYYMMDDHHMISS is a timestamp of when the report was generated, where YYYY is the year, MM the month, DD the day, HH the hour, MI the minutes, and SS the seconds.

  4. Click Save.

    SQL Developer saves your report.

Related Topics

SQL Developer: TimesTen Tasks

SQL Developer Concepts and Usage