Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Which process is taking up so much CPU???

Re: Which process is taking up so much CPU???

From: CP <csp2201_at_netscape.net>
Date: Fri, 28 Mar 2003 05:58:48 -0800
Message-ID: <F001.00575248.20030328055848@fatcity.com>


Alter system set timed_statistics=true;
or/and - init.ora - timed_statistics=true

HTH
CP

fbernaus_at_sammic.com wrote:

> Thank you all for your help.
>
> I wonder where I should set TIMED STATISTICS = TRUE, if any of you has the time to answer I'd be grateful, but I will look for it in the docs.
>
>Fermin.
>
>-----Mensaje original-----
>De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de DENNIS
>WILLIAMS
>Enviado el: jueves, 27 de marzo de 2003 18:49
>Para: Multiple recipients of list ORACLE-L
>Asunto: RE: Which process is taking up so much CPU???
>
>
>Fermin
> The spid column in the v$process column matches the Unix process i.d. You
>may need to track it back through the Oracle shadow process.
>
>Dennis Williams
>DBA, 40%OCP, 100% DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>
>-----Original Message-----
>Sent: Thursday, March 27, 2003 9:14 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
> I usually track our HP-UX 11.0 system with the 'top' command so I
>can notice when the system is under slow performance. If that happens, I use
>Toad to look for any active Oracle SQL query which may be heavy enough for
>degrading the performance.
>
> I think my question is simple, but since I am a newbie on this...
>how can I see who is executing an Oracle SQL that is taking all our CPU
>provided that I only see his PID with the TOP command? I only see the oracle
>process, but I don't know how to get the username and the SQL beside him.
>
> Thank you for your answers!
>
>Fermin.
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: CP
  INET: csp2201_at_netscape.net

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 Fri Mar 28 2003 - 07:58:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US