EMS :: Maximum Extents About To Be Reached For Table In Netboss

Asset ID:	1-71-2016020.1
Update Date:	2017-02-15
Keywords:

Solution Type Technical Instruction Sure

Solution 2016020.1 : EMS :: Maximum Extents About To Be Reached For Table In Netboss

Applies to:

Oracle Communications EAGLE (Software) - Version EMS 43.x and later
Tekelec

Goal

Maximum extents about to be reached for table: ALERT_TABLE current # of extents: 32768, maximum allowed extents: 327680

Solution

Increase the maximum number of extents for the table that is causing the alarm
Use following steps to increase extents. These steps are to be performed by an EMS support engineer and not by the customer:

1. Login to EMS DB:

sqlplus netboss/netboss

2. Increase maximum extents of table using following command:

alter table <tablename> storage(maxextents <new value of max extents>);

For example to change max extents to 8192 for table L_OCCUR:

alter table L_OCCUR storage(maxextents 8192);

Attachments

This solution has no attachment