RE: Analytic bug in 9.2.0.4

From: <Trevor.Williams_at_rac.com.au>
Date: Thu, 04 Dec 2003 17:14:25 -0800
Message-ID: <F001.005D8D13.20031204171425@fatcity.com>

ERROR at line 11:
ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [], [], []
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production HP-UX ariadne B.11.00 U 9000/800

-----Original Message-----
Sent: Friday, 5 December 2003 8:29 am
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

Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Trevor.Williams_at_rac.com.au

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 Dec 04 2003 - 19:14:25 CST