RE: ora-600 question

What version of TOAD, Oracle server and Oracle client? See Metalink article 34779.1 for details on your bug, which may be fixed in releases 8.1.7.3, 9.0.1.2 and 9.2.0.1.

BTW, TOAD can put in hints, but more importantly, it can do some conversion/translation of your SQL before sending it. You may want to checkout the official TOAD list at http://groups.yahoo.com/group/toad

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: ryan_oracle_at_cox.net [mailto:ryan_oracle_at_cox.net]
> Sent: Tuesday, October 28, 2003 1:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ora-600 question
>
>
> does toad or the oracle instance itself slip in rule hints?
> We got an ora-600 error off of a data dictionary read. i
> think it has to do with explain plan.
>
> ORA-00600: internal error code, arguments: [17182],
> [2325084336], [], [], [], [], [], []
> Current SQL statement for this session:
> select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt,
> timestamp#, sample_size, minimum, maximum, distcnt, lowval, hiva
> l, density, col#, spare1, spare2, avgcln from hist_head$
> where obj#=:1 and intcol#=:2
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).