How do I make OraQuery use multi-core or multi-processor system?

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
lior
Posts: 36
Joined: Mon 01 Aug 2011 07:11

How do I make OraQuery use multi-core or multi-processor system?

Post by lior » Thu 16 Aug 2012 10:02

What properties or methods should I set in order to get OraQuery to use multi-core or multi-processor system?
Also can you advise me of Oracle 11G settings that I should change for that purpose?
Thaks in advance

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: How do I make OraQuery use multi-core or multi-processor system?

Post by AlexP » Thu 16 Aug 2012 11:45

Hello,

By default, the system automatically distributes the load on all processors if any processor was not specified explicitly in the application with the help of the SetThreadIdealProcessor method. For more detailed information on the load management and using the multiprocessing you need to look at the help on such methods as SetProcessAffinityMask, SetThreadAffinitymask, SetThreadIdealProcessor.
For setting the load distribution on processors in Oracle server, you should contact the Oracle developers

Post Reply