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: Analytic bug in 9.2.0.4

RE: Analytic bug in 9.2.0.4

From: Hrncirik, Debbie <DHrncirik_at_lexgen.com>
Date: Fri, 05 Dec 2003 06:29:25 -0800
Message-ID: <F001.005D8EF8.20031205062925@fatcity.com>


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
that will consistently cause  ORA-600 [kkqwrm_noref: COLFDNF set]

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

Here's the SQL:

select
        pga_target_for_estimate
        , pga_target_factor
        , low_optimal_size
        , high_optimal_size
        , estd_optimal_executions
        , estd_onepass_executions
        , estd_multipasses_executions
        , estd_total_executions
        , ignored_workareas_count

from v$pga_target_advice_histogram
where pga_target_for_estimate in (
        select  pga_target_for_estimate
        from (
                select
                        max(pga_target_for_estimate) over ( partition by
pga_target_for_estimate) pga_target_for_estimate
                        , sum(estd_multipasses_executions) over ( partition
by pga_target_for_estimate) sum_estd_multipasses
                        , max(high_optimal_size) over ( partition by
pga_target_for_estimate) max_high_optimal_size
                from v$pga_target_advice_histogram
        ) a
        where sum_estd_multipasses < 1
        group by pga_target_for_estimate, sum_estd_multipasses
)
order by pga_target_for_estimate, low_optimal_size /

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

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

It also appears on 9.2.0.4 on Win2k SP3.

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

Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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 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.  
*************************************************************************** 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
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).
Received on Fri Dec 05 2003 - 08:29:25 CST

Original text of this message

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