cts创建表ora-00600

最新推荐文章于 2025-03-05 15:02:10 发布

执笔画情ora

最新推荐文章于 2025-03-05 15:02:10 发布

阅读量572

点赞数

分类专栏： ORACLE数据库故障处理分析

本文链接：https://blog.youkuaiyun.com/oradbm/article/details/52240003

版权

ORACLE数据库故障处理分析专栏收录该内容

24 篇文章

订阅专栏

最近在帮助网友处理一个关于ora-00600内部报错问题。

创建语句为create table t1 sa select * from t2;

在执行cretae table tablename1 as select * from tabelname2时，报错如下：

ORA-00600: 内部错误代码, 参数: [KGHALP1], [0X000000000], [], [], [], [], [], []

查询相关metalink文档如下：

Bug 10378052 - ORA-600[KGHALP1] during insert of XMLType (文档 ID 10378052.8)

转到底部

Bug 10378052 ORA-600[KGHALP1] during insert of XMLType

This note gives a brief overview of bug 10378052.
The content was last updated on: 29-JUN-2016
Click here for details of each of the sections below.

Affects:

Product (Component) Oracle Server (Xdb)
Range of versions believed to be affected (Not specified)
Versions confirmed as being affected
11.2.0.3
11.2.0.2

Platforms affected Generic (all / most platforms affected)

Fixed:

The fix for 10378052 is first included in
12.1.0.1 (Base Release)
11.2.0.4 (Server Patch Set)
11.2.0.3 Patch 32 on Windows Platforms

Interim patches may be available for earlier versions - click here to check.

Symptoms:	Related To:
Internal Error May Occur (ORA-600) ORA-600 [KGHALP1] Stack is likely to include qmxEvAllocMem	XDB

Description

ORA-600[KGHALP1] can occur when inserting an XMLType
 
Rediscovery Notes
  ORA-600[KGHALP1] with xmltype
  The trace is likely to show the error is on heap name="qmxlu subheap" 
 
Workaround
 The ORA-600 occurs as the memory size request is too large. 
 This fix changes the internal error to a graceful user error .
 Hence a workaround is to address the reason for needing a very large
  memory allocation if the cause can be identified.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

解决方案如下: