Re: Oracle 10 : big difficulties : bad order in select result

Hello Frank,

The BUG number corresponding is 4333548. You can access it if you have a login on www.metalink.oracle.com.
I give you below the information on the patch to solve the problem. The test case was directly done by Oracle support because we understood nothing on what happenned and it was necessary to know the code behaviour. We do not have the entire test case.

Our main difficulty with ORACLE is that they had such a big problem on such a basic operation as a select. This cost us quite a lot of money and the ORACLE answer was not sufficient, took too much time and as you know ORACLE sofware is not very cheap.

Since this problem i really don't have a good image of ORACLE.

Patch :
#-------------------------------------------------------------------------
# Interim Patch for Base Bugs: 4333548
#-------------------------------------------------------------------------
#
# DATE: Wed Jun 15 09:08:04 2005
# -------------------------------
# Platform Patch for : Solaris Operating System (SPARC 64-bit)
# Product Version # : 10.1.0.4
# Product Patched : RDBMS
#
# Bugs Fixed by this patch:
# -------------------------
# 4333548:WRONG RESULTS FROM SELECT WHICH SOMETIMES USES 10G ROW
SHIPPING
#
# Patch Installation Instructions:
# --------------------------------
# To apply the patch, unzip the PSE container file:
#
# p4333548_10104_SOLARIS64.zip
#
# Set your current directory to the directory where the patch
# is located:
#
# % cd 4333548
#
# Ensure that the directory containing the opatch script appears in
# your $PATH; then enter the following command:
#
# % opatch apply
#
# Patch Special Instructions:

Regards.

Roland. Received on Tue Jul 26 2005 - 03:52:04 CDT