- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Regarding system parameters for Oracle DB with...
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
тАО11-30-2004 11:59 PM
тАО11-30-2004 11:59 PM
Regarding system parameters for Oracle DB with 2 instance
We are running 2 instance of oracle database on rp3440 with 8 gb RAM and 4 processors.Now i want to know whether we need to double the parameters specified by oracle eg nproc=4096 for one instance.What will be the optimized setting for kernel. We are running HP-UX 11i.if anyone have a same kind of setup pls suggest. we are using Oracle EBS 11.5.9, oracle apps with Databse.
Regs
Satish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2004 12:30 AM
тАО12-01-2004 12:30 AM
Re: Regarding system parameters for Oracle DB with 2 instance
sar -v 5 5
glance -t
If it is unneccesarily high set it slightly low.
Anil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2004 12:34 AM
тАО12-01-2004 12:34 AM
Re: Regarding system parameters for Oracle DB with 2 instance
To follow your example of nproc, it specifies the maximum number of processes allowed to be launched at a time. If each database is configured for a max processes number of 100, 4096 is enough.
So it depends on your Oracle configuration for each DB. Even with one DB, you may have to increase parameter given by Oracle.
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
тАО12-01-2004 02:57 AM
тАО12-01-2004 02:57 AM
Re: Regarding system parameters for Oracle DB with 2 instance
We have around 800 process on both DBs.So i think nproc is fine. but still when we execute some command it took a second or 2 before executing. i have checked load and its not more than 5 total.. sar output for ur ref:
HP-UX ERP3 B.11.11 U 9000/800 12/01/04
19:09:52 %usr %sys %wio %idle
19:09:57 0 3 0 96
19:10:02 2 4 1 94
19:10:07 1 3 2 95
19:10:12 1 3 0 95
19:10:17 0 3 0 96
Average 1 3 1 95
whats wrong?? any help will be very appreciated.
regs
Satish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2004 09:28 PM
тАО12-01-2004 09:28 PM
Re: Regarding system parameters for Oracle DB with 2 instance
Check:
#sar -b 5 15
And:
#sar -v 5 15
And finally:
#swapinfo -tam
Best Regards,
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2004 09:37 PM
тАО12-01-2004 09:37 PM
Re: Regarding system parameters for Oracle DB with 2 instance
sar -ubw 10 6 # this one will run 1 minute
swapinfo -tam
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
тАО12-01-2004 09:54 PM
тАО12-01-2004 09:54 PM
Re: Regarding system parameters for Oracle DB with 2 instance
top -n $(ps -edf | wc -l) -f /tmp/frutopfile.$$ && cat /tmp/frutopfile.$$ && rm /tmp/frutopfile.$$
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
тАО12-02-2004 03:33 AM
тАО12-02-2004 03:33 AM
Re: Regarding system parameters for Oracle DB with 2 instance
Thanks so much to u all guys. I m attaching the output of commands u were asking. pls have a look and suggest. Thanks Again
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2004 03:51 AM
тАО12-02-2004 03:51 AM
Re: Regarding system parameters for Oracle DB with 2 instance
From the output of top, it seems you are using more than 1200Mb for the Oracle SGA (System Global Area) and Buffer Cache. In my opinion, this is too much... You need to tune this 2 paramaters: See Metalink Note 100709.1
Kindest Regards,
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2004 05:32 AM
тАО12-02-2004 05:32 AM
Re: Regarding system parameters for Oracle DB with 2 instance
Why is this too much ? With 8GB of RAM, 1.2GB allocated for oracle is not much.
Satish,
You're talking about 2 instances, and I can only see one. top output may not be ful as long as We don't have header, and I don't see vhand (wich was my goal). I would really like to see the line from top for vhand process (and optinally uptime).
Regarding to stats you're system is swapping, and (yes, once again) I'm asking what is your settings for OS dbc.
Could you please give output for "mount" command (without parameter) and for those two :
kmtune -q dbc_max_pct
kmtune -q dbc_min_pct
Also, do you have Online JFS ?
It makes many command I ask for, but I have an idea behind all of that :)
Regards,
Fred
"Reality is just a point of view." (P. K. D.)