REFRDEL_CLEANUP Procedure

Previous TopicNext TopicContents

This procedure deletes records from the REFRDEL table based on the value of the KeepInterval setting. The default setting keeps the REFRDEL records from the last five days.

Refer to the following table for information about the settings associated with the REFRDEL_CLEANUP procedure:

REFRDEL_CLEANUP Settings

Setting Description: The oldest records to keep in the REFRDEL table.

Namespace

database.cleanup.Refrdel

Setting Name

KeepInterval

Default Setting

5d

Type

Interval

Setting Description: Identifies the maximum number of minutes before records are deleted from the REFRDEL table.

Namespace

database.cleanup.Refrdel

Setting Name

DaysToDelete

Default Setting

1

Type

Numeric

Setting Description: Determines the number of minutes that is added to each delete step interval.

Namespace

database.cleanup.Refrdel

Setting Name

IntervalStep

Default Setting

15

Type

Numeric

Related Topics

DAMON (Data Monitor) Procedures

BGPLOG_CLEANUP Procedure

REFRDEL Bypass Procedure

CLEANUP_PRMQUEUE Procedure

USESSION_CLEAR_LOGICAL_DELETES Procedure

CLEANUP_LOGICAL_DELETES Procedure

PRMAUDIT_CLEANUP Procedure

CLEANUP_USESSAUD Procedure

USER_DEFINED_BACKGROUND Procedure



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, February 04, 2016

PDF Library