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.

Related Views

This procedure has no related views.

Syntax

ttIndexAdviceCaptureEnd([captureLevel])

Parameters

ttIndexAdviceCaptureEnd has this optional parameter:

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.

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.

See Also