Truncating SLEE_* Tables while OCSG is On-line (Doc ID 2055507.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Communications Services Gatekeeper - Version 4.1.1 and later
Information in this document applies to any platform.

Goal

We have a question from a customer if it's possible to truncate the below tables while OCSG is on-line:

TABLE_NAME
------------------------------
SLEE_CHARGING
SLEE_ALARM
SLEE_STATISTICS_DATA


Reference from <Document 1282176.1>:

There are three tables in the Services Gatekeeper database that the System Administrator must periodically clean manually to prevent them from growing too large:

- SLEE_ALARM
- SLEE_CHARGING
- SLEE_STATISTICS_DATA

Use the instructions provided for your database to delete rows from these tables.
Oracle recommends to clean the SLEE_STATISTICS_DATA table once a month and the SLEE_ALARM table every two months.

The interval for cleaning the SLEE_CHARGING table depends on the amount of charging traffic, so it is difficult to specify a recommended interval. There is usually one row in this table per plug-in transaction. A row can contain up to 300 bytes of data.
Typically operators export charging data from the SLEE_CHARGING table to a file either by using a scheduled script or by integrating with a billing system.

Charging data is contained in charging data records (CDRs), which is a type of event data record (EDR).
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms