RESET_AUTO_OPTIMIZE_STATUS

Use the RESET_AUTO_OPTIMIZE_STATUS procedure to reset (or delete the contents of) the CTX_AUTO_OPTIMIZE_STATUS view.

You must log on as CTXSYS to run CTX_ADM.RESET_AUTO_OPTIMIZE_STATUS.

Syntax

CTX_ADM.RESET_AUTO_OPTIMIZE_STATUS;

Example

begin
   ctx_adm.reset_auto_optimize_status;
end;