| Asset ID: |
1-71-2310737.1 |
| Update Date: | 2017-09-27 |
| Keywords: | |
Solution Type
Technical Instruction Sure
Solution
2310737.1
:
How to Purge Regularly NSP_CONF Tablespace ?
| Related Items |
- Oracle Communications Performance Intelligence Center (PIC) Software
|
| Related Categories |
- PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec PIC
|
In this Document
Created from <SR 3-15450220204>
Applies to:
Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.2.0 and later
Information in this document applies to any platform.
Goal
In some cases MLOG$_CFG_XDR_SESSION table will grow and fill up the NSP_CONF tablespace. This KM explains how to setup a cron job to purge it on a regular basis.
Solution
- Log as root on the NSP oracle server
- Use "crontab -e" command to edit the cron job list and add the following line:
00 8 * * 6 su - tekelec -c 'echo -e "truncate table MLOG\$_CFG_XDR_SESSION;" |sqlplus /@NSP' >/tmp/truncate.log 2>&1
- Save and exit.
- Every saturday at 8am the MLOG$_CFG_XDR_SESSION table will be purged.
Attachments
This solution has no attachment
