Top 20 SQLs


SELECT 
 module,  Sql_id,Child_number, sql_text,  username,  disk_reads_per_exec,  buffer_gets,  disk_reads,  parse_calls,  sorts,  executions,  rows_processed, 
 hit_ratio,  first_load_time,  sharable_mem,  persistent_mem,  runtime_mem, 
 cpu_time,  elapsed_time,  address,  hash_value 
FROM 
  (SELECT   module,   Sql_id,   Child_number,    sql_text ,    u.username , 
   round((s.disk_reads/decode(s.executions,0,1, s.executions)),2)  disk_reads_per_exec,    s.disk_reads ,    s.buffer_gets ,    s.parse_calls , 
   s.sorts ,    s.executions ,    s.rows_processed ,    100 - round(100 *  s.disk_reads/greatest(s.buffer_gets,1),2) hit_ratio, 
   s.first_load_time ,    sharable_mem ,    persistent_mem ,    runtime_mem, 
   cpu_time,    elapsed_time,    address,    hash_value 
  FROM
   sys.v_$sql s, 
   sys.all_users u 
  WHERE
   s.parsing_user_id=u.user_id 
   and UPPER(u.username) in ('OVP2')
   ORDER BY
   6 desc) 
WHERE
 rownum <= 20;

Comments: Leave Comment

* The email will not be published on the website.