| 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: Who is running a long-run job....
This is the query from one of the IOUG-A Live 2000 sessions:
select substr(sn.name,1,30) parameter,
ss.username ||')' || se.sid ||') ' user_process,
se.value
and sn.name LIKE '%CPU used by this session%'
and se.sid = ss.sid
order by sn.name, se.value DESC;
Hope it helps.
H Nguyen
>From: "Aldi Barco" <ipal_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Who is running a long-run job....
>Date: Mon, 22 May 2000 09:26:20 -0800
>
>Hi list..
>
>Users have just complained about dropped performance, more than 10 times
>slower. This was due to one user was running a long-run job i.e importing a
>big table.
>
>Is there a way to know who is currently running a long-run job ?
>Can we know how much resource (percentage of cpu, mem, etc) is being
>allocated for each user ?
>
>Tia for any clue.
>
>Aldi
>Oracle DBA
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Aldi Barco
> INET: ipal_at_hotmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
 |
 |