Drop a TimesTen Performance Metrics Snapshot

Consider dropping unneeded snapshots to free up permanent space. If you need to save more snapshots of your database, consider editing the TimesTen performance metrics configuration. See "Editing the TimesTen performance metrics configuration" in the Oracle SQL Developer Oracle TimesTen In-Memory Database Support User's Guide.

To drop a new snapshot from 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 Drop Snapshot.

  2. By default, the Prompts tab of the Drop TimesTen Metrics Snapshot(s) dialog is selected. In the Selector column, select the snapshots you want to drop.

    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 you select to determine the snapshots that you want to drop.

    • 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.

    To select all snapshots, click the Select all check box.

  3. Once you have selected the snapshots that you want to drop, click the Apply button.

    A Confirm dialog displays asking you if you want to proceed with dropping the selected snapshots.

  4. Click Yes.

    A confirmation dialog displays a message indicating that one or more TimesTen Metrics snapshots were dropped.

  5. Click OK.

    You successfully dropped the TimesTen metrics snapshots.

Related Topics

SQL Developer: TimesTen Tasks

SQL Developer Concepts and Usage