Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Wrong results. 10053 event help

RE: Wrong results. 10053 event help

From: Mandar A. Ghosalkar <mghosalk_at_byer.com>
Date: Thu, 17 Apr 2003 16:31:43 -0800
Message-ID: <F001.00584785.20030417163143@fatcity.com>


I am using cursor_sharing=exact.
Well after bringing the database upto 8.1.7.4.10 the problem has gone.

> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
> Sent: Thursday, April 17, 2003 2:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Wrong results. 10053 event help
>
>
> Are you using CURSOR_SHARING=FORCE? There's a bug fixed in
> 8.1.7.3 or 8.1.7.4 just like this if this is the case. The
> workaround is to set CURSOR_SHARING=EXACT for the query in
> question. The solution is to patch.
>
>
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
>
>
> -----Original Message-----
> Sent: Thursday, April 17, 2003 2:47 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Well I am very lucky today.
>
> After cloning a 8.1.7 db I found a query would return diff
> results with and without cbo or by changing the sequence of
> expr in the where clause. Can anyone help me understand the
> 10053 trace output before apply 8.1.7.4 patch and remove this bug.
>
> Case 1: with cbo and all analyzed, return zero rows. Wrong
> Result. SELECT "USER_OR_TEAM_ID",
> "ID_TYPE",
> "ITEM_TYPE",
> "ITEM1_ID",
> "ITEM2_ID",
> "ITEM3_ID",
> "ITEM4_ID",
> "ITEM5_ID",
> "ITEM6_ID",
> "PRV",
> "GRANT_DENY_FLAG"
> FROM acl
> WHERE (
> (id_type = 1 AND user_or_team_id IN (SELECT user_id FROM
> my_user_id))
> or
> (id_type = 2 AND user_or_team_id IN (SELECT team_id FROM
> my_team))
> )
>
> [snipped for brevity]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mandar A. Ghosalkar
  INET: mghosalk_at_byer.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Apr 17 2003 - 19:31:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US