- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle and multiple processor machines.
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
тАО05-20-2003 07:31 AM
тАО05-20-2003 07:31 AM
Is there sql code to check it?
Are there specail entries in init.ora that need to be made?
Is there anything I need to do the HP-UX to make Oracle recognize and take advantage of processor #2?
Points for all efforts, rabbits for full step by step procedures.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2003 07:35 AM
тАО05-20-2003 07:35 AM
Re: Oracle and multiple processor machines.
I am not a big Oracle guy, but I do support an Oracle/SAP environment and I beleive there is a setting in the init.ora file.
Hope this helps!
-Bryan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2003 07:40 AM
тАО05-20-2003 07:40 AM
Re: Oracle and multiple processor machines.
It looks like that setting might be the parallel_max_servers field. There is some reference at that field to number of CPU's
Hope this helps!
-Bryan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2003 07:46 AM
тАО05-20-2003 07:46 AM
Re: Oracle and multiple processor machines.
I did a benchmarking exercise on Oracle 8.1.7.4.0 last year on a Superdome. It used all 32 CPUs that were available.
I believe that under Oracle 8, any use of multiple processors capacity is accomplished by designing the application to be multi-threaded, with different Oracle Processes (PIDS) on different CPUs.
I have noticed that single process queries (really big queries) always tie themselves to a CPU and max it out at 100% until completed.
Share and Enjoy! Ian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2003 08:02 AM
тАО05-20-2003 08:02 AM
Re: Oracle and multiple processor machines.
On Oracle 8 and above on an SMP system the software(oracle) will use all available processors without intervention.
Regards.
RZ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2003 09:08 AM
тАО05-20-2003 09:08 AM
Re: Oracle and multiple processor machines.
HP-UX 64 Bit 11.11
Oracle 8.1.7.4.0 64 bit version.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2003 09:24 AM
тАО05-20-2003 09:24 AM
Re: Oracle and multiple processor machines.
Doc ID: Note:1052756.6
Subject: HOW DOES ORACLE HANDLE LOAD BALANCING ON SMP SYSTEMS WITH MULTIPLE CPU'S?
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 12-JUN-1998
Last Revision Date: 29-APR-1999
Problem Description: ==================== How does Oracle handle load balancing on Symmetric Multi Processor (SMP) systems with multiple CPU's? Search Words: ============= memory, multiple processors, Background processes, scheduler Solution Description: ===================== Any load balancing between processors is handled by the Scheduler, not Oracle. Solution Explanation: ===================== SMP (Symmetric Multi Processor) systems have a common store of memory which is shared by multiple processors. The determination of which processor will handle a specific task is handled by the scheduler. NOTES: ------ 1. This discussion relates to scheduling of the Oracle Background processes, such as pmon, smon, etc. If parallel query is used, specific options may be used to tie a query to a specific processor. 2. Upward scaling in such an architecture tends to be relatively linear on Unix systems.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2003 09:26 AM
тАО05-20-2003 09:26 AM
Re: Oracle and multiple processor machines.
I beleive this is the line you are concerned with in init.ora:
parallel_max_servers = 5 # SMALL
# parallel_max_servers = 4 x (number of CPUs) # MEDIUM
# parallel_max_servers = 4 x (number of CPUs) # LARGE
-Bryan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2003 09:32 AM
тАО05-20-2003 09:32 AM
Re: Oracle and multiple processor machines.
Doc ID: Note:201799.1
Subject: Relevant Parallel Excution INIT.ora Parameters
Type: REFERENCE
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 02-JUL-2002
Last Revision Date: 17-MAY-2003
PURPOSE -------- To provide a list of parameters that are relevant to parallel query, Parallel DML and other operation which can be parallized. We also suggest values for some init.ora parameters to have a good starting point. SCOPE & APPLICATION ------------------- This note is intended for DBAs who are considering using PX Initialization parameters ------------------------- The following parameters are currently affecting the behavior of Parallel Execution in Oracle: FAST_START_PARALLEL_ROLLBACK [NOTE:68932.1] LARGE_POOL_SIZE [NOTE:47334.1] OPTIMIZER_PERCENT_PARALLEL (Obsolete in 9i) [NOTE:39027.1] PARALLEL_ADAPTIVE_MULTI_USER [NOTE:68594.1] PARALLEL_AUTOMATIC_TUNING [NOTE:68595.1] PARALLEL_BROADCAST_ENABLED [NOTE:68596.1] PARALLEL_EXECUTION_MESSAGE_SIZE [NOTE:68598.1] PARALLEL_MAX_SERVERS [NOTE:30790.1] PARALLEL_MIN_PERCENT [NOTE:39034.1] PARALLEL_MIN_SERVERS [NOTE:30791.1] PARALLEL_THREADS_PER_CPU [NOTE:68604.1] PARALLEL_TRANSACTION_RECOVERY [NOTE:68605.1] RECOVERY_PARALLELISM [NOTE:30795.1] REPLICATION_DEPENDENCY_TRACKING [NOTE:47355.1] SORT_AREA_SIZE [NOTE:30918.1] In a Parallel Server or RAC environment, the behavior of parallel query and PDML is affected by the following parameters also: PARALLEL_INSTANCE_GROUP [NOTE:47351.1] PARALLEL_SERVER_INSTANCES [NOTE:68603.1] Values for PX init.ora Parameter -------------------------------- We would suggest the following for a good starting point with PX. Maybe some parameter have to be tuned after a while. set parallel_automatic_tuning=true unset parallel_max_servers unset parallel_min_servers unset parallel_execution_message_size* maybe set parallel_adaptive_multi_user=false** * Machines with enough memory can afford to have higher values here like 8k and 16k but the performance "knee" is at 8k, so higher values don't give as much benefit. **This parameter defaults to false unless parallel_automatic_tuning = true. Users may want to set it to false if they wish to perform first come first served resource allocation and/or have a queuing mechanism which submits jobs to the db. REFERENCES ----------- Oracle8i Migration Release 3 (8.1.7) Part Number A86632-01 Oracle9i Database Migration Release 2 (9.2) Part No. A96530-02
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-20-2003 09:44 AM
тАО05-20-2003 09:44 AM
Re: Oracle and multiple processor machines.
I will try and get points assigned by close of business, but it depends on the dba.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com