Tuesday, April 10, 2007

currently executing sqls for the users

Following gives the active SQL all current users are executing

select v.sid,
v.username,
optimizer_mode,
hash_value,
address,
cpu_time,
elapsed_time,
sql_text
from v$s s, v$session v
where v.sql_hash_value = s.hash_value
and v.sql_address = s.address
and v.username is not null

No comments: