RE: Analytic bug in 9.2.0.4
ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [], [], [] on 9.2.0.4 64 bit; Solaris 2.8 mvg/regards Jo Prem Khanna J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 03:14 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analytic bug in 9.2.0.4 You are right Jared. ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [],[], [] this is on oracle 9.2.0.3 Win2k+SP3. Regards, Jp. -Original Message- 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. 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: Prem Khanna J 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
Re: Analytic bug in 9.2.0.4
Fixed in 10. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 12:29 AM 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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).
RE: Analytic bug in 9.2.0.4
works on 9202 but that's not what you wanted to hear ... right? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, December 04, 2003 7:29 PMTo: Multiple recipients of list ORACLE-LSubject: Analytic bug in 9.2.0.4While 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 **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
RE: Analytic bug in 9.2.0.4
The same thing occurs on OpenVMS on version 9.2.0.4 of Oracle. Nelson -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, December 04, 2003 7:29 PMTo: Multiple recipients of list ORACLE-LSubject: Analytic bug in 9.2.0.4While 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
Re: Analytic bug in 9.2.0.4
Do you know when will this fabulous version 10 be available for download? On 12/05/2003 04:14:34 AM, Jonathan Lewis wrote: Fixed in 10. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 12:29 AM 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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).
RE: Analytic bug in 9.2.0.4
It wasnt 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).
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:[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).
RE: Analytic bug in 9.2.0.4
too funny. It was 'fixed' in 9203. According to Jonathan, it has actually been fixed in 10. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 04:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analytic bug in 9.2.0.4 works on 9202 but that's not what you wanted to hear ... right? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 7:29 PM To: Multiple recipients of list ORACLE-L Subject: Analytic bug in 9.2.0.4 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 ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4
RE: Analytic bug in 9.2.0.4
With a couple of exceptions, it appears that it is consistently buggy on several platforms. iTar time I guess. Thanks, Jared Hrncirik, Debbie [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 06:29 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: 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:[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).
RE: Analytic bug in 9.2.0.4
Title: Message Just to add to the list Tru64/Trucluster 5.1b - 9.2.0.4 rac from v$pga_target_advice_histogram *ERROR at line 11:ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [],[], [], [], [], [] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 8:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Analytic bug in 9.2.0.4With a couple of exceptions, it appears that it is consistently buggy on several platforms. iTar time I guess. Thanks, Jared "Hrncirik, Debbie" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 06:29 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analytic bug in 9.2.0.4It works fine for me - 9.2.0.3, 64-bit, Solaris 9-Debbie-Original Message-Brian McGrawSent: Friday, December 05, 2003 8:09 AMTo: Multiple recipients of list ORACLE-LIt 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 PMTo: Multiple recipients of list ORACLE-LWhile playing around with SQL for some PGA scripts, I managed to create someSQL 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 bypga_target_for_estimate) pga_target_for_estimate , sum(estd_multipasses_executions) over ( partitionby pga_target_for_estimate) sum_estd_multipasses , max(high_optimal_size) over ( partition bypga_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 thancausing 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 McGrawINET: [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 messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).*** The contents of this communication are intended only for the addressee andmay contain confidential and/or privileged material. If you are not theintended recipient, please do not read, copy, use or disclose thiscommunication and notify the sender. Opinions, conclusions and otherinformation in this communication that do not relate to the officialbusiness of my company shall be understood as neither given nor endorsed byit. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Hrncirik, DebbieINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Analytic bug in 9.2.0.4
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
RE: Analytic bug in 9.2.0.4
You are right Jared. ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [],[], [] this is on oracle 9.2.0.3 Win2k+SP3. Regards, Jp. -Original Message- 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. 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: Prem Khanna J 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).