Re: [Webct-admin] ping vista_people

[robert m. <rob...@le...>]

Hi All,

Aggarwal, Seema wrote:

>Hello All,
>
>To monitor performance, I would check CPU uses first on the server to see
>which top 10 processes are using the most CPU using this command $
>/usr/ucb/ps -aux | head -10 . 
>
thx we are also using vmstat, sar, iostat, mpstat, netstat -k etc the 
problem is that these commands on the whole tell me very little about 
what's going on in the JVM. We are having sporadic short lived (I am 
being optimistic - up to one hour) performance drops and the only thing 
showing on the server is a slightly higher load (run queue length - 
prstat) on the application server.

By the way I usally use 'prstat -s cpu' if I want to sort on cpu usage
ps and prstat are the same binary on solaris ;-)
bash-2.03$ ls -l /usr/bin/prstat
-r-xr-xr-x  37 root     bin         5256 Jan  6  2000 /usr/bin/prstat
bash-2.03$ ls -l /usr/ucb/ps
-r-xr-xr-x  37 root     bin         5256 Jan  6  2000 /usr/ucb/ps
also who, w etc cool huh

>
>Then you can save codes as a script and run it to check the active users of
>oracle database. You will need to set the ORACLE_SID= dbname you want to
>check. 
>
>
>echo "
>prompt
>prompt LIST OF USERS IN $ORACLE_SID
>col spid format 999999 heading 'UNIX|ID' just center
>col osuser heading 'NETWORK|USER ID' just center
>col username heading 'ORACLE|USER ID' just center
>col sid  format 9999
>col serial#  format 99999
>select to_number(p.spid) spid,
>   s.osuser,
>   substr(s.username,1,8) username,
>   substr(s.program,1,20) program,
>   s.sid,
>   s.serial#,
>   s.status
>from v\$session s, v\$process p
>where s.paddr = p.addr
>and   s.type != 'BACKGROUND'
>order by s.osuser, spid;
>prompt TO KILL A SESSION USE SID AND SERIAL#
>prompt" |
>sqlplus -s /
>
>There are also lots of tools available to check oracle database performance
>
We have installed the stats package from oracle. I haven't run this 
query but it looks like it gives the number and type of connections to 
the database. Correct me if I am wrong but application servers usally 
only make a few connections to a database so its not the number but what 
they are doing thats important. I am more interested in how many users 
are using webct and what are they doing.

I had in mind building some tools that allow us to see what vista is 
doing rather than what the OS or Oracle are doing, as Seema points out 
this is more or less standard stuff.

Might be useful to put a wish list together. So me first

I would love to know what all the java threads are up to :-)

Rob

-- 
Dr Robert D. McDonnell
UNIX Specialist CIM Utrecht University
rob...@le... 
Tel:++31 (0)30 2536010 (06 24271732)