WARNING: Detected too many memory locking problems
My alert log file entries:
Current log# 3 seq# 4645 mem# 0: <DATAFILE_LOCATION>/redo03.log
Wed May 21 21:19:53 2014
WARNING: Detected too many memory locking problems.
WARNING: Performance degradation may occur.
The real cause of those warnings is the file oradism located on $ORACLE_HOME/bin folder was lacking permission.
As per meta link note 374367.1, issuing the following command should stop the warnings to get generated:
1- cd $ORACLE_HOME/bin
2- chmod 4550 oradism
3- chmod g+s oradism
4- chown root:dba oradism
5- Bounce the database