Re: Track down where SQL is being executed from

On Jul 9, 11:51 am, Jeremy Smith <godto..._at_hotmail.com> wrote:
> In 10g Enterprise manager, I have SQL that is being executed from a
> machine that I need to locate. I've checked all of our Dev, test and
> Prod DB servers with SQL on it. Need to make sure that one of the
> developers does have some SQL running on a rogue MS SQL server that I
> don't know about. In Enterprise manager it only tells me the below in
> SQL Details.
>
> General
> Module sqlservr.exe
> Action
> Parsing Schema MAINDB .
>
> How can I track down from what host this sql is being executed from?
>
> Thanks

I presume you have the SID and SERIAL# of the 'offending' session:

select machine
from v$session
where sid = <sid of session>
and serial# = <serial# of session>;

David Fitzjarrell Received on Mon Jul 09 2007 - 11:59:30 CDT