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 [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > 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: [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).
