ttIndexAdviceCaptureEnd

This procedure ends either an active connection level capture from the current connection or an active database level capture.

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 end a connection level capture.

This procedure requires ADMIN privileges to end 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

ttIndexAdviceCaptureEnd([captureLevel])

Parameters

ttIndexAdviceCaptureEnd has this optional parameter:

Parameter Type Description

Parameter	Type	Description
`captureLevel`	`TT_INTEGER`	Supported values for the capture level are: `0` - Ends index advice capture at the connection level for the current connection. This is the default. `1` - Ends index advice capture at the database level.

captureLevel

TT_INTEGER

Supported values for the capture level are:

0 - Ends index advice capture at the connection level for the current connection. This is the default.

1 - Ends index advice capture at the database level.

Result Set

ttIndexAdviceCaptureEnd returns no results.

Examples

The following example ends the collection for the connection level capture:

CALL ttIndexAdviceCaptureEnd(0);

Notes

To end both connection level and database level captures, invoke the command twice, once for each capture level.
It is an error to call this procedure without first starting a capture at the specified level by calling the ttIndexAdviceCaptureStart procedure.