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:[EMAIL PROTECTED] | --------------------------------- -----Original Message----- [EMAIL PROTECTED] 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: [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). *************************************************************************** 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: [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).
