联系：手机/微信(+86 17813235971) QQ(107644445)
标题：MOS又一次不靠谱—ORA-27163: out of memory
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
数据库版本
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
数据库补丁信息
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)
收集spa报告报ORA-27163: out of memory错误
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
设置event后收集
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')
--------------------------------------------------------------------------------
<html>
<head>
<title>
SQL Performance Impact Analyzer Report
查询MOS发现XML Parser Fails With ORA-27163 (Out Of Memory) (Doc ID 1599434.1),相关描述:
按照文档描述,该问题在11.2.0.4中已经修复,可是在hp unix中依然存在该问题,经验告诉我们,现在的MOS不能完全相信