系统为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
这个是什么问题
收起