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