[20191227]别把数据库当作垃圾场.txt

[20191227]别把数据库当作垃圾场.txt --//最近一直在我一个项目的优化工作,看到开发写的模式有时候真心无语!! xxxxx> select count(*) from BBB_QQQQ_FFFFF_TTTTTT;   COUNT(*) ----------          1 xxxxx> select count(*) from BBB_QQQQ_FFFFF_TTTTTT;   COUNT(*) ----------          0 --//可以发现插入后马上删除,查询消失,好不容易抓到1次. select sql_id,sql_text,executions,ROWS_PROCESSED from v$sqlarea where upper(sql_text) like '%BBB_QQQQ_FFFFF_TTTTTT%' and module='JDBC Thin Client' order by executions desc; SQL_ID        SQL_TEXT        EXECUTIONS ROWS_PROCESSED ------------- --------------- ---------- -------------- 5naavb5pbarvv INSERT INTO BOS     145536         145536               RIGGER_NAME, TR               _TIME, STATE, J               S_RECOVERY, PRI                , :4 , :5 , :6 8qzr3jdpv8qny UPDATE BOS_QRTZ     145536         145536               D_TIME = :2 , S                JOB_GROUP = :6               = :8  WHERE SCH cknfn1yap02pt DELETE FROM BOS     145536         145536               tzScheduler' AN ... 6 rows selected. --//插入修改删除的执行次数完全一样.一个使用临时表的经典例子. --//中间休息60秒.再次查询.看到的执行次数的变化: --//145554->145563 --//145563-145554 = 9,1分钟执行9次. xxxxx> select count(*) from UUU_SSSSS_PPPP;   COUNT(*) ----------          0 select sql_id,sql_text,executions,ROWS_PROCESSED from v$sqlarea where upper(sql_text) like '%UUU_SSSSS_PPPP%' and module='JDBC Thin Client' order by executions desc; SQL_ID        SQL_TEXT          EXECUTIONS ROWS_PROCESSED ------------- ----------------- ---------- -------------- .... fakvs4mf7kbt1 INSERT INTO   UUU      47882          47882               ACEID, FBILLID,                 CKEDTIME,FVERSION               TETIME,FBUSTYPE,F               :4 ,   :5 ,   :6               2 ,   :13 ,   :14 5shxwhma80zhk SELECT * FROM UUU      47882          47882               lBatchCode=:2  an 2rhu90tv83675 delete from UUU_S      47882          47882 ... 7 rows selected. --//中间休息60秒.再次查询.看到的执行次数的变化: --//47901->47911 --//47911-47901 = 10,1分钟执行10次. --//看到这样的项目真心无语,建议开发好好学习然后在开发吧,不然简直是坑害用户... --//贴一个图,不然别人又在说我乱讲.