ttIndexAdviceCaptureDrop

This procedure drops existing capture data for either the current connection or for the database. Subsequent calls to ttIndexAdviceCaptureOutput at that level return no 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 privileges to drop a connection level capture.

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

ttIndexAdviceCaptureDrop([captureLevel])

Parameters

ttIndexAdviceCaptureDrop has this optional parameter:

Parameter Type Description

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

captureLevel

TT_INTEGER

Supported values for the capture level are:

0 - Index advice capture is dropped at the connection level for the current connection. This is the default.

1 - Index advice capture is dropped at the database level.

Result Set

ttIndexAdviceCaptureDrop returns no results.

Examples

CALL ttIndexAdviceCaptureDrop;

Notes

To drop both connection level and database level captures, invoke the command twice, once for each capture level.
It is an error to call this command while a capture is in progress at the level you are attempting to drop.