RE: [Webct-admin] ping vista_people

[Aggarwal, S. <sag...@Ce...>]

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 . 

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.


I hope this helps.

Thanks, 

Seema 

-----Original Message-----
From: Austin Laird [mailto:au...@un...] 
Sent: Friday, November 14, 2003 11:25 AM
To: Leigh Hausman
Cc: Rob McDonnell; web...@li...
Subject: Re: [Webct-admin] ping vista_people

I second that!
We're in the same boat right now.. we have nothing that I'd say is even 
worth posting.. but we're very interested in developing that.
-austin

Leigh Hausman wrote:

> I think you're asking in the right place.
>
> We've been working on monitoring, but so far it's mostly been 
> reactive-- something breaks, so we write a monitoring utility to warn 
> us before it happens again. I haven't been able to spend as much time 
> as I'd like on it.
>
> I'd like to encourage anyone with monitoring checks (for any system) 
> to post them here so that we don't have to reinvent the wheel.
>
> Leigh
>
> On Friday, November 14, 2003, at 03:58  AM, Rob McDonnell wrote:
>
>> Hi All,
>>
>> This is just a quick poll.How many of you out there are interested in 
>> building some tools to say monitor Vista performance? Parse weblogic 
>> log file etc. Do we have a critical mass? I don't see many vista 
>> related projects active.
>>
>> Has anyone got code we can build on? I have been asking webct for sql 
>> queries to extract stuff like number of active users but I am not 
>> getting information fast enough.
>>
>> Has anyone got the internals of the database worked out? We have to 
>> spend a lot of time trying to work out where stuff is if we want to 
>> run script based tools rather than the admin browser. I asked webct 
>> if there were any "internal" docs just got silience.
>>
>> What I am looking for is a forum for vista server admins i.e. people 
>> looking at the app from the OS (unix, linux).
>>
>> Kind Rgds,
>> Rob
>>
>> -- 
>> Dr Robert D. McDonnell
>> UNIX Specialist CIM Utrecht University
>> rob...@le...
>> Tel:++31 (0)30 2536010 (06 24271732)
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email sponsored by: ApacheCon 2003,
>> 16-19 November in Las Vegas. Learn firsthand the latest
>> developments in Apache, PHP, Perl, XML, Java, MySQL,
>> WebDAV, and more! http://www.apachecon.com/
>> _______________________________________________
>> Webct-admin mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/webct-admin
>
>
>
>
> -------------------------------------------------------
> This SF. Net email is sponsored by: GoToMyPC
> GoToMyPC is the fast, easy and secure way to access your computer from
> any Web browser or wireless device. Click here to Try it Free!
> https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl
> _______________________________________________
> Webct-admin mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/webct-admin


-- 
zzzBzzz
Austin Laird
Distributed Learning Administrator
University of North Texas
au...@un...





-------------------------------------------------------
This SF. Net email is sponsored by: GoToMyPC
GoToMyPC is the fast, easy and secure way to access your computer from
any Web browser or wireless device. Click here to Try it Free!
https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl
_______________________________________________
Webct-admin mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/webct-admin