RE: How to determine what session is using lot of Oracle resources

Don't know if this is going to help, but an example query to show you who is rockin and rolling on your hard drives would be.

SELECT A.OSUSER, A.MACHINE, A.USERNAME, B.PHYSICAL_READS, B.BLOCK_GETS FROM V$SESSION A, V$SESS_IO B
WHERE A.SID = B.SID
ORDER BY B.PHYSICAL_READS However, I have a feeling that yours is more sga and main memory problems. Am I even close on this one?
Kev
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Cale, Rick T (Richard)
Sent: Tuesday, December 12, 2000 9:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to determine what session is using lot of Oracle resources

I have gotten suggestions to look at v$session,v$sess_io and v$sesstat. I have looked at these pretty
thouroughly and need some help in interpreting columns needed to answer original question.
Any help is appreciated.

Thanks,
Rick

> -----Original Message-----
> From: Connor McDonald [SMTP:hamcdc_at_yahoo.co.uk]
> Sent: Tuesday, December 12, 2000 3:53 AM
> To: Cale, Rick T (Richard); oracledba_at_quickdoc.co.uk;
> ORACLE-L_at_fatcity.com
> Subject: Re: How to determine what session is using lot of Oracle
> resources
>
>
> Take a look at v$sesstat and possibly the osuser
> column in v$session
>
> HTH
>
> --- "Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com>
> wrote: > Hi all,
> >
> > There is an application where everyone uses the same
> > login. One of the
> > processes is using a lot
> > of resources. How can I determine what session it
> > is so I can use alter
> > system kill session.
> > NT 4 Oracle 8.0.5
> >
> > Thanks
> > Rick Cale, Science Applications International Corp.
> > Phone:865-481-2198, fax:865-481-8555
> > e-mail: caler_at_saic.com
> >
> >
> > --------
> > Think you know someone who can answer the above
> > question? Forward it to them!
> > to unsubscribe, send a blank email to
> > oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to
> > oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive:
> > http://www.LAZYDBA.com/odbareadmail.pl
> >
>
>
> =====
> Connor McDonald
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue"
>
> ____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> or your free @yahoo.ie address at http://mail.yahoo.ie

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.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