ttRekeyStatus

This procedure displays the currently running or last completed rekey operation. If a rekey operation is in progress, it displays information about the ongoing rekey operation.

Required Privilege

This procedure requires ADMIN privileges.

Related Views

This procedure has this related view.

SYS.V$REKEY_STATUS

Syntax

ttRekeyStatus()

Parameters

ttRekeyStatus has no parameters.

Result Set

ttRekeyStatus returns the result set:.

Column Type Description

status

TT_VARCHAR (200) NOT INLINE NOT NULL

Information about the progress or completion of the last rekey operation.

Possible values include the following:

  • Never rekeyed

  • In progress

  • Rekey done

  • Rekey failed

startTime

TT_TIMESTAMP

Time when the rekey operation started.

endTime

TT_TIMESTAMP

Time when the rekey operation completed.

If this column is NULL and the startTime column is not NULL, a rekey operation is in progress.

rekeyCount

TT_INTEGER

Count of how many rekey operations have completed.

Examples

The following example shows an example result set for a call to ttRekeyStatus. 

Command> CALL ttRekeyStatus();
< Rekey done, 2025-09-11 22:19:39.044642, 2025-09-11 22:19:39.997542, 1 >
1 row found.