Re: Polling SQL Queries

Hi KJD

Something like this might help:

select  s.username,
        p.username os_user, 
        p.spid process,
        s.program, 
        q.sql_text sql
from    v$process p, 
        v$session s, 
        v$sql q
where   p.addr=s.paddr
and     s.sql_address=q.address
and     s.status='ACTIVE';

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.