select count(1) num_sql
     , sum(decode(executions,1,1,0)) num_1_use_sql
     , sum(sharable_mem)/1024/1024 mb_sql_mem
     , sum(decode(executions, 1,sharable_mem, 0))/1024/1024 mb_1_use_sql_mem
  from v$sql
 where sharable_mem > 0;