oracle执行命令hang住,ORACLE老是hang住，终止事例

ORACLE老是hang住，终止事例

系统为p550 ,5300-08-09系统，系统32G内存，oracle 10.2.0.50，paging space=16g  白天使用率5%附件为trc文件；

前几天用友改了SGX参数

刚开始SGX只有2G

sgx_max_size=18g

sgz_target=18g

现在为什么资源耗尽！

oracle hang住了

Wed Jun 04 19:19:35 BEIST 2014

Errors in file /oracle/admin/ncdb/bdump/ncdb_smon_438398.trc:

ORA-00060: deadlock detected while waiting for resource

ORA-00469: CKPT process terminated with error

Wed Jun 04 19:19:40 BEIST 2014

MMNL: terminating instance due to error 472

系统日志：

Description

SOFTWARE PROGRAM ABNORMALLY TERMINATED

Probable Causes

SYSTEM RUNNING OUT OF PAGING SPACE

Failure Causes

INSUFFICIENT PAGING SPACE DEFINED FOR THE SYSTEM

PROGRAM USING EXCESSIVE AMOUNT OF PAGING SPACE

Recommended Actions

DEFINE ADDITIONAL PAGING SPACE

REDUCE PAGING SPACE REQUIREMENTS OF PROGRAM(S)

Detail Data

PROGRAM

oracle

USER'S PROCESS ID:

21585

PROGRAM'S PAGING SPACE USE IN 1KB BLOCKS

4

这个是什么问题