awr报错(html)
SQL> @?/rdbms/admin/awrrpt.sql ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ORA-06512: 在 "SYS.DBMS_WORKLOAD_REPOSITORY", line 919 ORA-06512: 在 line 1
设置errorstack
SQL> alter session set events '6502 trace name errorstack level 12'; 会话已更改。
分析错误
----- Error Stack Dump ----- ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ----- Current SQL Statement for this session (sql_id=572fbaj0fdw2b) ----- select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options )) ----- PL/SQL Call Stack ----- object line object handle number name 94348684 919 package body SYS.DBMS_WORKLOAD_REPOSITORY 983BAD54 1 anonymous block ----- Call Stack Trace ----- _skdstdst()+121 CALLrel _kgdsdst() 19D99520 2 _ksedst1()+93 CALLrel _skdstdst() 19D99520 0 1 485816 4863B2 oracle dba培训 485816 _ksedst()+49 CALLrel _ksedst1() 0 1 _dbkedDefDump()+368 CALLrel _ksedst() 0 6 _ksedmp()+44 CALLrel _dbkedDefDump() C 0 _dbkdaKsdActDriver( CALLreg 00000000 C )+4209 …………