Wednesday, February 1, 2017

Oracle Currently Running SQLs

select sesion.sid,
       sesion.username,
       optimizer_mode,
       hash_value,
       address,
       cpu_time,
       elapsed_time,
       sql_text
   
  from gv$sqlarea sqlarea, gv$session sesion
 where sesion.sql_hash_value = sqlarea.hash_value
   and sesion.sql_address    = sqlarea.address
   and sesion.username is not null
   and sesion.inst_id=1

No comments:

Post a Comment