View the TimesTen Index Advisor Capture State

The TimesTen index advisor capture state allows you to view the status of connection and database level captures. To view the TimesTen index advisor capture state for a database, make sure you are on the main SQL Developer page.

  1. Right-click the name of the database and select Index Advisor, then select Index Advisor Capture State.

    The Index Advisor Capture State dialog displays and you see the current status of connection and database level captures.

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

    • Connection ID

      The connection ID of the connection that initiated the TimesTen index advisor capture.

    • Capture Level

      The capture level of the TimesTen index advisor capture. This value can be Connection or Database.

    • Capture Mode

      The capture mode of the TimesTen index advisor capture. This value can be Execute SQL or Prepare SQL.

    • Capture State

      The capture state of the TimesTen index advisor capture. This value can be In Progress or Completed.

    • Prepared Count

      The number of prepared SQL statements during the capture period.

    • Execute Count

      The number of executed SQL statements during the capture period.

    • Start Time

      The timestamp of when the index advisor capture began. The timestamp format is YYYY-MM-DD HH:MI:SS.FF, where YYYY is the year, MM the month, DD the day, HH the hour, MI the minutes, SS the seconds, and FF the milliseconds.

    • End Time

      The timestamp of when the index advisor capture ended. The timestamp format is YYYY-MM-DD HH:MI:SS.FF, where YYYY is the year, MM the month, DD the day, HH the hour, MI the minutes, SS the seconds, and FF the milliseconds. This value is empty if the Capture State is in In Progress.

  2. Click Refresh to update the table with the most current information of the TimesTen index advisor captures.

    The Index Advisor Capture State dialog is refreshed with the most recent capture state information.

Related Topics

SQL Developer: TimesTen Tasks

SQL Developer Concepts and Usage