RE: Analytic bug in 9.2.0.4

From: Browett, Darren <dbrowett_at_coquitlam.ca>
Date: Fri, 05 Dec 2003 10:04:26 -0800
Message-ID: <F001.005D8F19.20031205100426@fatcity.com>

Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Just to add to the list
=20
Tru64/Trucluster 5.1b - 9.2.0.4 rac
=20
from v$pga_target_advice_histogram

*
ERROR at line 11:
ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [],
[], [], [], [], []
=20
=20

-----Original Message-----
Sent: Friday, December 05, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L

With a couple of exceptions, it appears that it is consistently=20 buggy on several platforms.=20

iTar time I guess.=20

Thanks,=20

Jared=20

"Hrncirik, Debbie" <DHrncirik_at_lexgen.com>=20 Sent by: ml-errors_at_fatcity.com=20

12/05/2003 06:29 AM=20
Please respond to ORACLE-L=20

       =20
        To:        Multiple recipients of list ORACLE-L


<ORACLE-L_at_fatcity.com>=20

        cc:        =20
        Subject:        RE: Analytic bug in 9.2.0.4

It works fine for me - 9.2.0.3, 64-bit, Solaris 9

-Debbie

-----Original Message-----
Brian McGraw
Sent: Friday, December 05, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L

It wasn't fixed in my version of 9.2.0.3:

ERROR at line 11:
ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set],

[],
[],
[], [], [], [], []

9.2.0.3, 32-bit. Solaris 8.

Brian

| Brian McGraw -+- Senior DBA |
| mailto:Brian.McGraw_at_ipacc.com |

-----Original Message-----
Jared.Still_at_radisys.com
Sent: Thursday, December 04, 2003 6:29 PM To: Multiple recipients of list ORACLE-L

While playing around with SQL for some PGA scripts, I managed to create some
SQL=20
that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set]=20

This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3.

Here's the SQL:=20

select=20

        pga_target_for_estimate=20
        , pga_target_factor=20
        , low_optimal_size=20
        , high_optimal_size=20
        , estd_optimal_executions=20
        , estd_onepass_executions=20
        , estd_multipasses_executions=20
        , estd_total_executions=20
        , ignored_workareas_count=20

from v$pga_target_advice_histogram=20
where pga_target_for_estimate in (=20

        select  pga_target_for_estimate=20
        from (=20
                select=20
                        max(pga_target_for_estimate) over ( partition by
pga_target_for_estimate) pga_target_for_estimate=20
                        , sum(estd_multipasses_executions) over (

partition
by pga_target_for_estimate) sum_estd_multipasses=20

                        , max(high_optimal_size) over ( partition by
pga_target_for_estimate) max_high_optimal_size=20
                from v$pga_target_advice_histogram=20
        ) a=20
        where sum_estd_multipasses < 1=20
        group by pga_target_for_estimate, sum_estd_multipasses=20

)=20
order by pga_target_for_estimate, low_optimal_size=20 /=20

This bit of SQL is a bit useless as is, that is, for anything other than causing ORA-600.=20

This is on 9.3.0.4 on RH Linux 7.2 Kernel 2.4.20-18.7smp=20

It also appears on 9.2.0.4 on Win2k SP3.=20

Anyone else see similar results? On a test database of course.=20

Jared=20

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20
Author: Brian McGraw
INET: brian.mcgraw_at_ipacc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com=20
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).

***=20
The contents of this communication are intended only for the addressee and
may contain confidential and/or privileged material. If you are not the intended recipient, please do not read, copy, use or disclose this communication and notify the sender. Opinions, conclusions and other information in this communication that do not relate to the official business of my company shall be understood as neither given nor endorsed by
it. =20

***=20

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20
Author: Hrncirik, Debbie
INET: DHrncirik_at_lexgen.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

------_=_NextPart_001_01C3BB59.DC3FDF76
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>

<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR></HEAD>
<BODY>
<DIV>Just=20
to add to the list</DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2>Tru64/Trucluster 5.1b -  9.2.0.4 rac</DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2> </DIV>
<DIV>from=20
v$pga_target_advice_histogram      * ERROR at = line=20
11: ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF = set],=20
[], [], [], [], [], [], []</DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2> </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
 <DIV></DIV>
 <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr = align=3Dleft><FONT=20
 face=3DTahoma size=3D2>-----Original Message----- From:=20 Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com] =
 Sent:=20

 Friday, December 05, 2003 8:09 AM To: Multiple recipients of = list=20
 ORACLE-L Subject: RE: Analytic bug in=20 9.2.0.4 </DIV> With = a couple of=20
 exceptions, it appears that it is consistently <FONT=20 face=3Dsans-serif size=3D2>buggy on several platforms. =
 <FONT=20

 face=3Dsans-serif size=3D2>iTar time I guess. Thanks, Jared=20
 <TABLE width=3D"100%">
 <TBODY>
 <TR vAlign=3Dtop>

      <TD>
      <TD><FONT face=3Dsans-serif size=3D1><B>"Hrncirik, Debbie"=20
        &lt;DHrncirik_at_lexgen.com&gt;</B></FONT> <BR><FONT =
face=3Dsans-serif=20
        size=3D1>Sent by: ml-errors_at_fatcity.com</FONT>=20
        <P><FONT face=3Dsans-serif size=3D1>&nbsp;12/05/2003 06:29 =
AM</FONT>=20
        <BR><FONT face=3Dsans-serif size=3D2>&nbsp;</FONT><FONT =
face=3Dsans-serif=20
        size=3D1>Please respond to ORACLE-L</FONT> <BR></P>
      <TD><FONT face=3DArial size=3D1>&nbsp; &nbsp; &nbsp; &nbsp; =


