-
parallel execution..
hi all,
Can anyone answer the following.
How can we execute a SQL statement parallely . which server it requires ?(Dedicated/Shared/Parallel).
Thanx in adv
Prasad
-
funky...
"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"
-
which server it requires ?(Dedicated/Shared/Parallel).
Ahn...? what about:
SELECT /*+ PARALLEL(table_name,parallel_processes) */ .... ?
An ounce of action is worth a ton of theory.
—Friedrich Engels
-
You need to read the concepts guide -- it has a section on how parallel query works, and it's nothing to do with dedicated or shared server.
-
Originally posted by adrianomp
SELECT /*+ PARALLEL(table_name,parallel_processes) */ .... ?
Just by giving hints, query is not subject to be processed parallely.
there are many other things one might have to consider.
funky...
"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"
-
abyhaysk,
You're right. There are considerations about PARALLEL_MAX_SERVERS, PARALLEL_MIN_SERVERS, number of cpu's, access plan etc.
I was pretty laconic (and lazy) because, as slimdave mentioned, there is no direct relation between parallel query and dedicated/shared server/OPS, I didn't understand what exactly he meant.
Anyway, the docs pointed by you and slimdave have all the stuff.
An ounce of action is worth a ton of theory.
—Friedrich Engels
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|