ttIndexAdviceCaptureInfoGet

This procedure returns a row for each active capture. A capture is active if it has started capturing index advice or if it has stopped capturing index advice, but the capture data is still available.

One row relates to a connection level capture, if one exists. Another row relates to a database level capture, if one exists. At most there is one connection level and one database capture.

If no capture is in progress or no data exists, this procedure does not return any rows.

This procedure and the procedures related to it are referred to as the Index Advisor. For details on using these procedures, see Using the Index Advisor to Recommend Indexes in the Oracle TimesTen In-Memory Database Operations Guide.

Required Privilege

This procedure requires no privilege to get information on a connection level capture.

This procedure requires ADMIN privileges to get information on a database level capture.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic.

TimesTen Scaleout applications can call this built-in procedure.

In TimesTen Scaleout, this procedure runs locally on the element from which it is called.

Related Views

This procedure has no related views.

Syntax

ttIndexAdviceCaptureInfoGet()

Parameters

ttIndexAdviceCaptureInfoGet has no parameters.

Result Set

ttIndexAdviceCaptureInfoGet returns the result set:

Columns	Type	Description
`captureState`	`TT_INTEGER NOT NULL`	The state of the capture: `0` - A capture is not in progress. `1` - A capture is in progress.
`connID`	`TT_INTEGER`	The connection ID of the connection that initiated the last capture, or the current capture if one is in progress. This row is not returned if no capture has been initiated.
`captureLevel`	`TT_INTEGER`	The level of the most recent capture. This row is not returned if no capture has been initiated.
`captureMode`	`TT_INTEGER`	The mode of the most recent capture. This row is not returned if no capture has been initiated.
`numPrepared`	`TT_INTEGER`	The number of prepared statements during the capture period. This value is `NULL` if no capture has been initiated.
`numExecuted`	`TT_INTEGER`	The number of executed statements during the capture period. This value is `NULL` if no capture has been initiated.
`captureStartTime`	`TT_TIMESTAMP`	The time stamp taken at the start of the capture period. This row is not returned if no capture has been initiated.
`captureEndTime`	`TT_TIMESTAMP`	The time stamp taken at the end of the capture period. This value is `NULL` if no capture is still in progress.

Examples

This example shows capture information for a completed connection level capture for 363 prepared statements and 369 executed statements:

CALL ttIndexAdviceCaptureInfoGet();
< 0, 1, 0, 0, 363, 369, 2018-02-27 11:44:08.136833, 
2018-02-27 12:07:35.410993 >
1 row found.

Note:

If there is an active database level capture and you call this procedure on a connection that does not have ADMIN privilege, TimesTen returns an error.