event 10261 and pga

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/37279/viewspace-1867660/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/37279/viewspace-1867660/