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

recipients of list ORACLE-L Asunto: RE: Which process is taking up so much CPU??? On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote: Fermin Add this line to your init.ora file. timed_statistics = true Then shutdown, startup your Oracle instance. I would hasten to point out that this parameter can

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

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. [EMAIL PROTECTED

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

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. [EMAIL PROTECTED

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

: 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. [EMAIL PROTECTED] -Original Message- Sent

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

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. [EMAIL PROTECTED] -Original Message- Sent: Thursday

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

Tim, I think you may be right actually! :) I have a sub directory that contains the scripts that you zipped up on your site, this script seemed to have found it's way in to my main SQL directory, and as it didn't have any notes on author I plain forgot. It was indeed called SessionTopCPU.sql. All

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

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

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

. Fermin. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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

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

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

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

On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote: Fermin Add this line to your init.ora file. timed_statistics = true Then shutdown, startup your Oracle instance. I would hasten to point out that this parameter can be set dynamically using alter system from at least 8.1.x forward. Thus,

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

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. [EMAIL PROTECTED

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

Thanks Jeremiah. My bad. T early on Friday. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 28, 2003 9:19 AM To: Multiple recipients of list ORACLE-L On Fri, 28 Mar 2003, DENNIS WILLIAMS wrote: Fermin Add this

Which process is taking up so much CPU???

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,

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

Prompt Prompt Show total CPU and statement CPU for current session (requires TIMED STATISTICS = TRUE) Prompt set verify off col UNAM format a20 word heading 'User' col STMT format a56 word heading 'Statement' col RUNT format a08 word heading 'CPU Time' col ltim format a20 word heading

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

Hey, it could well be one of mine (or something derived from the same source as I started with) - got all the same words, syntax and style as something I call SessionTopCPU and use to be available off my web site. I think the original inspiration was from Dave Ensor, but I no longer use the report

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. [EMAIL PROTECTED] -Original Message- Sent: Thursday, March 27, 2003 9:14 AM To:

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

Mark et. al, Just a caveat based on a personal observation. For pre-9i databases on some OS platforms(sorry it has been a while so I can't remember the exact details), the CPU used by this session metric had some accounting issues and hence reflected much higher values (by orders of magnitude)