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
---------------------------------------------------------------