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

Please elaborate...what about profiles?

Rick

> -----Original Message-----
> From: Oliver Artelt [SMTP:oli_at_md.transnet.de]
> Sent: Monday, December 11, 2000 3:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: How to determine what session is using lot of Oracle
>
>
> How about profiles?
>
> oli
>
> On Monday 11 December 2000 20:52, maa25681_at_GlaxoWellcome.com wrote:
> > We have the same problem in our Solaris and HP-UX environments. Here are
> a
> > couple of simple tricks I use:
> >
> > * When I have a runaway process that has a lot of UNIX execution time
> > (ps -ef), I check the start time of the UNIX process and the LOGON_TIME
> > column of V$SESSION. The 2 times usually match.
> > * Not knowing who the culprit usually disturbs me. Sometimes I can
> > Select the OSUSER column from V$SESSION to find out which person has
> which
> > login session.
> >
> > I hope this helps.
> >
> > Michael Armstead
> > Database Administrator, OCP-Certified
> > Corporate & Finance Information Systems
> > Glaxo Wellcome
> >
> > > -----Original Message-----
> > > From: Cale, Rick T (Richard) [SMTP:RICHARD.T.CALE_at_saic.com]
> > > Sent: Monday, December 11, 2000 1:46 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: How to determine what session is using lot of Oracle
> > > resources
> > >
> > > 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
> > >
> > > --
> > > 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
> > > also send the HELP command for other information (like subscribing).
>
> --
> ---
>
> Oliver Artelt, System- und Datenbankadministration
> ---------------------------------------------------------------
> cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
> telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
> email: oli@cubeoffice.de # web: http://www.cubeoffice.de
> ---------------------------------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Oliver Artelt
> INET: oli_at_md.transnet.de
>
> 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
Received on Mon Dec 11 2000 - 15:38:54 CST