No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

Database CPU load up to 100 because WEBTOS running abnormal

Publication Date:  2012-07-24 Views:  59 Downloads:  0
Issue Description
All operation of SLTS very slowly. 
NCP: TopEng-SLTS-NcpV300R002C003B042SPC001
TOS: v300r002c03b042
Oracle 9i.
Alarm Information
Oracle server CPU load 100%, all operations are very slowly.
Handling Process
R&D checked the code of TOS, TOS will check old test result when the it's first time opened.
We checked the table (t_single_test_task/t_single_test_result). Here have about 200,000 rows in this table.
We deleted older result (older than 30 days), the CPU is go back to 10%.
Root Cause
1. shutdown ORACLE, the CPU go to 0%; re-start ORACLE, the CPU 0%, wait 5-10 mins, the CPU go back to 100%;
2. Close all NCP/TOS services, the ORACLE CPU go to 0%.
So, the CPU is used by service (NCP/TOS).
3. Start NCP, CPU is 0%;
4. Start TOS, CPU is 100%.
Suggestions
Change the flow of TOS, optimize ORACLE loading.

END