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

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

相關文章