paging space空间不足引起数据库宕机问题

最新推荐文章于 2023-08-09 15:21:31 发布

newzqs

最新推荐文章于 2023-08-09 15:21:31 发布

阅读量1.2k

点赞数

分类专栏： oracle 文章标签：数据库 deployment system oracle command aix

本文链接：https://blog.csdn.net/newzqs/article/details/4256661

版权

在AIX 5300-04环境中，Oracle 10.2.0数据库遇到由于paging space空间不足引发的错误，如ORA-27300等。Oracle建议paging space初始设置为内存的一半加4G，最大32G，并通过'lsps -a'命令监控使用情况。当%used超过25%时，可能是系统RAM不足。解决方案是将paging space增加到48G，问题得到解决。

摘要由CSDN通过智能技术生成

环境：AIX 5300-04, oracle 10.2.0

现象：在Alert日志中会出现

Wed Mar 11 04:55:39 2009
Errors in file /oracle/admin/alarm/bdump/alarm_psp0_828600.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Wed Mar 11 04:55:40 2009
Process J000 died, see its trace file
Wed Mar 11 04:55:40 2009
kkjcre1p: unable to spawn jobq slave process
Wed Mar 11 04:55:40 2009
Errors in file /oracle/admin/alarm/bdump/alarm_cjq0_893232.trc:

oracle建议：

As a general rule, a initial setting for the paging space is half size of memory plus 4G, with an upper limit 32G.Monitor the paging space use command 'lsps -a'.The metric %used in the output of lsps -a is typically less than 25% on a health