View user sessions details


select sesion.sid,
sesion.username,
optimizer_mode,
hash_value,
address,    
cpu_time/1000000 as cpu_time_in_sec,
elapsed_time/1000000 as elapsed_time_in_sec,
sqlarea.sql_id,
sql_text
from v$sqlarea sqlarea, v$session sesion
where sesion.sql_hash_value = sqlarea.hash_value
and sesion.sql_address    = sqlarea.address
and sesion.username ='&user_name';

Comments: Leave Comment

* The email will not be published on the website.