RE: Monitoring Unix Question

From: Stephen Lee <slee_at_dollar.com>
Date: Thu, 14 Nov 2002 14:09:08 -0800
Message-ID: <F001.00503D0D.20021114140908@fatcity.com>

If you have the "top" utility installed on the Unix box, this makes an easy to use interface to identify CPU hogs. For non-root users to run it, your sys admin might have to change default permissions on certain "files" such as /dev/kmem; or possibly make top SUID root.

If you don't have top, or you can't run it as non-root, you can try using the following ps command to sort things by %CPU, but I think there might be differences among OS's on some of the more exotic ps and sort options:

ps -eo pid -o %cpu | sort -rk2 | head -20

After you have identified which PID is the hog, and can see that it is a dedicated server process, you can run something like the following to match SID & SERIAL# to the correct OS process ID. If you must brutally kill the process, kill the session in the database, then kill the pid in the OS.

set linesize whatever_you_like
set pagesize whatever_you_like

col username format a15
col osuser format a15

select s.username,
       s.osuser,
       s.sid,
       s.serial#,
       s.process "USER PRCS",
       p.spid "SVR PRCS"

  from v$process p,v$session s
  where p.addr = s.paddr
  and s.username <> ' '
/

> -----Original Message-----
> From: ecandrietta [mailto:ecandrietta_at_uol.com.br]
> Sent: Thursday, November 14, 2002 1:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Monitoring Unix Question
>
>
>
> Friends :
>
> How can i do for get what is running inside a PID that is
> using a lot of CPU ?
>
> How can I get the query that is running inside the database
> according PID of unix ?
>
> I would like to know commands of the unix and the query that
> i need to run in the database for find out the problem.
>
> Regards
>
> Eriovaldo
>
>
>
> ---
> UOL, o melhor da Internet
> http://www.uol.com.br/
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: ecandrietta
> INET: ecandrietta_at_uol.com.br
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: slee_at_dollar.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Nov 14 2002 - 16:09:08 CST