I was working well before changing below code.

alter database archivelog; alter system set sga_max_size = 20480M scope=spfile;

Currently Error is

ORA-27106: system pages not available to allocate memory additional information 6128
4

1 Answer

Check shmmax kernel parameter and set to recommended value- This parameter defines the maximum size in bytes of a single shared memory segment that a Linux process can allocate in its virtual address space.

Caution - when tying to allocate SGA size bigger than SHMMAX the error below occur. “SGA size con not be greater than maximum shared memory segment size (shmmax value)”

If shm* parameter are set, then look at hugepages (it may be due to insufficient HugePages)

grep -huge /proc/meminfo

and try to free it.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.