Truncating SLEE_* Tables while OCSG is On-line
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.
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).
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