Oracle Communications Performance Intelligence Center (PIC) Software
 

PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec PIC
 

In this Document

Symptoms

Cause

Solution

References

Created from <SR 3-12705208371>

Applies to:

Symptoms

Export of a daily KPI over several days can take few minutes even if there are few rows to exports.

For example, export of 30 days of a daily KPI which generate only 6 rows per days (total of 180 rows) take around 5 minutes.

Cause

In PIC 10.2, Management (NSP) Troubleshooting application (ProTrace) automatically split the query by slice of 1 hour when query period is above 1 hour.

In example above, NSP ProTrace runs 720 sub-queries which can take up to 5 minutes.

Export strategy to execute multiple 1 hour queries to export any duration. This will ensure that INDEX_RANGE_SCAN is used instead of INDEX_FULL_SCAN.

In case of less number of records the auto split may take more time (because of more number of queries to fetch less records) but it is a real advantage is when the number of records is huge for a given extraction period.

Solution

To disable this automatic split, please open a new SR for support engineer to apply the change (mention this KM in SR description).

Internal Procedure

Parameter SPLIT_ON_EXPORT can be changed with the following procedure:

1. Connect as tekelec on MGMT server
2. Connect on MGMT database in sqlplus as NSP user
   $ sqlplus /@nsp
3. Update parameter:
   SQL> UPDATE COR_SYSTEM_CONFIG SET CONFIGURATION_VALUE='false' WHERE CONFIGURATION_NAME='SPLIT_ON_EXPORT';
4. Commit changes:
   SQL> COMMIT;
5. New parameter will be taken into account at next login on MGMT GUI (logout if needed)

References

This solution has no attachment