If you have Oracle Enterprise Manager with the
Diagnostic Pack, you could use TopSessions to list
sessions based upon different options such as CPU
usage, connect time etc.
- Deepak Sharma
- Hi Nguyen <h3anguyen_at_hotmail.com> wrote:
> 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
> from v$session ss, v$sesstat se, v$statname sn
> where se.statistic# = sn.statistic#
> 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).
>
>
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
>
> --
> Author: Hi Nguyen
> INET: h3anguyen_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).
Received on Tue May 23 2000 - 10:50:52 CDT