RE: [Webct-admin] ping vista_people
Status: Beta
Brought to you by:
jlongland
|
From: Aggarwal, S. <sag...@Ce...> - 2003-11-14 19:02:53
|
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 |