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

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?

Regards,

Alina
Re: parallel execution [message #186109 is a reply to message #184317] Sat, 05 August 2006 21:06 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
http://www.ucs.louisiana.edu/~oracle9i/server.901/a88856/c20paral.htm#22669
Previous Topic: Looking for optimizations for Oracle DB
Next Topic: Indexing question
Goto Forum:
  


Current Time: Tue Dec 06 04:45:54 CST 2016

Total time taken to generate the page: 0.18033 seconds