Home > SQL Developer: TimesTen Tasks > Create a TimesTen Performan...
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.
Right-click the name of the database and select TimesTen Performance Metrics, then select Report.
The Create TimesTen Metrics Report dialog displays.
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.
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.
If you do not want to save the report, click Close. If you want to save the report, see Save a report.
If you want to save the report for future reference, follow these steps:
Click Save.
The Save dialog displays.
Select the directory where you want to save the TimesTen metrics report.
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.
Click Save.
SQL Developer saves your report.
Related Topics