Good evening, i need your help please
I will try to describe the scenario briefly: In a Telecom Production system application receives a certain files called CDRs(call detail records) to be processed by doing some operating systems operations and then database operations like creating indexes and uploading to a Central Database-
The applications server and database is quite obsolete OSF1 and oracle 9i.
Many times the applications turn very slow to process so performance is overheated. Of course There would be many causes for overheated performance, and it is premature to identify the problem at first glance.
So Could you tell me if below theories could affect Performance ?
- I run netstat command and displays more than 102 connections some of them established state, some of them time wait, etc. So the question is having many connections could affect the performance of the application?
If I killed and restart connections would be a good idea to improve performance?
- Having one or more Filesystem backups could affect Performance too ?
I appreciate your answers in advanced or if u have any other reason that could impact its performance let me know. Thanks