- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 9i requirement for nfile is LARGE
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 05:39 AM
тАО06-10-2004 05:39 AM
Oracle 9i requirement for nfile is LARGE
nfile current formula is this:
(16*(NPROC+16+MAXUSERS)/10+32+2*(NPTY+NSTRPTY+NSTRTEL))
As you can see, the values of NPROC and MAXUSERS probably determine the final value of nfile because its a multiple of 16. What is the largest value NPROC and maxusers can be?
Has anyone attempted to change the nfile defauly formula to (15*NPORC+2048)? I believe HP recommends not to change the defauly formula, so I am trying to find other ways to get nfile up to 74348.
Any tips guys and gals?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 05:48 AM
тАО06-10-2004 05:48 AM
Re: Oracle 9i requirement for nfile is LARGE
My 'nfile' parameters are simple numbers. Not formulae. I do not believe HP recommends to follow the formulae anymore.
Your nproc is set to 4820. Unless you think that your system will run those many processes, you can reduce it. Look at your current numbers using the formula 'sar -v 2 20'. Depending on them you can set the values of nproc and nfile initially and then change them after seeing the trend over a week or so.
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 05:54 AM
тАО06-10-2004 05:54 AM
Re: Oracle 9i requirement for nfile is LARGE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 05:56 AM
тАО06-10-2004 05:56 AM
Re: Oracle 9i requirement for nfile is LARGE
Yes, the production server now has NPROC set to 4820. However, DBA requests that I set nfile formulae to (15*NPROC+2048)....this will turn out a VERY LARGE value for nfile.
Is there any harm to putting this formula in nfile? Does anyone know what the max value I can assign NPROC?
Basically, I need to make nfile as large as 74348 and in otfer to do this, this formula is needed.
By the way, I tried to just assign 74348 to nfile, and I got error messages saying because this was larger than the formula dictates. In other words, the formulae determines how high a value can be assigned.
Has anyone had a case where Oracle requires nfile=74348?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 05:58 AM
тАО06-10-2004 05:58 AM
Re: Oracle 9i requirement for nfile is LARGE
Thanks. But I could not just assign nfile the value of 74348, because the formula was the limiting factor. did you just remove the formula or what?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 06:06 AM
тАО06-10-2004 06:06 AM
Re: Oracle 9i requirement for nfile is LARGE
I just wipe out the formula.
Well it's not really for oracle. The formula is an approximation that there will be 15 openfiles per process which is not unexpected for oracle. I have one system with 61450 and it's running nearly at 80%.
Make the change, watch the system for sometime and then lower if it is too high.
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 06:12 AM
тАО06-10-2004 06:12 AM
Re: Oracle 9i requirement for nfile is LARGE
regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 06:18 AM
тАО06-10-2004 06:18 AM
Re: Oracle 9i requirement for nfile is LARGE
And as just an FYI...the only cost will be in a slightly larger kernel memory footprint as it will have to keep the nfile table in memory.
As Sri points out, make the change & then just watch usage with sar. cron it to run every few minutes to keep an accurate usage history as there may be short spikes that need to be accomodated & a constant cronned sar will catch them.
Rgds,
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 06:28 AM
тАО06-10-2004 06:28 AM
Re: Oracle 9i requirement for nfile is LARGE
(I checked /usr/conf/master.d/core-hpux)
I also like to set a direct value and a formulae. A better way would be set it high enough, and moniot the usage with sar -v 2 10 and glance -t and then tuning it.
Anil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2004 06:37 AM
тАО06-10-2004 06:37 AM
Re: Oracle 9i requirement for nfile is LARGE
That was recommended by SAP.
Rgds...Geoff