</FONT><BR><FONT=20

        face=3Dsans-serif size=3D1>&nbsp; &nbsp; &nbsp; &nbsp; To: =
&nbsp; &nbsp;=20
        &nbsp; &nbsp;Multiple recipients of list ORACLE-L=20
        &lt;ORACLE-L_at_fatcity.com&gt;</FONT> <BR><FONT face=3Dsans-serif=20
        size=3D1>&nbsp; &nbsp; &nbsp; &nbsp; cc: &nbsp; &nbsp; &nbsp;=20
        &nbsp;</FONT> <BR><FONT face=3Dsans-serif size=3D1>&nbsp; &nbsp; =
&nbsp;=20
        &nbsp; Subject: &nbsp; &nbsp; &nbsp; &nbsp;RE: Analytic bug in=20
        9.2.0.4</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT =

face=3D"Courier New"=20
 size=3D2>It works fine for me - 9.2.0.3, 64-bit, Solaris=20 9 -Debbie -----Original Message----- Brian = McGraw Sent:=20
 Friday, December 05, 2003 8:09 AM To: Multiple recipients of list=20 ORACLE-L It wasn't fixed in my version of = 9.2.0.3: ERROR at=20
 line 11: ORA-00600: internal error code, arguments: [kkqwrm_noref: = COLFDNF=20
 set], [], [], [], [], [], [], [] 9.2.0.3, 32-bit. =  Solaris=20

  8.<BR><BR>Brian<BR><BR>---------------------------------<BR>| Brian=20

McGraw  -+-  Senior DBA | | mailto:Brian.McGraw_at_ipacc.com =

  |<BR>---------------------------------<BR>-----Original=20

Message----- Jared.Still_at_radisys.com Sent: Thursday, December = 04, 2003=20
 6:29 PM To: Multiple recipients of list = ORACLE-L While=20
 playing around with SQL for some PGA scripts, I managed to create = some SQL=20
 that will consistently cause  ORA-600 [kkqwrm_noref: COLFDNF = set]=20
 This appears to be Bug # 2507421, which was supposedly fixed = in=20
 9.2.0.3. Here's the SQL: select     =  =20
   pga_target_for_estimate         ,=20 pga_target_factor         , low_optimal_size=20         , high_optimal_size     =  =20
   , estd_optimal_executions         ,=20

  estd_onepass_executions <BR>&nbsp; &nbsp; &nbsp; &nbsp; ,=20
  estd_multipasses_executions <BR>&nbsp; &nbsp; &nbsp; &nbsp; ,=20
  estd_total_executions <BR>&nbsp; &nbsp; &nbsp; &nbsp; ,=20

ignored_workareas_count from v$pga_target_advice_histogram =
 where=20

 pga_target_for_estimate in (         select=20  pga_target_for_estimate         from (=20                 select =
  =20

                     =  =20

  max(pga_target_for_estimate) over ( partition =
by<BR>pga_target_for_estimate)=20
  pga_target_for_estimate <BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =

=20
           , sum(estd_multipasses_executions) = over (=20
 partition by pga_target_for_estimate) sum_estd_multipasses =
  =20

                     =   ,=20
 max(high_optimal_size) over ( partition by pga_target_for_estimate) =

max_high_optimal_size             =  =20
   from v$pga_target_advice_histogram       =   ) a=20
         where sum_estd_multipasses < 1 =
  =20

       group by pga_target_for_estimate, = sum_estd_multipasses=20
 ) order by pga_target_for_estimate, low_optimal_size /=20 This bit of SQL is a bit useless as is, that is, for anything = other=20
 than causing ORA-600. This is on 9.3.0.4 on RH Linux 7.2=20  Kernel 2.4.20-18.7smp It also appears on 9.2.0.4 on = Win2k SP3.=20
 Anyone else see similar results?  On a test database of = course.=20
 Jared -- Please see the = official=20
 ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian=20 McGraw  INET: brian.mcgraw_at_ipacc.com Fat City Network = Services=20
    -- 858-538-5051 http://www.fatcity.com <FONT=20 face=3D"Courier New" size=3D2>San Diego, California     =    --=20
 Mailing list and web hosting=20
 =

services<BR>-------------------------------------------------------------=

-------- To=20
 REMOVE yourself from this mailing list, send an E-Mail message to:=20 ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the = message=20
 BODY, include a line containing: UNSUB ORACLE-L (or the name of = mailing=20
 list you want to be removed from).  You may also send the HELP = command=20
 for other information (like=20
 =

subscribing).<BR><BR><BR>************************************************=
***************************=20

The contents of this communication are intended only for the = addressee=20
 and may contain confidential and/or privileged material. If you are = not=20
 the intended recipient, please do not read, copy, use or disclose=20 this communication and notify the sender.  Opinions, = conclusions and=20
 other information in this communication that do not relate to the=20 official business of my company shall be understood as neither = given nor=20
 endorsed by it.=20
 =

&nbsp;<BR>***************************************************************=

************=20
 -- Please see the official ORACLE-L FAQ:=20 http://www.orafaq.net -- Author: Hrncirik, = Debbie  INET:=20
 DHrncirik_at_lexgen.com Fat City Network Services    --=20 858-538-5051 http://www.fatcity.com San Diego, California   =  =20
    -- Mailing list and web hosting=20 =

services<BR>-------------------------------------------------------------=

------_=_NextPart_001_01C3BB59.DC3FDF76--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Browett, Darren
  INET: dbrowett_at_coquitlam.ca

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 Fri Dec 05 2003 - 12:04:26 CST