09-15-2003
Hi Khalid,
Nope. I think (from what I have seen), that there is an SQL-statement runing on a table which has not been indexed and might therefor be eating more cpu-time. Looking at some scripts that just perform the same action over a thousand times in a script might be the cause of your problem now.
Our DBA and I have often seen users run awfull SQL statements which cause this problem.
It might be nice for you to find out the real bottleneck in her performing : sar 2 20 . You can now see if it's WIO/ USR or SYS. Most off all it will also be WIO. Still upgrading memory should not matter.
Aargh, will deep into it a bit more. Please perform a
"swapinfo -at"
and paste the output here. Also the output of "sar 5 20" would be nice. Please let me know the total amount of physical memory and created swap. Also let me know on what disk you configured swap. please give me a "sar -d 5 20" output of this disk.
Will continue tomorow.
Regs David
9 More Discussions You Might Find Interesting
1. Cybersecurity
Hi all
what are the ways by which we can know and generate a report of the space remaining, memory(ram) used and the load on the server over a period of time. (1 Reply)
Discussion started by: arlan
1 Replies
2. Linux
I need to download a script from Unix box to my PC. I don't have FTP installed on that machine and I am not able to connect to the server using ftp <Server Name>.
I am not supposed to install any software on the server but still need to download the file. Heard that we have a secured ftp option... (3 Replies)
Discussion started by: chandu_kalari
3 Replies
3. Linux
Hi
anyone know how to setup a setup a virtual IP to control 2 server load for linux? i only have 2 server, i don want to buy another just for the load balance... is there a way to do it?
Sumemr (0 Replies)
Discussion started by: summerpeh
0 Replies
4. Red Hat
we are using redhat linux,configured the postfix as mail server and outlook is used as mail client.whenever the user opens outlook it is start downloading all the mails from the server.
Example : If a user has 50 mails in the server,whenever he opens the outlook the outlook will start... (0 Replies)
Discussion started by: ramjimh2k3
0 Replies
5. Shell Programming and Scripting
Hi Folks,
I want to see the proper status of a low performance server. I tried using top command but it doesn't give all the details.
Any help in this regard would be appreciated.
Regards,
Sagar (1 Reply)
Discussion started by: sagarjani
1 Replies
6. UNIX for Advanced & Expert Users
how to enable cygwin in linux server (redHat).....
any idea? (1 Reply)
Discussion started by: crackthehit007
1 Replies
7. Shell Programming and Scripting
Hello,
I could use a little help with the command line part of this. I've got it to sorta work if I use this `gawk -F"/"'{ print $3 }'`
I've also tried `pwd|cut -d/ -f3` with no luck. Is this possible to do? I'm basically doing this to copy the users domain, then paste that into the... (5 Replies)
Discussion started by: biopulse
5 Replies
8. IP Networking
Can someone help with a detail step-by-step oh how to configure DNS server on Linux Server.
-
I need to have 3 IP addresses map to a single hostname.
for clients
I'm a Linux rookie.
Thanks
Oscar (1 Reply)
Discussion started by: FrankOscar
1 Replies
9. Programming
Here is a useful SSL (HTTPS) application for anyone with a remote Linux server they want to keep an eye on using Blynk and the NodeMCU ESP8266. This little app also works (have tested as well) on the WeMos D1 ESP8266 Arduino board.
The NodeMCU setup could not be easier, just find a... (8 Replies)
Discussion started by: Neo
8 Replies
sag(1) User Commands sag(1)
NAME
sag - system activity graph
SYNOPSIS
sag [-e time] [-f file] [-i sec] [-s time] [-T term] [-x spec] [-y spec]
DESCRIPTION
The sag utility graphically displays the system activity data stored in a binary data file by a previous sar(1) run. Any of the sar data
items may be plotted singly or in combination, as cross plots or versus time. Simple arithmetic combinations of data may be specified. sag
invokes sar and finds the desired data by string-matching the data column header (run sar to see what is available). The sag utility
requires a graphic terminal to draw the graph, and uses tplot(1) to produce its output. When running Solaris 2.x and OpenWindows, perform
the following steps:
1. Run an "xterm" as a Tektronics terminal: prompt# xterm -t
2. In the "xterm" window, run sag specifying a tek terminal: prompt# sag -T tek options
OPTIONS
The following options are supported and passed through to sar (see sar(1)):
-e time Select data up to time. Default is 18:00.
-f file Use file as the data source for sar. Default is the current daily data file /usr/adm/sa/sadd.
-i sec Select data at intervals as close as possible to sec seconds.
-s time Select data later than time in the form hh[:mm]. Default is 08:00.
-T term Produce output suitable for terminal term. See tplot(1) for known terminals. Default for term is $TERM.
-x spec x axis specification with spec in the form:
name[op name]...[lo hi]
name is either a string that will match a column header in the sar report, with an optional device name in square brackets, for
example, r+w/s[dsk-1], or an integer value. op is + - * or / surrounded by blank spaces. Up to five names may be specified.
Parentheses are not recognized. Contrary to custom, + and - have precedence over * and /. Evaluation is left to right. Thus,
A/A+B*100 is evaluated as (A/(A+B))*100, and A+B/C+D is (A+B)/(C+D). lo and hi are optional numeric scale limits. If unspecified,
they are deduced from the data.
Enclose spec in double-quotes ("") if it includes white space.
A single spec is permitted for the x axis. If unspecified, time is used.
-y spec y axis specification with spec in the same form as for -x. Up to 5 spec arguments separated by a semi-colon (;) may be given for
-y. The -y default is:
-y"%usr0100;%usr+%sys0100;%usr+%sys+%wio0100"
EXAMPLES
Example 1: Examples of the sag command.
To see today's CPU utilization:
example$ sag
To see activity over 15 minutes of all disk drives:
example$ TS=`date +%H:%M`
example$ sar -o /tmp/tempfile 60 15
example$ TE=`date +%H:%M`
example$ sag -f /tmp/tempfile -s $TS -e $TE -y "r+w/s[dsk]"
FILES
/usr/adm/sa/sadd daily data file for day dd
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWaccu |
+-----------------------------+-----------------------------+
SEE ALSO
sar(1), tplot(1), attributes(5)
SunOS 5.10 4 Mar 1998 sag(1)