| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 comments/praises to Tim! ;)
Welcome back to the list by the way! :)
Cheers
Mark
-----Original Message-----
Sent: 27 March 2003 17:14
To: Multiple recipients of list ORACLE-L
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 and have long since forgotten almost everything about it (ie I won't be of much help in answering questions).
-----Original Message-----
Sent: 27 March 2003 15:59
To: Multiple recipients of list ORACLE-L
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 'Logon Time' col etim format a20 word heading 'Connect Time'col PROG format a30 word heading 'Program|Client Terminal Details' col SID format a10 word heading 'SID/|Serial#'
col DR format 999999999 heading 'Disk Reads' col BG format 999999999 heading 'Buffer Gets' col EX format 999999999 heading 'Executions'col rsecs format 999,999,999.00 heading "CPU time|(seconds)" ...
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions INET: tim.onions_at_speechmachines.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-LReceived on Fri Mar 28 2003 - 03:23:59 CST
(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.net -- Author: Mark Leith INET: mark_at_cool-tools.co.uk 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).
 |
 |