- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Parameter: forking more parallel processes
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
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
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
09-07-2015 09:38 AM
09-07-2015 09:38 AM
Parameter : forking more parallel processes
- parallel_max_servers database parameter should be set to value 160 instead of 16.
Oracle default value for this parametere is CPU_COUNT x PARALLEL_THREADS_PER_CPU x (2 if PGA_AGGREGATE_TARGET > 0; otherwise 1) x 5.
In our case, CPU_COUNT is 8, PARALLEL_THREADS_PER_CPU is 2, PGA_AGGREGATE_TARGET > 0, hence we need to multiply by 2.
Hence value for this parameter should be, 8 X 2 X 2 X 5 = 160
--------------
OS version : HPUX 11i v3
model :BL 870c i2
server is configured as HPVM.
Can you please tell me if above oracle parameter change can be applied in HP UX.
When I google it,Oracle docs says it is OS dependant.
default value is 2.
Does HP UX supports those field.
what are the parameters in OS that are related to those Database parameters.
How to find does this model supports PARALLEL_THREADS_PER_CPU
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-07-2015 04:19 PM
09-07-2015 04:19 PM
Re: Parameter: forking more parallel processes
>How to find does this model supports PARALLEL_THREADS_PER_CPU
This is probably talking about hyperthreading. I.e. PARALLEL_THREADS per core.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-08-2015 05:44 AM
09-08-2015 05:44 AM
Re: Parameter: forking more parallel processes
hi
but As i aware Hyper threading can't be set in HPVM.
is there any possible way to find what is the value of parellel threads for a cpu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-08-2015 10:18 AM
09-08-2015 10:18 AM
Re: Parameter: forking more parallel processes
>As I aware Hyper threading can't be set in HPVM.
>is there any possible way to find what is the value of parallel threads for a core
Then the value is just one.