My Oracle Support Banner

Ulimit -a Shows Different Values For Nofile When Executed At Sql Prompt For Oracle User (Doc ID 2354773.1)

Last updated on MAY 21, 2020

Applies to:

Oracle Cloud Infrastructure - Version N/A and later
Linux OS - Version Oracle Linux 6.0 and later
Information in this document applies to any platform.


On an Oracle Linux 6 system, we can see the following is configured:

1. limits.conf

oracle soft nproc 2047 -->a
oracle hard nproc 16384 -->b
oracle soft nofile 1024 -->c
oracle hard nofile 65536 -->d


2. ulimits

[oracle@test ~]$ ulimit -a

open files (-n) 1024 <<-- Output = c
max user processes (-u) 2047 <<-- Output = a


3.SQL reported ulimits:

Note: In the below sql prompt "ho ulimit -a" is a command 

 SQL> ho ulimit -a
nofile (-n) 65536 <<--Output ≠ c <hard nofile value is 65536 from limits.conf file but output should reflect soft nofile value>
nproc (-u) 2047 <<-- Output = a

4.  "pmon" process limits

[oracle@test ~]$ ps -ef |grep pmon
10000 13835 1 0 Jan17 ? 00:01:18 ora_pmon_PGWGP0C01
10000 45601 45466 0 08:31 pts/1 00:00:00 grep pmon

[oracle@test ~]$ cat /proc/13835/limits
Limit Soft Limit Hard Limit Units

Max open files 65536 65536 files <<--- Output = d




 There is therefore inconsistency in what is being reported for ulimits by sql vs the system.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.