- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Ideal parameters for Oracle
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
Forums
Discussions
Discussions
Discussions
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
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
12-24-2002 01:08 AM
12-24-2002 01:08 AM
Ideal parameters for Oracle
Our HP-UX server is N4000 OS 11.0 , 4 processors, 4GB RAM, Oracle Database 8.1.7.
But our DBA ask me to increase a good value for oracle (memory, proc,...)? But I'm wondering what are good values to increase and for what parameters !!
I need your helps
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2002 01:18 AM
12-24-2002 01:18 AM
Re: Ideal parameters for Oracle
it is very depents on your applics.
very impotent params is :
dbc_max_pct - change it to 10
dbc_min_pct - change it to 5
this is the buffer cashe that you dont need fo rthe oracle .
i will also check this params
fs_async - 0
max_thread_proc - 2048 or more
maxdsiz - more then 2 g.b
maxssiz - 0.5 g.b
also change the maxdsiz and maxssiz for 64 bit
maxuprc - 256
nfile - 5000
nflocks - 300
nkthread - 6000
maxfiles - 512
shmem - 1
i will also advise to look at this link for info about kernel params :
http://www.docs.hp.com/hpux/onlinedocs/939/KCParms/KCparams.OverviewAll.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2002 02:04 AM
12-24-2002 02:04 AM
Re: Ideal parameters for Oracle
the following are the suggested parameters for oracle 8174.
Shared Memory:
SHMMAX 1GB
SHMMIN 1
SHMMNI 512
SHMSEG 32
Semaphores:
SEMMNS 6640
SEMMNI 3320
regds
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2002 02:11 AM
12-24-2002 02:11 AM
Re: Ideal parameters for Oracle
Our parameters are :
dbc_min_pct 5
fs_async 0
max_thread_proc 64
maxdsiz 0x04000000
maxdsiz_64bit 0x0000000040000000
maxssiz 0x00800000
maxssiz_64bit 0x00800000
maxuprc 75
nfile (16*(NPROC+16+MAXUSERS)/10+32+2*(NPTY+NSTRPTY+NSTRTEL))
nflocks 200
nkthread (((NPROC*7)/4)+16)
maxfiles 1024
maxfiles_lim 2048
shmem 1
Are they ok??
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2002 02:54 AM
12-24-2002 02:54 AM
Re: Ideal parameters for Oracle
It seem o.k
check also the dbc_max_pct - if the dbc_min_pct is 5 it is o.k but you need to define also the max size of the buffer cashe .
also i have to say that there isnt any guide line how to config the kernel params for a oracle system , it depents on your system .
i will advise to install mesureware to check the perofrmence of the computer every week to see if you need to change kernel value .
i gave my guide line for hp-ux 11.11 with oracle 8.1.7 but my system is for ovo system
and it is not the same like you .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-24-2002 05:45 AM
12-24-2002 05:45 AM
Re: Ideal parameters for Oracle
We are runninig Oracle 8173 and Inernet Application Server 1.0.2.2 Patch 12 on HP-UX 11.11 64 bit. We are heavily and currently patched, running xvfb for Oracle Reports X Windows.
Steve
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com