02-08-2017
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
8 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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 Replies)
Discussion started by: d__browne
2 Replies
2. Solaris
How do you make the changes take affect when you change the subnet masks or default router without rebooting? (1 Reply)
Discussion started by: BG_JrAdmin
1 Replies
3. Shell Programming and Scripting
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 (7 Replies)
Discussion started by: kamel.seg
7 Replies
4. Solaris
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, (2 Replies)
Discussion started by: oracleuser
2 Replies
5. UNIX for Dummies Questions & Answers
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... (8 Replies)
Discussion started by: myle
8 Replies
6. Solaris
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... (2 Replies)
Discussion started by: Chains
2 Replies
7. Shell Programming and Scripting
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 Replies)
Discussion started by: ripat
8 Replies
8. Shell Programming and Scripting
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... (3 Replies)
Discussion started by: capilla
3 Replies
LEARN ABOUT CENTOS
chkhelp
CHKHELP(1) General Commands Manual CHKHELP(1)
NAME
chkhelp - check performance metrics help text files
SYNOPSIS
$PCP_BINADM_DIR/chkhelp [-eHiOp] [-n pmnsfile] [-v version] helpfile [metricname ...]
DESCRIPTION
chkhelp checks the consistency of Performance Co-Pilot help text files generated by newhelp(1) and used by Performance Metric Domain Agents
(PMDAs). The checking involves scanning the files, and optionally displaying selected entries.
The files helpfile.dir and helpfile.pag are created by newhelp(1), and are assumed to already exist.
Without any options or metricname arguments, chkhelp silently verifies the structural integrity of the help files.
If any metricname arguments are specified, then the help entries for only the corresponding metrics will be processed.
If no metricname arguments are specified, then at least one of the options -i or -p must be given. The -i option causes entries for all
instance domains to be processed (ignoring entries for performance metrics). The -p option causes entries for all metrics to be displayed
(ignoring entries for instance domains).
When metric entries are to be processed (via either the metricname arguments or the -p option or the -i option), the -O and -H options
request the display of the one-line and verbose help text respectively. The default is -O.
Although historically there have been multiple help text file formats, the only format currently supported using the -v option is version
2, and this is the default if no -v flag is provided.
Normally chkhelp operates on the default Performance Metrics Namespace (PMNS), however if the -n option is specified an alternative names-
pace is loaded from the file pmnsfile.
The -e option provides an existence check where all of the specified metrics from the PMNS (note, not from helpfile) are scanned, and only
the names of the metrics for which no help text exists are reported. The -e option is mutually exclusive with the -i and/or -p options.
PCP ENVIRONMENT
Environment variables with the prefix PCP_ are used to parameterize the file and directory names used by PCP. On each installation, the
file /etc/pcp.conf contains the local values for these variables. The $PCP_CONF variable may be used to specify an alternative configura-
tion file, as described in pcp.conf(5).
SEE ALSO
newhelp(1), PMAPI(3), pmLookupInDomText(3), pmLookupText(3), pcp.conf(5) and pcp.env(5).
DIAGNOSTICS
There are all sorts of reasons a help database may be inconsistent, the most likely is that a performance metric in the database is not
defined in the loaded PMNS.
Performance Co-Pilot PCP CHKHELP(1)