Pin_ledger_report Hangs in Export Mode and Consumes 100% CPU
(Doc ID 2210935.1)
Last updated on APRIL 03, 2023
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.5.0.15.0 and laterInformation in this document applies to any platform.
Goal
On : 7.5.0.15.0 version, General Ledger (GL)
pin_ledger_report hangs in export mode for 7019134 records for 1 given segment and consumes 100% CPU usage
Top command output:
top - 22:15:08 up 276 days, 22:22, 10 users, load average: 2.03, 4.21, 4.33
Tasks: 847 total, 7 running, 839 sleeping, 1 stopped, 0 zombie
Cpu(s): 12.6%us, 0.2%sy, 0.0%ni, 87.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 32941680k total, 30867316k used, 2074364k free, 174624k buffers
Swap: 67112956k total, 2372k used, 67110584k free, 21582940k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
49292 xxxx 20 0 2118m 2.1g 7160 R 99.7 6.6 3:25.30 pin_ledger_repo
49979 xxxx 20 0 13944 1796 856 R 1.0 0.0 0:02.69 top
29772 xxxx 20 0 5401m 5.0g 5.0g S 0.3 15.9 0:09.85 dm_oracle_billi
29994 xxxx 20 0 5503m 25m 16m S 0.3 0.1 0:00.13 dm_oracle_billi
30040 xxxx 20 0 5503m 22m 14m S 0.3 0.1 0:00.12 dm_oracle_billi
How to resolve this issue?
Solution
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
| Goal |
| Solution |
| References |