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 Received on Fri Jan 12 2001 - 10:42:22 CST