awrrpt.sqll生成awr报ORA-06502,ORA-06512 客户环境SumOS操作系统,数据库版本11.2.0.3,rac两节点; 在节点2,执行awr报告,输出报错,有时候可以成功,有时候失败。 报错现象 SQL>@?/rdbms/admin/awrrpt.sql ORA-6502: PL/SQL: numeric or value error: characterstringb
9、alue for report_name:Using the report name awrrpt_1_70_71.txtWORKLOAD REPOSITORY report forDB Name DB Id Instance Inst Num Release RAC Host ORCLDB 2080780909 orcldb1 1 10.2.0.4.0 YES sun880-1Snap Id Snap Time Sessions Curs/Sess - Begin Snap: 70 27-Jan-08 04:55:07 136 16.2End...
DB NameDB IdInstanceInst numStartup TimeReleaseRAC DB11G 196335337 DB11G 1 05-Oct-10 12:10 11.2.0.2.0 NOHost NamePlatformCPUsCoresSocketsMemory (GB) oel5-11gR2-demo.localdomain Linux x86 64-bit 1 1.96Snap IdSnap TimeSessionsCursors/Session Begin Snap: 70 05-Oct-10 16:00:39 41 4.8 ...
DB NameDB IdInstanceInst numStartup TimeReleaseRAC SDSLDB 3951945579 SDSLDB1 1 16-Nov-12 20:11 11.2.0.3.0 YESHost NamePlatformCPUsCoresSocketsMemory (GB) SDSLDB1 Linux x86 64-bit 160 80 8 504.72Snap IdSnap TimeSessionsCursors/Session Begin Snap: 143 22-Nov-12 09:00:30 90 1.5 End ...
DB NameDB IdInstanceInst numStartup TimeReleaseRAC O10G 166537304 o10g 1 09-Sep-12 14:09 11.2.0.3.0 NOHost NamePlatformCPUsCoresSocketsMemory (GB) dbserver1 AIX-Based Systems (64-bit) 32 8 30.88Snap IdSnap TimeSessionsCursors/Session Begin Snap: 6603 19-Nov-12 08:00:15 261 2.2 End...