| 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
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
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
 |
 |