Oracle MOS error ora-27163:out of memory solution

Database version
Oracle-> 11g @xifenfei:/home/oracle$sqlplus/as sysdba

Sql*plus:release 11.2.0.4.0 Production on Tue Sep 30 10:28:30 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit Production
With the partitioning, real application clusters, OLAP, Data Mining
and real Application testing options

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 Hpux:version 11.2.0.4.0-production
Nlsrtl Version 11.2.0.4.0-production
Database Patch Information
Oracle-> 11g @xifenfei:/home/oracle$opatch lspatches
18973907;
18795105;
18701707;
18284357;
18020394;
17564992;
17308789;
17306264;
17259786;
17079301;
16477664;
16188701;
14368995;
14245531;
11744544;
18522515;OCW Patch Set update:11.2.0.4.3 (18522515)
18522509;database Patch Set update:11.2.0.4.3 (18522509)
Collection Spa report Ora-27163:out of memory error
sql> SELECT dbms_sqlpa.report_analysis_task (' spa_test ', ' HTML ', ' errors ', ' all ') from dual;

ERROR:
Ora-27163:out of Memory
Ora-06512:at "SYS. Dbms_sqltune_internal ", Line 8211
Ora-06512:at "SYS. Dbms_sqlpa ", line 515
Ora-06512:at Line 1


No rows selected
Set event after collection
Connected.
Sql> alter session SET events ' 31156 Trace name context forever, Level 0x400 ';

Session altered.

sql> SELECT dbms_sqlpa.report_analysis_task (' spa_test ', ' HTML ', ' errors ', ' all ') from dual;

Dbms_sqlpa. Report_analysis_task (' spa_test ', ' HTML ', ' ERRORS ', ' all ')
--------------------------------------------------------------------------------
<title>
SQL Performance Impact Analyzer
Query MOS discovery XML Parser fails with ORA-27163 (out of Memory) (Doc ID 1599434.1), related description:

As documented, the issue has been fixed in 11.2.0.4, but this problem still exists in HP Unix, and experience tells us that MOS now cannot fully believe

Contact: Mobile Phone (13429648788) QQ (107644445)
Link: http://www.xifenfei.com/5533.html