01-01-2020
Quote:
Greetings and Happy New Year!
You can't judge like that what is good/bad...
Oracle is no ordinary user: many users access to files using oracle UID the same for processes etc
So it will depend on the size of your RDBMS or how many instances you have running on a server, how many processes are "oracle" etc the same for files and file size: no ordinary user would produce a file on a system the size of a full export (oracle)...
Why unlimited as value is not a good idea unless you know what you are doing AND what the others do:
Just an example: if a coder badly checked his new code that went in production ( or just a bug...) fall on a case you case have files opening but not closed correctly, worse though quite funny when it occurs: executing an infinite loop opening new processes...
You end with a freeze of the system where if lucky and an admin can connect will shutdown gracefully the box, more severe no one can connect and you have no other choice but to power off...
AIX at least lets you define on a specific user basis, may not be the case of all Unixes you see
Addendum:
Q: Do you have any issues? Giving a lot of resources will give you peace ( no errors or warning of running out of resources...) only that waste of resource will affect performance, if that is OK with you and production are happy, well why worry except for the case you do have an issue, it will be in proportion with what you gave
This part makes sense. Some users know what they are doing and some don't.
Why unlimited as value is not a good idea unless you know what you are doing AND what the others do:
They said they were having trouble creating the files they need to create.
10 More Discussions You Might Find Interesting
1. AIX
Hi,
I have a query that suppose the first or last name of the user changes and we need to change its userid for aix too. Then in that case how do we handle this scenario??I guess we can't change the user id so we should re-create the new id and associate all the data of the old id. But I donno... (1 Reply)
Discussion started by: tintin@10
1 Replies
2. UNIX for Dummies Questions & Answers
ulimit -a gives the following output:$ulimit -a
time(seconds) unlimited
file(blocks) 2097152
data(kbytes) 131072
stack(kbytes) 16384
memory(kbytes) unlimited
coredump(blocks) 32768
nofiles(descriptors) 400
vmemory(kbytes) 147456
Abot output... (3 Replies)
Discussion started by: nervous
3 Replies
3. AIX
how to set the ulimit on AIX 5.2 version? (3 Replies)
Discussion started by: Shilpi
3 Replies
4. AIX
Hi Guys,
How do I increase the filesize ulimit for user jf01474, using the same value as of user oracle?
Ex: /etc/security/limits
default:
fsize = 4194302
core = 2097151
cpu = -1
data = 262144
rss = 65536
stack = 65536
... (3 Replies)
Discussion started by: sky_lark02
3 Replies
5. HP-UX
Hi,
on HP-UX when I run command
ulimit -a
I get
time(seconds) 4096
file(blocks) unlimited
data(kbytes) 1048576
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 4096
Now I want to change
file(blocks) ... (2 Replies)
Discussion started by: namita.mundada
2 Replies
6. UNIX for Dummies Questions & Answers
Hello AIX gurus,
I have a requirement where I have to change user ID of user "myuser" from 100 to 200 and also the group ID of "mygroup" from 2 to 3. Please note that "myuser" has "mygroup" as it's primary group.
What steps do I need to follow for this and in what order? Also can you please... (2 Replies)
Discussion started by: sacguy08
2 Replies
7. AIX
Hello,
How can I setup the ulimit for memory permanent
ulimit -m unlimited
ulimit -a Output from the ulimit command should be similar to the following:time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 2097152
stack(kbytes) 32768... (4 Replies)
Discussion started by: filosophizer
4 Replies
8. UNIX for Dummies Questions & Answers
Hello All,
If a user in AIX is locked due to multiple failed login attempts. How do I find out the IP address from where failed attempts were made?
regards,
Roshni (0 Replies)
Discussion started by: RoshniMehta
0 Replies
9. Red Hat
The root user runs the following
ulimit -a | grep open
and gets a result of
open files (-n) 8162
A user runs the same command and gets a result of
open files (-n) 2500
How can you set the ulimit of the user to... (2 Replies)
Discussion started by: jsanders
2 Replies
10. AIX
Hi,
what are the ideal/best/recommended ulimit settings for a root user in AIX?
I understand that it depends on our environment. But I would like to know...what are settings you guys use in your environment for best performance.
default:
fsize = 2097151
core = 2097151
... (8 Replies)
Discussion started by: System Admin 77
8 Replies
ULIMIT(3P) POSIX Programmer's Manual ULIMIT(3P)
PROLOG
This manual page is part of the POSIX Programmer's Manual. The Linux implementation of this interface may differ (consult the correspond-
ing Linux manual page for details of Linux behavior), or the interface may not be implemented on Linux.
NAME
ulimit -- get and set process limits
SYNOPSIS
#include <ulimit.h>
long ulimit(int cmd, ...);
DESCRIPTION
The ulimit() function shall control process limits. The process limits that can be controlled by this function include the maximum size of
a single file that can be written (this is equivalent to using setrlimit() with RLIMIT_FSIZE). The cmd values, defined in <ulimit.h>,
include:
UL_GETFSIZE Return the file size limit (RLIMIT_FSIZE) of the process. The limit shall be in units of 512-byte blocks and shall be inherited
by child processes. Files of any size can be read. The return value shall be the integer part of the soft file size limit
divided by 512. If the result cannot be represented as a long, the result is unspecified.
UL_SETFSIZE Set the file size limit for output operations of the process to the value of the second argument, taken as a long, multiplied
by 512. If the result would overflow an rlim_t, the actual value set is unspecified. Any process may decrease its own limit,
but only a process with appropriate privileges may increase the limit. The return value shall be the integer part of the new
file size limit divided by 512.
The ulimit() function shall not change the setting of errno if successful.
As all return values are permissible in a successful situation, an application wishing to check for error situations should set errno to 0,
then call ulimit(), and, if it returns -1, check to see if errno is non-zero.
RETURN VALUE
Upon successful completion, ulimit() shall return the value of the requested limit. Otherwise, -1 shall be returned and errno set to indi-
cate the error.
ERRORS
The ulimit() function shall fail and the limit shall be unchanged if:
EINVAL The cmd argument is not valid.
EPERM A process not having appropriate privileges attempts to increase its file size limit.
The following sections are informative.
EXAMPLES
None.
APPLICATION USAGE
Since the ulimit() function uses type long rather than rlim_t, this function is not sufficient for file sizes on many current systems.
Applications should use the getrlimit() or setrlimit() functions instead of the obsolescent ulimit() function.
RATIONALE
None.
FUTURE DIRECTIONS
The ulimit() function may be removed in a future version.
SEE ALSO
exec, getrlimit(), write()
The Base Definitions volume of POSIX.1-2008, <ulimit.h>
COPYRIGHT
Portions of this text are reprinted and reproduced in electronic form from IEEE Std 1003.1, 2013 Edition, Standard for Information Technol-
ogy -- Portable Operating System Interface (POSIX), The Open Group Base Specifications Issue 7, Copyright (C) 2013 by the Institute of
Electrical and Electronics Engineers, Inc and The Open Group. (This is POSIX.1-2008 with the 2013 Technical Corrigendum 1 applied.) In the
event of any discrepancy between this version and the original IEEE and The Open Group Standard, the original IEEE and The Open Group Stan-
dard is the referee document. The original Standard can be obtained online at http://www.unix.org/online.html .
Any typographical or formatting errors that appear in this page are most likely to have been introduced during the conversion of the source
files to man page format. To report such errors, see https://www.kernel.org/doc/man-pages/reporting_bugs.html .
IEEE
/The Open Group 2013 ULIMIT(3P)