All operation of SLTS very slowly.
Oracle server CPU load 100%, all operations are very slowly.
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%.
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%.
Change the flow of TOS, optimize ORACLE loading.