The bug number is 2398050. You can read about it in metalink alongwith the workaround. It is fixed in 9i. But the problem is that even workaround does not work for me. I am working with oracle support on this.
Meanwhile I have resolved my basic problem with AQ for which I was trying all this by deleting the statistics for that particular table and I am never going to analyze that table again. Thanks Shaleen ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, December 13, 2002 12:14 PM > John, > > Shaleen mentioned to me, in a direct e-mail, that there was a bug in 8i and there was some workaround available. I do not have the bug number. > > - Kirti > > -----Original Message----- > Sent: Friday, December 13, 2002 10:49 AM > To: Multiple recipients of list ORACLE-L > > > Shaleen/Kirti, > > If this is version dependent, then Oracle will brand this a 'feature' rather > than a bug. And I think I know why this is happening.... As per the Concepts > manual, "When you create a stored procedure, Oracle parses the procedure and > stores its parsed representation in the database." I assume that when this > SP is called, the SQL segment is reconstructed by the kernel and it looses > its formatting during this reconstruction, thus creating a different > signature/hash area. 9iR2 may be reconstructing this properly while 8i may > not (as it was the first release for Outlines). > > I hope this make sense! Anyone willing to look at and compare the structures > of IDL_UB1$ and IDL_UB2$ and IDL_SB4$ tables (SYS) between the two versions. > (Don't have my hands on 9iR2 yet - I am way behind the times here :( > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > So WHO is the Reason for the Season?! Write me for details! > > ** The opinions and statements above are entirely my own and not those of my > employer or clients ** > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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.com -- Author: Shaleen Garg INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
