shmmax

2025-08-14Oracle / RAC

OS资源被耗尽,Process J000 is dead

通常建议shmmax设置大些,把sga限制在一个共享内存段中。

Memory Resources The resources provided by the UNIX default kernels are often inadequate for a medium or large instance of Oracle Database. The maximum size of a shared memory segment (SHMMAX) and maximum number of semaphores available (SEMMNS) may be too low for Oracle Database recommendations.

由UNIX默认内核提供的资源往往是不足的中型或大型的数据库实例。最大的共享内存段的大小(SHMMAX)和信号量可用的最大数目(SEMMNS)可能太低对Oracle数据库的建议。

On Windows, fewer resources are needed for interprocess communication (IPC), because the Oracle Database relational database management system is thread-based and not process-based. These resources, including shared memory and semaphores, are not adjustable by the user.

在Windows中,更少的资源用于进程间通信(IPC)所需要的,因为Oracle数据库的关系型数据库管理系统是基于线程的而不是进程。这些资源,包括共享内存和信号量,都是用户不可修改的。