[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次.
--//看到这样的项目真心无语,建议开发好好学习然后在开发吧,不然简直是坑害用户...

--//贴一个图,不然别人又在说我乱讲.