RE: Query

From: <dieter.oberkofler_at_chello.at>
Date: Sat, 13 Jan 2001 17:16:37 +0100
Message-Id: <10740.126621@fatcity.com>

Hi Kevin!

Download my shareware tool Top100 from my web page at http://www.materialdreams.com/products.html and have a look at your sql area. The tool is very easy to use and should help you to find the sql statements that cause the heavy load.

Regards

email: info_at_materialdreams.com
web: www.materialdreams.com

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Kevin Kostyszyn
Sent: Friday, January 12, 2001 6:01 PM
To: Multiple recipients of list ORACLE-L Subject: Query

Hi all,

Here's a question. Say I notice some heavy work going on on my server. Now say I look at the SGA and it is growing, so I know someone is handing out a beat down to the server. I have been trying to come up with a query that would show me the user that is doing this, even perhaps what it is they are doing that is causing all the work. I have been trying to find a way to join v$sqlarea and v$session, but can't seem to find a solution. I am sure that there is already a query or script out there that everyone knows of execpt me that takes care of this.

Any ideas and answers are much appreciated.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
kevin_at_dulcian.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Kostyszyn
INET: kevin_at_dulcian.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). Received on Sat Jan 13 2001 - 10:16:37 CST