9.3.1.20 tfactl purgeindex

Use the tfactl purgeindex command to index events.

Syntax

tfactl purgeindex -category result | metadata
[-json JSON String]
[-last nh|d]

Parameters

Table 9-60 tfactl purgeindex Command Parameters

Parameter Description

-json

Deletes the indexed events matching the JSON string specified.

-last nh|d]

Specify hours or days to delete index since the previous n hours or days.

-category result

Purges Oracle ORAchk and Oracle EXAchk compliance check run results.

-category metadata

Purges Oracle ORAchk and Oracle EXAchk compliance check run metadata.

Configure Compliance Index Threshold

You can set compliance index purge policy.
  • If the compliance runs exceed the threshold (default 30), then delete all older records above the threshold (event based, that is, on every index request).
  • If the compliance run is below the threshold and the size of index exceeds the threshold, then delete last run data (periodic).

Example 9-72 tfactl purgeindex

tfactl purgeindex -category result
Successfully deleted Index.

Example 9-73 Compliance Index Threshold

tfactl set maxcomplianceruns=60
Successfully set maxcomplianceruns=60
.---------------------------------------------------------------------.
|                           testhost                                  |
+-------------------------------------------------------------+-------+
| Configuration Parameter                                     | Value |
+-------------------------------------------------------------+-------+
| Maximum Compliance Runs to be Indexed ( maxcomplianceruns ) | 60    |
'-------------------------------------------------------------+-------'
tfactl set maxcompliancesize=100
Successfully set maxcompliancesize=100
.------------------------------------------------------------------.
|                          testhost                                |
+----------------------------------------------------------+-------+
| Configuration Parameter                                  | Value |
+----------------------------------------------------------+-------+
| Maximum Compliance Index Size (MB) ( maxcompliancesize ) | 100   |
'----------------------------------------------------------+-------'
tfactl get maxcompliancesize
.------------------------------------------------------------------.
|                          testhost                                |
+----------------------------------------------------------+-------+
| Configuration Parameter                                  | Value |
+----------------------------------------------------------+-------+
| Maximum Compliance Index Size (MB) ( maxcompliancesize ) | 150   |
'----------------------------------------------------------+-------'
tfactl get maxcomplianceruns
.---------------------------------------------------------------------.
|                           testhost                                  |
+-------------------------------------------------------------+-------+
| Configuration Parameter                                     | Value |
+-------------------------------------------------------------+-------+
| Maximum Compliance Runs to be Indexed ( maxcomplianceruns ) | 30    |
'-------------------------------------------------------------+-------'