Home » RDBMS Server » Performance Tuning » parallel execution
parallel execution [message #184317] Wed, 26 July 2006 02:30 Go to next message
Messages: 45
Registered: November 2005
Location: India

I’m using Oracle10G REL 2 on Solaris10 and having Processor: 400MHZ, 4CPU Memory : 4GB. I wanted to know when we execute a SQL query, does oracle perform parallel execution by default or do I need to enable it session/ system level or do I need to use hint in SQL query? How do I monitor whether parallel execution is happening or not and it’s impact on performance ? Does Oracle recommend parallel execution using hint if having more than one CPU?


Re: parallel execution [message #186109 is a reply to message #184317] Sat, 05 August 2006 21:06 Go to previous message
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Previous Topic: Looking for optimizations for Oracle DB
Next Topic: Indexing question
Goto Forum:

Current Time: Sat Oct 22 13:33:24 CDT 2016

Total time taken to generate the page: 0.07837 seconds