Hi,
I made an select message_text from X$DBGALERTEXT where rownum <= 20;
And i see
[code]
"CLI notifier numLatches:3 maxDescs:519
"
"**********************************************************************
"
"Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
"
" Per process system memlock (soft) limit = 64K
"
" Expected per process system memlock (soft) limit to lock
"
" SHARED GLOBAL AREA (SGA) into memory: 1440M
"
" Available system pagesizes:
"
" 4K, 2048K
"
" Supported system pagesize(s):
"
" PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
"
" 4K Configured 368642 368642 NONE
"
" Reason for not supporting certain system pagesizes:
"
" 2048K - Dynamic allocate and free memory regions
"
"RECOMMENDATION:
"
" 1. Increase per process memlock (soft) limit to at least 1440MB
"
" to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory
"
"**********************************************************************
"
"LICENSE_MAX_SESSION = 0
"
"LICENSE_SESSIONS_WARNING = 0
"
[/code]
How could increase memlock (soft) limit to at least 1440MB ?
Regards