My Oracle Support Banner

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

Last updated on NOVEMBER 06, 2019

Applies to:

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


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


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:


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).


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.