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

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

How to determine what session is using lot of Oracle resources

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Mon, 11 Dec 2000 10:37:32 -0800
Message-Id: <10707.124219@fatcity.com>


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 Received on Mon Dec 11 2000 - 12:37:32 CST

Original text of this message

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