awrsqrpt.sql 在oracle 版本10.2.0.4(for windows)的bug

dbhelper發表於2014-12-23
原文網址 : http://blog.itpub.net/8494287/viewspace-1377152/
SQLOracleWindows
awrsqrpt.sql 在oracle 版本10.2.0.4(for windows)的bug

和開發人員理論了半天，發現抓出的SQL值前後不一致,原來是SQL文字內容出現換行時的內容重複bug。
太低階的BUG了。

@?/rdbms/admin/awrsqrpt.sql

應該是：
select * from MEDREC.HT_MEDICAL_ORDER where INSERTFLAG in('1','2') and ROWNUM<=
1000 order by FLOWID

結果:
  換行時內容重複了； 該是 INSERTFLAG in('1','2') ，變成了INSERTFLAG in('1','22') .
  
awrsqrpt.sql末尾
Full SQL Text
SQL ID       SQL Text
------------ -----------------------------------------------------------------
6v84tf3dmx5r select * from MEDREC.HT_MEDICAL_ORDER where INSERTFLAG in('1', '2
             2') and ROWNUM<=1000 order by FLOWID





WORKLOAD REPOSITORY SQL Report


Snapshot Period Summary


DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
ORACLE10      2512774806 oracle10            1 10.2.0.4.0  NO xxxx


              Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:     23362 19-Dec-14 10:00:12       584       1.2
  End Snap:     23363 19-Dec-14 11:00:27       555       1.2
   Elapsed:               60.25 (mins)
   DB Time:              421.86 (mins)


SQL Summary                     DB/Inst: ORACLE10/oracle10  Snaps: 23362-23363


                Elapsed
   SQL Id      Time (ms)
------------- ----------
5qfzbpj75amdu  3,521,856
Module: JDBC Thin Client
select * from inpatientinfo where impflag='0' order by recordflow
....






Full SQL Text


SQL ID       SQL Text
------------ -----------------------------------------------------------------
5qfzbpj75amd select * from inpatientinfo where impflag='0' order by recordflow
             w








ORKLOAD REPOSITORY SQL Report


Snapshot Period Summary


DB Name         DB Id    Instance     Inst Num Release     RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
ORACLE10      2512774806 oracle10            1 10.2.0.4.0  NO  xxxx


              Snap Id      Snap Time      Sessions Curs/Sess
            --------- ------------------- -------- ---------
Begin Snap:     23362 19-Dec-14 10:00:12       584       1.2
  End Snap:     23363 19-Dec-14 11:00:27       555       1.2
   Elapsed:               60.25 (mins)
   DB Time:              421.86 (mins)


SQL Summary                     DB/Inst: ORACLE10/oracle10  Snaps: 23362-23363


                Elapsed
   SQL Id      Time (ms)
------------- ----------
6v84tf3dmx5rb  3,530,367
select * from MEDREC.HT_MEDICAL_ORDER where INSERTFLAG in('1','2') and ROWNUM<=
1000 order by FLOWID






Full SQL Text


SQL ID       SQL Text
------------ -----------------------------------------------------------------
6v84tf3dmx5r select * from MEDREC.HT_MEDICAL_ORDER where INSERTFLAG in('1', '2
             2') and ROWNUM<=1000 order by FLOWID




來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8494287/viewspace-1377152/，如需轉載，請註明出處，否則將追究法律責任。

相關文章