event 10261 可以作为临时处理ora-4030错误的一个手段
[oracle@node1 bdump]$ oerr ora 10261
10261, 00000, "Limit the size of the PGA heap"
// *Cause: the limit is one kilobyte times the level of the event. If the
// pga grows bigger than this signal an internal error.
// *Action:
1.10g
SYS AS SYSDBA @ db1 >select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
alter session set events '10261 trace name context forever, level 10000'; (10000k)
SYS AS SYSDBA @ db1 >declare
2 type typ_tables is table of varchar2(1000) index by binary_integer;
3 tmp_tables typ_tables;
4 i number;
5 begin
6 for i in 1..100000
7 loop
8 tmp_tables(i) := lpad('a',1000,'a');
9 end loop;
10 dbms_lock.sleep(1000);
11 end;
12 /
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [723], [16384], [pga heap], [], [],
[], [], []
2.11g
11g增加了event 10260, ora-10260代替了ora-00600
[oracle@node1 trace]$ oerr ora 10260
10260, 00000, "limit size (%s) of the PGA heap set by event 10261 exceeded"
// *Cause: The PGA memory use exceeded the limit set by the event 10261.
// *Action: Check event 10261 settings.
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
alter session set events '10261 trace name context forever, level 10000'; (10000k)
SQL> declare
2 type typ_tables is table of varchar2(1000) index by binary_integer;
3 tmp_tables typ_tables;
4 i number;
5 begin
6 for i in 1..100000
7 loop
8 tmp_tables(i) := lpad('a',1000,'a');
9 end loop;
10 dbms_lock.sleep(1000);
11 end;
12 /
declare
*
ERROR at line 1:
ORA-10260: limit size (10000) of the PGA heap set by event 10261 exceeded
为了进一步诊断可以dump pga
alter system set events '600 trace name heapdump level 0x20000001';
or
alter system set events '10261 trace name heapdump level 0x20000001';
也可以填充v$process_memory_detail
[oracle@node1 bdump]$ oerr ora 10261
10261, 00000, "Limit the size of the PGA heap"
// *Cause: the limit is one kilobyte times the level of the event. If the
// pga grows bigger than this signal an internal error.
// *Action:
1.10g
SYS AS SYSDBA @ db1 >select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
alter session set events '10261 trace name context forever, level 10000'; (10000k)
SYS AS SYSDBA @ db1 >declare
2 type typ_tables is table of varchar2(1000) index by binary_integer;
3 tmp_tables typ_tables;
4 i number;
5 begin
6 for i in 1..100000
7 loop
8 tmp_tables(i) := lpad('a',1000,'a');
9 end loop;
10 dbms_lock.sleep(1000);
11 end;
12 /
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [723], [16384], [pga heap], [], [],
[], [], []
2.11g
11g增加了event 10260, ora-10260代替了ora-00600
[oracle@node1 trace]$ oerr ora 10260
10260, 00000, "limit size (%s) of the PGA heap set by event 10261 exceeded"
// *Cause: The PGA memory use exceeded the limit set by the event 10261.
// *Action: Check event 10261 settings.
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
alter session set events '10261 trace name context forever, level 10000'; (10000k)
SQL> declare
2 type typ_tables is table of varchar2(1000) index by binary_integer;
3 tmp_tables typ_tables;
4 i number;
5 begin
6 for i in 1..100000
7 loop
8 tmp_tables(i) := lpad('a',1000,'a');
9 end loop;
10 dbms_lock.sleep(1000);
11 end;
12 /
declare
*
ERROR at line 1:
ORA-10260: limit size (10000) of the PGA heap set by event 10261 exceeded
为了进一步诊断可以dump pga
alter system set events '600 trace name heapdump level 0x20000001';
or
alter system set events '10261 trace name heapdump level 0x20000001';
也可以填充v$process_memory_detail
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/37279/viewspace-1867660/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/37279/viewspace-1867660/