Hi Naresh, Please check the oracle parameter (MAX_DUMP_FILE_SIZE). its Controls the maximum size of the trace file generatedby the SQL Trace facility. by default it is set to unlimited. i guess in your case it might be set to 2g. SQL> show parameter MAX_DUMP_FILE_SIZE;
Regards, Aijaz --- On Wed, 9/16/09, Naresh Rawat <[email protected]> wrote: From: Naresh Rawat <[email protected]> Subject: Re: [LinuxVadaPav] File limitation on RHEL4 To: [email protected] Date: Wednesday, September 16, 2009, 4:28 PM Manas -- I already have this set. See below: # ulimit -aH core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 65535 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 16384 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited Naresh R. ____________ _________ _________ __ From: Manas Burad <manas_burad@ yahoo.com> To: linuxvadapav@ yahoogroups. com Sent: Wednesday, 16 September, 2009 3:34:51 PM Subject: Re: [LinuxVadaPav] File limitation on RHEL4 Hi Naresh, See if this helps: Linux limits the number of file descriptors that any one process may open; the default limits are 1024 per process. The open file limit is one of the limits that can be tuned with the ulimit command. The command ulimit -aS displays the current limit, and ulimit -aH displays the hard limit (above which the limit cannot be increased without tuning kernel parameters in /proc). The following is an example of the output of ulimit -aH. You can see that the current shell (and its children) is restricted to 1024 open file descriptors. core file size (blocks) unlimited data seg size (kbytes) unlimited file size (blocks) unlimited max locked memory (kbytes) unlimited max memory size (kbytes) unlimited open files 1024 pipe size (512 bytes) 8 stack size (kbytes) unlimited cpu time (seconds) unlimited max user processes 4094 virtual memory (kbytes) unlimited Increasing the file descriptor limit The file descriptor limit can be increased using the following procedure: 1. Edit /etc/security/ limits.conf and add the lines: 2. * soft nofile 1024 3. * hard nofile 65535 4. Edit /etc/pam.d/login, adding the line: 5. session required /lib/security/ pam_limits. so 6. The system file descriptor limit is set in /proc/sys/fs/ file-max. The following command will increase the limit to 65535: 7. echo 65535 > /proc/sys/fs/ file-max 8. You should then be able to increase the file descriptor limits using: 9. ulimit -n unlimited The above command will set the limits to the hard limit specified in /etc/security/ limits.conf. Note that you may need to log out and back in again before the changes take effect. Try this on your own risk. Please don't blame me if anything goes wrong. Regards Manas "Have shraddha(faith) and saburi(patience) - Saibaba of Shirdi" --- On Wed, 9/16/09, Naresh Rawat <rawatn_1980@ yahoo.co. in> wrote: From: Naresh Rawat <rawatn_1980@ yahoo.co. in> Subject: [LinuxVadaPav] File limitation on RHEL4 To: "Linux Vada" <linuxvadapav@ yahoogroups. com> Date: Wednesday, September 16, 2009, 3:05 PM Hi guys, I have oracle database running on RHEL 4. A trace file gets created by the database user. My issue is the file size is limited to 2 gigs, wherein i have set ulimit to unlimited. See below: # ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 4096 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 2047 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited Can you please advice what wrong i am doing or how to resolve this. Thanks in advance. Naresh R. Yahoo! India has a new look. Take a sneak peek http://in.yahoo. com/trynew [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket. yahoo.com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
