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
- 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
- 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
**********************************************************************