出现ORA-00600:internal error code,arguments:[733],[1277174832],[pga heap],[],[]

显示全部楼层 · 2005-12-16 09:47:56

启动数据库时出现如下错误：
ORA-00600:internal error code,arguments:[733],[1277174832],[pga heap],[],[],[],[],[]
请问如何处理，谢谢！

千问 · 2005-12-16 09:47:56

你的oracle版本是多少？

千问 · 2005-12-16 09:47:56

最初由 kang_krs 发布
[B]启动数据库时出现如下错误：
ORA-00600:internal error code,arguments:[733],[1277174832],[pga heap],[],[],[],[],[]
请问如何处理，谢谢！ [/B]
600的报错几乎都与bug相关，你的报错与pga相关，检查pga相关设置。
如果你的workarea_size_policy设的是手动的话，适当的降低一下sort_area_size。
同时要适当的降低一下hash_area_size .
再试一下。

千问 · 2005-12-16 09:47:56

ERROR:

ORA-600 [733] [a]

VERSIONS:
versions 7.0 to 9.2

DESCRIPTION:
When allocating an extent in the PGA, if the minimum size requested is
greater than what is allowed for this port, ORA-600 [733] is reported.
This is a Program Global Area (PGA) heap/memory allocation error.

ARGUMENTS:
Arg [a] The minimum extent size requested, in bytes.
ArgA comment supplied by the caller.

FUNCTIONALITY:
MEMORY IMPLEMENATION

IMPACT:

PROCESS FAILURE
NON CORRUPTIVE - No corruption to underlying data.

SUGGESTIONS:
If receiving this during a query with complex JOIN, for example, consider
lowering sort_area_size or hash_area_size (if hash_join_enabled = true)
and rerun the query. This will reduce the PGA memory requirements and may
clear the problem.