Weekly CCS_BE_CDR Database Table Partitions and "ORA-01688: unable to extend table" while Filesystem is Not Full (CCSPART)
(Doc ID 1373439.1)
Last updated on JANUARY 05, 2023
Applies to:
Oracle Communications Network Charging and Control - Version 4.2.0 and laterInformation in this document applies to any platform.
Symptoms
Pre-requisites
This document treats the same symptoms as Doc 1304330.1 but when the filesystem holding CCS_BE_CDR partitions has sufficient space to hold a new extent (usually 2001MB).
Please refer to Doc 1304330.1 to get a full understanding of CCSPART scripts and Oracle Partitioning for CCS_BE_CDR.
Extract
CCSPART Capacity Monitor script runs hourly basis (primary cluster node only) and raises alarms if problems related to capacity are detected.
Monitors Veritas disk group storage and raises an alarm if the storage utilization level is above the specified threshold.
Monitors tablespace storage of the current week and raises an alarm if the storage utilization level is above the specified threshold. Will optionally extend the current tablespace to create more capacity.
CCSPART Capacity Monitor script runs hourly basis (primary cluster node only) and raises alarms if problems related to capacity are detected.
Monitors Veritas disk group storage and raises an alarm if the storage utilization level is above the specified threshold.
Monitors tablespace storage of the current week and raises an alarm if the storage utilization level is above the specified threshold. Will optionally extend the current tablespace to create more capacity.
This is on the latest feature that this document will focus.
Symptoms
All the following symptoms must occur:
- CCS_BE_CDR partition is full:
Changes
Cause
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
Symptoms |
Pre-requisites |
Symptoms |
Changes |
Cause |
Solution |
References |