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 /*+
TOAD puts a hint in.
[EMAIL PROTECTED] 10/28/2003 1:29:25 PM
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],
[], [],
]
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
ORACLE-L
does the data dictionary still use rule by support? any idea why toad would
bother slipping it in?
From: John Shaw [EMAIL PROTECTED]
Date: 2003/10/28 Tue PM 02:59:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: ora-600 question
TOAD puts a hint
rule by support? any idea why toad would
bother slipping it in? From: "John Shaw"
[EMAIL PROTECTED] Date: 2003/10/28 Tue PM 02:59:25
EST To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] Subject: Re: ora-600 question
TOAD puts a hint in.[EMAIL PROTECTED]
10/28/2003
does the data dictionary still use rule by support? any idea why toad would bother
slipping it in?
From: John Shaw [EMAIL PROTECTED]
Date: 2003/10/28 Tue PM 02:59:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: ora-600 question
TOAD puts a hint
/10/28 Tue PM 02:59:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: ora-600 question
TOAD puts a hint in.
[EMAIL PROTECTED] 10/28/2003 1:29:25 PM
does toad or the oracle instance itself slip in rule hints? We got an
ora-600 error off of a data dictionary
If there're already hints like ordered and use_nl that tell Oracle how to join,
lack of statistics is less of a problem. In fact, you may need to use those two
hints in some queries against data dictionary even in pre-9i Oracle.
Yong Huang
--- Tanel Poder [EMAIL PROTECTED] wrote:
Hi!
Just
Depending on the query, in dba_extents example there are hints only in one
part of multi-part union all SQL, but nevertheless, good point :)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 1:04 AM
If there're