Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to determine what session is using lot of Oracle
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.deReceived on Mon Dec 11 2000 - 18:09:43 CST