|
-
It should work.
Enable trace and execute this query.
select a.sid,a.serial#,a.osuser,a.machine,a.program,b.sql_text
from v$session a,v$sqlarea b,v$process c
where a.sql_hash_value=b.hash_value
and a.serial# !=1
and a.status='ACTIVE'
and b.users_executing=1
and a.paddr=c.addr
AND A.SID NOT IN (select sid
from v$session
where audsid = userenv('sessionid'))
and c.spid=&spid
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|