I have server on which oracle 10g single instance running. It has got 4 processors available, but while monitoring only 1 processor fully utilised and the rest 3 is used very less. How to enable all the 4 processors to be evenly utilised and increase the performance ? The OS is win2k.
any help will be greatly appreciated.
Get rid of WinDoze and install LInux.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Don't be more Ellisonian than Ellison, Oracle is fully supporting Microsoft Windows deployments.
Originally Posted by LKBrwn_DBA
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
By enabling parallel process will sort out this issue?
maybe, but parallel processing isnt necesarilly a good thing
parallel process wont start using different CPU's necessarily.. single CPU can handle multiple threads..
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
How did you identify that your CPU's are not being used and only one is being used by oracle.
Click Here to Expand Forum to Full Width