| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Analytic bug in 9.2.0.4
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
With a couple of exceptions, it appears that it is consistently buggy on several platforms.
iTar time I guess.
Thanks,
Jared
"Hrncirik, Debbie" <DHrncirik_at_lexgen.com>
Sent by: ml-errors_at_fatcity.com
12/05/2003 06:29 AM
Please respond to ORACLE-L
=20
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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=5Fnoref: COLFDNF set],=20
[], [], [], [], [], [], []
9.2.0.3, 32-bit. Solaris 8.
Brian
While playing around with SQL for some PGA scripts, I managed to create=20
some
SQL=20
that will consistently cause =A0ORA-600 [kkqwrm=5Fnoref: COLFDNF set]=20
This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3.=20
Here's the SQL:=20
select=20
=A0 =A0 =A0 =A0 pga=5Ftarget=5Ffor=5Festimate=20
=A0 =A0 =A0 =A0 , pga=5Ftarget=5Ffactor=20
=A0 =A0 =A0 =A0 , low=5Foptimal=5Fsize=20
=A0 =A0 =A0 =A0 , high=5Foptimal=5Fsize=20
=A0 =A0 =A0 =A0 , estd=5Foptimal=5Fexecutions=20
=A0 =A0 =A0 =A0 , estd=5Fonepass=5Fexecutions=20
=A0 =A0 =A0 =A0 , estd=5Fmultipasses=5Fexecutions=20
=A0 =A0 =A0 =A0 , estd=5Ftotal=5Fexecutions=20
=A0 =A0 =A0 =A0 , ignored=5Fworkareas=5Fcount=20
from v$pga=5Ftarget=5Fadvice=5Fhistogram=20
where pga=5Ftarget=5Ffor=5Festimate in (=20
=A0 =A0 =A0 =A0 select =A0pga=5Ftarget=5Ffor=5Festimate=20
=A0 =A0 =A0 =A0 from (=20
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 select=20
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 max(pga=5Ftarget=5Ffor=5Fes=
timate) over ( partition by
pga=5Ftarget=5Ffor=5Festimate) pga=5Ftarget=5Ffor=5Festimate=20
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 , sum(estd=5Fmultipasses=5F=
executions) over (=20
partition
by pga=5Ftarget=5Ffor=5Festimate) sum=5Festd=5Fmultipasses=20
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 , max(high=5Foptimal=5Fsize=
) over ( partition by
pga=5Ftarget=5Ffor=5Festimate) max=5Fhigh=5Foptimal=5Fsize=20=A0 =A0 =A0 =A0 where sum=5Festd=5Fmultipasses < 1=20
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 from v$pga=5Ftarget=5Fadvice=5Fhistogram=20
=A0 =A0 =A0 =A0 ) a=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 =A0Kernel 2.4.20-18.7smp=20
It also appears on 9.2.0.4 on Win2k SP3.=20
Anyone else see similar results? =A0On 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 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).
***************************************************************************=
The contents of this communication are intended only for the addressee=20
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=20
by
it.=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 ---------------------------------------------------------------------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).
--=_alternative 0058635A88256DF3_=
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<br><font size=3D2 face=3D"sans-serif">With a couple of exceptions, it appe= ars that it is consistently</font>
<br><font size=3D2 face=3D"sans-serif">buggy on several platforms.</font> <br> <br><font size=3D2 face=3D"sans-serif">iTar time I guess.</font> <br> <br><font size=3D2 face=3D"sans-serif">Thanks,</font> <br> <br><font size=3D2 face=3D"sans-serif">Jared</font> <br><font size=3D2 face=3D"sans-serif"><br> </font> <br> <br> <br> <table width=3D100%> <tr valign=3Dtop> <td> <td><font size=3D1 face=3D"sans-serif"><b>"Hrncirik, Debbie" <=DHrncirik_at_lexgen.com></b></font>
<br><font size=3D1 face=3D"sans-serif">Sent by: ml-errors_at_fatcity.com</font> <p><font size=3D1 face=3D"sans-serif"> 12/05/2003 06:29 AM</font> <br><font size=3D2 face=3D"sans-serif"> </font><font size=3D1 face=3D"=sans-serif">Please respond to ORACLE-L</font>
<br> <td><font size=3D1 face=3D"Arial"> </font> <br><font size=3D1 face=3D"sans-serif"> To: &nbs=p; Multiple recipients of list ORACLE-L <ORACLE-L_at_fa= tcity.com></font>
<br> <br> <br><font size=3D2 face=3D"Courier New">It works fine for me - 9.2.0.3, 64-=bit, Solaris 9<br>
---------------------------------<br>
---------------------------------<br>
<br> <br> <br>
<br> <br> <br> <br> <br>
---------------------------------------------------------------------<br>To REMOVE yourself from this mailing list, send an E-Mail message<br> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<br> the message BODY, include a line containing: UNSUB ORACLE-L<br> (or the name of mailing list you want to be removed from). You may<br> also send the HELP command for other information (like subscribing).<br> <br>
***************************************************************************=<br>
***************************************************************************=<br>
---------------------------------------------------------------------<br>To REMOVE yourself from this mailing list, send an E-Mail message<br> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<br> the message BODY, include a line containing: UNSUB ORACLE-L<br> (or the name of mailing list you want to be removed from). You may<br> also send the HELP command for other information (like subscribing).<br>
</font> <br> <br>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still_at_radisys.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 Fri Dec 05 2003 - 10:09:27 CST
 |
 |