Home » Server Options » RAC & Failsafe » Parallel Query
Parallel Query [message #74801] Sun, 17 February 2002 23:42 Go to next message
Messages: 2
Registered: February 2002
Junior Member

Is it possible to make a query to run in a parellel mode just by setting the int.ora parameters.
with out giving hints in the sql query?

The scenario is 'We dont have the access to the source code of the product. But we want to make the query to run in a parellel mode' I am using oracle 8.1.7

Any help on this will be appreciated...

Re: Parallel Query [message #74802 is a reply to message #74801] Mon, 18 February 2002 21:05 Go to previous messageGo to next message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member

Please read the Oracle Parallel Query FAQ at http://www.orafaq.net/faqopq.htm:

Parallel Queries can be performed against tables by doing one of the following:

1. Alter the table (or index) to indicate that Oracle should try to parallelise operations performed against it:


2. Put hints in SQL statements to indicate that Oracle should try to execute them in parallel:

SQL> SELECT --+ PARALLEL(table_alias, degree, nodes) * FROM table ...

Best regards.

Frank Naude
Re: Parallel Query [message #74810 is a reply to message #74801] Tue, 16 April 2002 06:59 Go to previous message
Michael Pritzkow
Messages: 3
Registered: April 2002
Junior Member
To execute a query in parallel it is also nessesary that the data is organised in a parallel fashion, i.e. in a partitioned table and/or index.

With the init.ora parameter parallel_min_percent you can force the optimizer to favor parallel execution over standard rule based execution. But still the optimizer might decide that the query cannot be executed parallelly.
Previous Topic: Re: Oracle Parallel Server
Next Topic: oracle is......
Goto Forum:

Current Time: Sun Feb 25 10:06:16 CST 2024