Home » SQL & PL/SQL » SQL & PL/SQL » Using Oracle Parallel hint
Using Oracle Parallel hint [message #666133] Tue, 17 October 2017 05:37 Go to next message
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 #666140 is a reply to message #666133] Tue, 17 October 2017 07:03 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
No-one can explain what you are doing wrong unless you show the code and the result.
Re: Using Oracle Parallel hint [message #666141 is a reply to message #666133] Tue, 17 October 2017 07:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

When you see different results, then you can rest assured that something is different.

We can say what is wrong since you did not actually post what you did or how Oracle responded.
Re: Using Oracle Parallel hint [message #666143 is a reply to message #666141] Tue, 17 October 2017 08:07 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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 #666147 is a reply to message #666133] Tue, 17 October 2017 12:28 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
What do you mean by output? Procedures do not produce output.
Re: Using Oracle Parallel hint [message #666159 is a reply to message #666147] Tue, 17 October 2017 14:46 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
martjosh,
I'm curious how we are supposed to help us when you don't paste your code into this issue. It is really hard to trouble shoot "It is broken"
Re: Using Oracle Parallel hint [message #666256 is a reply to message #666147] Tue, 24 October 2017 03:24 Go to previous messageGo to next message
martjosh
Messages: 13
Registered: December 2009
Location: Riyadh
Junior Member
joy_division wrote on Tue, 17 October 2017 12:28
What 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 #666257 is a reply to message #666256] Tue, 24 October 2017 03:36 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
That still does nothing to explain in what way the output was different.
Re: Using Oracle Parallel hint [message #666260 is a reply to message #666256] Tue, 24 October 2017 07:59 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
martjosh wrote on Tue, 24 October 2017 04:24
joy_division wrote on Tue, 17 October 2017 12:28
What 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 Go to previous message
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.
Previous Topic: Changing the date format on a specific field
Next Topic: SQL help on hierarchy data
Goto Forum:
  


Current Time: Thu Mar 28 09:03:13 CDT 2024