Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

oracle 19c on Linux 8: Increase per process memlock (soft) limit to lock 100% SGA

seanzhFeb 24 2025 — edited Feb 24 2025

Hi, Oracle DB is 19.25 on Oracle Linux 8,

I have resource limits set like the screenshot here and yet I always see this warning during DB startup, I even duplicated these resource numbers to /etc/security/limits.conf but nothing can make these warnings go away, please advice, thank you very much in advance

Starting ORACLE instance (normal) (OS id: 2400)

2025-02-24T14:34:42.671433-05:00

************************************************************

Instance SGA_TARGET = 8192 MB and SGA_MAX_SIZE = 9216 MB

************************************************************

2025-02-24T14:34:42.671646-05:00

****************************************************

Sys-V shared memory will be used for creating SGA

****************************************************

2025-02-24T14:34:42.672169-05:00

**********************************************************************

2025-02-24T14:34:42.672235-05:00

Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

2025-02-24T14:34:42.672309-05:00

Per process system memlock (soft) limit = 64K

2025-02-24T14:34:42.672351-05:00

Expected per process system memlock (soft) limit to lock

instance MAX SHARED GLOBAL AREA (SGA) into memory: 9218M

2025-02-24T14:34:42.672432-05:00

Available system pagesizes:

4K, 2048K

2025-02-24T14:34:42.672522-05:00

Supported system pagesize(s):

2025-02-24T14:34:42.672568-05:00

PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)

2025-02-24T14:34:42.672611-05:00

    4K       Configured              22        On-Demand        NONE

2025-02-24T14:34:42.672695-05:00

 2048K                0            4609        On-Demand        NONE

2025-02-24T14:34:42.672736-05:00

RECOMMENDATION:

2025-02-24T14:34:42.672777-05:00

  1. For optimal performance, configure system with expected number

of pages for every supported system pagesize prior to the next

instance restart operation.

2025-02-24T14:34:42.693701-05:00

  1. Increase per process memlock (soft) limit to at least 9218MB

to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory

2025-02-24T14:34:42.693795-05:00

**********************************************************************

Screenshot 2025-02-24 at 2.59.51 PM.png

Comments

Post Details

Added on Feb 24 2025
2 comments
199 views