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

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8494287/viewspace-1377152/