- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: NFile setting for Oracle 8.0.5.2
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
тАО02-09-2001 12:49 AM
тАО02-09-2001 12:49 AM
I've a SAP system running oracle 8.0.5.2 on HP-UX 11.0. The host (database server) is a V-class machine with 16Gbyte Memory, 14 CPUs, 3TByte storage. The current Nfile useage at peak is about 234201 out of 300010 (78%) and still increasing. Is there a limit of Nfile setting, for HP-UX kernel or/and Oracle.? Should I further increase the 300010 nfile limit?
Thanks
Nee Shyang
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2001 01:15 AM
тАО02-09-2001 01:15 AM
Re: NFile setting for Oracle 8.0.5.2
Shouls I say : "the sky is the limit" ?
In fact, nfile is only limited by your system memory, so you may still increase its value.
Here is a link with good explanations about configurable kernel parameters:
http://docs.hp.com/hpux/onlinedocs/os/KCparams.OverviewAll.html
Best regards,
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2001 01:23 AM
тАО02-09-2001 01:23 AM
SolutionA SAP work process connects to an oracle shadow process to do it's work for it.
The shadow process opens database files,
however, as you increase sap workprocesses, you get more shadow processes, each shadow process can potentially open all the database files.
& there seems like there is a maxof 300 on the shadow processes, so worst case scenario is that nfile should be
# of shadow x #of files that make up the database
+ some overhead for the system.
eg db using file systems for the database, it has 123
seperate files x 300 shadow processes = 36900 , plus some for the system,s o nfile should stabilize around 40000 worst case.
seems that sap and oracle is very inefficient in this respect. if you use raw file systems you would not see this as you would only open fd to the rlvol and oracle would take it from there.
The research i've found indicates that you just up nfile until sap and oracle is happy.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2001 01:59 AM
тАО02-09-2001 01:59 AM
Re: NFile setting for Oracle 8.0.5.2
Thanks. That's what I need, both on OS aspect and SAP/Oracle aspect.
Thanks guys.
Lai
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2001 03:42 AM
тАО02-09-2001 03:42 AM
Re: NFile setting for Oracle 8.0.5.2
Alex is almost OK. I dont know other limit for shadows process than memory and tunable paramters, both unix and oracle.
About ussing raw devices, the number of fd is the same as is using filesystem, because shadows open datafiles for read.
You must review nfile, numproc, maxfiles and other in UX side, and similar parameters for oracle ( nfiles, processes ...).
The best is your are previewing problems.
Good job.