SQL> @ /rdbms/admin/awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1083126127 COGDB 1 cogdb
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
输入 report_type 的值: text
Type Specified: text
最后结果成功生成：
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
control_files /home/oracle/controlfile/cogdb/co
/oradb/app/oracle/oradata/control
---------------------------------------------
Dynamic Remastering Stats DB/Inst: COGDB/cogdb Snaps: 9583-9584
No data exists for this section of the report.
-----------------------------------------
End of Report
Report written to awrrpt_1_9583_9584.txt
确认报告内容也是完整的。在SQL Text部分，我们也的确发现了“多种语言”的情况。
-> Captured PL/SQL account for 0.0% of Total DB Time (s): 3,165
Elapsed Elapsed Time
Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id
---------------- -------------- ------------- ------ ------ ------ -------------
298.0 1 297.99 9.4 50.6 26.6 4wfkj936k5qhq
insert into f_cx_cmain ( select T1."POO" as 单号, T1."CLDE" as
类代码, T1."RDE" as代码, T1."CDE" as 公司, T1
."BUODE" as 来源代码, T1."SE" as 起期, T1."EE" as 终期, T1."UNDDDATE" as通过, T2."STATDATE" a
的确和Bug说明的情况相匹配。除了text格式，笔者认为使用OEM产品中的AWR生成模块，也可以避免这类问题的出现。
4、结论
任何软件的使用过程中，Bug是难以避免。当操作结果和我们预想不同、而且从经验判断不是操作失误的时候，就可以考虑是Bug的原因。