SQL脚本监控与分析：优化查询与DML操作

@Jason 个人写的关于sql读写等角度，不懂对不对
/*---------------各个维度查看共享池中的sql-----------------*/
---查看执行次数，看出软硬解析对比整体情况
SELECT SUM(CASE WHEN a.EXECUTIONS>=20 THEN 1 ELSE 0 END) bigExe ,
        SUM(CASE WHEN a.EXECUTIONS <20 THEN 1 ELSE 0 END) SExe2,
        SUM(CASE WHEN a.EXECUTIONS IN(0,1) THEN 1 ELSE 0 END) SmaExe,
       SUM(1) 总数
  FROM v$sqlarea a
/* WHERE  a.module NOT IN
        ('DBMS_SCHEDULER',
         'PL/SQL Developer',
         'ORACLE.EXE',
         'SQL*Plus',
         'Streams',
         'plsqldev.exe',
         'emagent_SQL_oracle_database',
         'Oracle Enterprise Manager.current metric purge')*/
         ;
         
--查看select、DML操作比例       
SELECT    ROUND(allNUM/10000000)||'千万' allnum,
          ROUND((b.allNUM-insertNUM-updateNUM-deleteNUM)/10000000)||'千万' AS sNUM,
          ROUND(insertNUM/10000000)||'千万' inum,
          ROUND(updateNUM/10000000)||'千万' unum,
          ROUND(deleteNUM/10000000)||'千万' dnum,
          ROUND((b.allNUM-insertNUM-updateNUM-deleteNUM)*100/allNUM)||'%' "SE%",
          ROUND(b.insertNUM*100/allNUM)||'%' "IN%",
          ROUND(b.updateNUM*100/allNUM)||'%' "UP%",
          ROUND(b.deleteNUM*100/allNUM)||'%' "DE%"  
    FROM