Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to determine what session is using lot of Oracle

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

From: Oliver Artelt <oli_at_md.transnet.de>
Date: Tue, 12 Dec 2000 01:09:43 +0100
Message-Id: <10707.124261@fatcity.com>


You want to kill sessions that are consuming too much resources. Exactly for this purpose profiles exist. They do that for you automatically.

oli

On Monday 11 December 2000 23:12, RICHARD.T.CALE_at_saic.com wrote:
> 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
> > 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
Received on Mon Dec 11 2000 - 18:09:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US