Create a TimesTen Performance Metrics Snapshot

A snapshot is a collection of performance metrics from a database. You can create a report comparing two snapshots to analyze the performance of your database.

To create a new snapshot of a database, make sure you are on the main SQL Developer page and that you have expanded the TimesTen connection in the connections navigator.

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

    The New TimesTen Metrics Snapshot dialog displays.

  2. In the Prompts tab of the New TimesTen Metrics Snapshot dialog, select the desired capture level from the Capture Level drop-down list:

    • TYPICAL: For a typical set of metrics. This level is appropriate for most purposes. This is the default capture level.

    • NONE: For metrics outside of SYS.SYSTEMSTATS only.

    • BASIC: For a minimal basic set of metrics.

    • ALL: For all available metrics.

    Make sure to use the same capture level for any two snapshots to be used in a report. An error dialog displays if you attempt to generate a report that compares two snapshots with different capture levels.

    You are now ready to create a new snapshot.

  3. Click Apply to create the snapshot.

    A confirmation dialog shows the ID number of the snapshot. TimesTen generates the snapshot ID.

  4. Click OK.

    TimesTen creates the snapshot with the specified snapshot ID. The snapshot ID is useful for creating TimesTen metrics reports.

Related Topics

SQL Developer: TimesTen Tasks

SQL Developer Concepts and Usage