Having too many connections could affect performance ? Post: 302991307

Sponsored Content

Special Forums UNIX and Linux Applications Having too many connections could affect performance ? Post 302991307 by alexcol on Wednesday 8th of February 2017 10:58:25 PM

02-08-2017

Registered User

Having too many connections could affect performance ?

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

Last edited by rbatte1; 02-09-2017 at 05:19 AM.. Reason: Converted textual list to formatted numbered list and corrected spellings

alexcol

View Public Profile for alexcol

Find all posts by alexcol

8 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

changig uid and the affect it will have

Hello, I have 2 sun servers. We are running Oracle apps. We have to apply patches to both servers whenever a patch needs to be applied for Oracle. We use the same username eg. applmgr on both servers. We have a shared patch area which we can run the patch from on both boxes. the uid for...

2. Solaris

making new default gateway take affect

How do you make the changes take affect when you change the subnet masks or default router without rebooting?

3. Shell Programming and Scripting

affect variable

hi , i want to store variable but i get always error when i excute this command ligne : var = awk '{print $1}' file1 echo $var how can i store the var? thanks

4. Solaris

Will Password change affect authorized_keys?

Hello gurus, I have question. I have enabled ssh on the servers. I am planning to change the oracle user's(os user) password. If I change the password will it affect the authorized_keys? Do I need to regenerate it. Thanks,

5. UNIX for Dummies Questions & Answers

.profile - changes don't affect the login

I have modified the .profile in my profile and I don't see any effect. Why the changes don't have effect? I tried both on the account at a server where I have limited permissions as user and to my local pc (as user). Is it the .profile overridden by some other file? It looks weird because I...

6. Solaris

Will creating symbolic links affect users

Hi, I have a quick question with regards to creating symbolic links. Would creating a symbolic link from one directory to a file in another cause any issues for users that are currently logged into the box. I don't believe it will unless they are using the file in question, but I would like...

7. Shell Programming and Scripting

affect a exploded a string into an array

I would like to affect an exploded string into an array. one:two::fourinto an array: a => one a => two a => a => four Quite simple in other languages with functions like explode() or split(). The best I could come up with was this: until do token=${string%%:*} # takes the...

8. Shell Programming and Scripting

Bash script affect load average

Hello I have created next scritpt to do the next: chekp if host is alive. When the host down, launch telnet other equip to do checks. When execute the script the load average of the machines increase. For example: Before launch script top - 11:14:56 up 14 days, 18:06, 3 users, load...

LEARN ABOUT CENTOS

pmdapostgresql

PMDAPOSTGRESQL(1)					       Performance Co-Pilot						 PMDAPOSTGRESQL(1)

NAME

       pmdapostgresql - PostgreSQL database PMDA

DESCRIPTION

       pmdapostgresql is a Performance Co-Pilot PMDA which extracts live performance data from a running PostgreSQL database.

INSTALLATION

       pmdapostgresql uses a configuration file from (in this order):

       o   /etc/pcpdbi.conf

       o   $PCP_PMDAS_DIR/postgresql/postgresql.conf

       This file can contain overridden values (Perl code) for the settings listed at the start of pmdapostgresql.pl, namely:

       o   database name (see DBI(3) for details)

       o   database username

       Once this is setup, you can access the names and values for the postgresql performance metrics by doing the following as root:

	       # cd $PCP_PMDAS_DIR/postgresql
	       # ./Install

       If you want to undo the installation, do the following as root:

	       # cd $PCP_PMDAS_DIR/postgresql
	       # ./Remove

       pmdapostgresql is launched by pmcd(1) and should never be executed directly.  The Install and Remove scripts notify pmcd(1) when the agent
       is installed or removed.

FILES

       /etc/pcpdbi.conf
	   configuration file for all PCP database monitors

       $PCP_PMDAS_DIR/postgresql/postgresql.conf
	   configuration file for pmdapostgresql

       $PCP_PMDAS_DIR/postgresql/Install
	   installation script for the pmdapostgresql agent

       $PCP_PMDAS_DIR/postgresql/Remove
	   undo installation script for the pmdapostgresql agent

       $PCP_LOG_DIR/pmcd/postgresql.log
	   default log file for error messages from pmdapostgresql

SEE ALSO

       pmcd(1), pmdadbping.pl(1) and DBI(3).

3.8.10							       Performance Co-Pilot						 PMDAPOSTGRESQL(1)