# Axapta and Oracle Parallel Query Execution

**URL:** <https://www.dynamicsuser.net/t/axapta-and-oracle-parallel-query-execution/14852>\
**Category:** Technical Forum\
**Created:** [September 27, 2005, 9:44am UTC](https://www.dynamicsuser.net/t/axapta-and-oracle-parallel-query-execution/14852 "2005-09-27T09:44:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Helmut\_Wimmer](https://avatars.discourse-cdn.com/v4/letter/h/2acd7d/32.png) [@Helmut\_Wimmer](https://www.dynamicsuser.net/u/Helmut_Wimmer)\
**Post date:** [September 27, 2005, 9:44am UTC](https://www.dynamicsuser.net/t/axapta-and-oracle-parallel-query-execution/14852/1 "2005-09-27T09:44:53Z")

</div>

Hi! We are using Axapta 3.0SP3 on an Oracle 9.2.0.4. The DB server is a dual Xeon 3.2 Ghz (so I see 4 CPU threads in task manager). Now, from time to time one of the CPU threads goes up to almost 100% and the others are still at 1-2 %. So it seems to me that Oracle does not spread it’s CPU load to more CPU’s (at least for one process). I have found that on Oracle, you have to activate the “Parallel” option on each table. Question now: has anybody of you made that? Is it advisable to activate it when using Axapta? Any thoughts on it?
