Home » SQL & PL/SQL » SQL & PL/SQL » WIn XP, Oracle 10g (Parallel Hint : Different results)
WIn XP, Oracle 10g [message #388753] Thu, 26 February 2009 01:36 Go to next message
Messages: 74
Registered: November 2007
Location: mumbai
Hi all..

I came across some wiered scenario this morning...
My query result set got changed only using Parallel hint...no other hints and changes..

Is it ever possible?


Re: WIn XP, Oracle 10g [message #388755 is a reply to message #388753] Thu, 26 February 2009 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without more precision not even an Oracle version the only we can say is: search on Metalink if there is any bug for you.

Re: WIn XP, Oracle 10g [message #388762 is a reply to message #388753] Thu, 26 February 2009 02:21 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If your result set changes reproducibly when you add a hint, then it's almost certainly a bug.

If it's not reproducible, then have you considered that the data you are looking at might have changed?
Previous Topic: Base64 String to Image
Next Topic: Trigger for enforcing referential integrity
Goto Forum:

Current Time: Fri Aug 18 04:03:52 CDT 2017

Total time taken to generate the page: 0.13708 seconds