Using Oracle Parallel hint [message #666133] |
Tue, 17 October 2017 05:37 |
martjosh
Messages: 13 Registered: December 2009 Location: Riyadh
|
Junior Member |
|
|
Hi guys - I just want to ask if anyone encounter this issue while using parallel hint.
I have created two version of the procedure, one procedure without the parallel hint and the other is using parallel. I'm wondering why the output is not the same.
is this a database issue?. need you advise. Thank you.
|
|
|
|
|
Re: Using Oracle Parallel hint [message #666143 is a reply to message #666141] |
Tue, 17 October 2017 08:07 |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Some possibilities:
the code differs in more ways than the hint
you're running them against different data sets
the data changes between runs
the output is the same but in a different order
there's an oracle bug
|
|
|
|
|
Re: Using Oracle Parallel hint [message #666256 is a reply to message #666147] |
Tue, 24 October 2017 03:24 |
martjosh
Messages: 13 Registered: December 2009 Location: Riyadh
|
Junior Member |
|
|
joy_division wrote on Tue, 17 October 2017 12:28What do you mean by output? Procedures do not produce output.
Procedure has an output(specifically in the table). I think what you mean is no return value.
Anyway this issues has been resolve by our DBA. He did some patching. Sorry if I forgot to post my sample.
Example.
update /*+ parallel (4) */ test_table
where column1 = column2 + column1
;
commit;
|
|
|
|
Re: Using Oracle Parallel hint [message #666260 is a reply to message #666256] |
Tue, 24 October 2017 07:59 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
martjosh wrote on Tue, 24 October 2017 04:24joy_division wrote on Tue, 17 October 2017 12:28What do you mean by output? Procedures do not produce output.
Procedure has an output(specifically in the table). I think what you mean is no return value.
No, a procedure does not produce output. A procedure runs on the database side, not the client side, therefore it cannot produce output.
updating a table is not output.
Not really a good example of an UPDATE either, as the syntax is incorrect.
[Updated on: Tue, 24 October 2017 08:00] Report message to a moderator
|
|
|
Re: Using Oracle Parallel hint [message #666261 is a reply to message #666260] |
Tue, 24 October 2017 08:07 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>where column1 = column2 + column1
above will only be TRUE when COLUMN2=0
>update /*+ parallel (4) */ test_table where column1 = column2 + column1
UPDATE above is useless since no values in any row are ever changed.
|
|
|