Win2k/8.1.7.3/Optimizer Weirdness

2002-11-19 Thread Vergara, Michael (TEM)
Hi Listers: Has anyone ever seen something like this before? Can somebody explain it to me? Thanks, Mike SQL SQL select file_name from dba_temp_files; File Name - E:\ORANT\ORADATA\ECRMP\TEMP01.DBF 1 row selected. SQL select /*+ RULE */

RE: Win2k/8.1.7.3/Optimizer Weirdness

2002-11-19 Thread Clark, Tommy R
I was able to duplicate this on my 9.0.1.1.1 database running on Win2K. -Original Message- Sent: Tuesday, November 19, 2002 1:17 PM To: Multiple recipients of list ORACLE-L Hi Listers: Has anyone ever seen something like this before? Can somebody explain it to me? Thanks, Mike SQL

Re: Win2k/8.1.7.3/Optimizer Weirdness

2002-11-19 Thread Igor Neyman
Same happens under 9.2. But, select /*+ RULE */ name from v$tempfile; works fine. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 1:16 PM Hi Listers: Has anyone ever seen

RE: Win2k/8.1.7.3/Optimizer Weirdness

2002-11-19 Thread Vergara, Michael (TEM)
I forgot to mention - there are no statistics on any SYS or SYSTEM objects - per the FMs. Anybody know why this happens? -Original Message- Sent: Tuesday, November 19, 2002 10:50 AM To: Multiple recipients of list ORACLE-L I was able to duplicate this on my 9.0.1.1.1 database running

Re: Win2k/8.1.7.3/Optimizer Weirdness

2002-11-19 Thread Peter Gram
Same thing in 9.2.0.2 on linux Clark, Tommy R wrote: I was able to duplicate this on my 9.0.1.1.1 database running on Win2K. -Original Message- Sent: Tuesday, November 19, 2002 1:17 PM To: Multiple recipients of list ORACLE-L Hi Listers: Has anyone ever seen something like this

RE: Win2k/8.1.7.3/Optimizer Weirdness

2002-11-19 Thread Gogala, Mladen
-L Subject: RE: Win2k/8.1.7.3/Optimizer Weirdness I was able to duplicate this on my 9.0.1.1.1 database running on Win2K. -Original Message- Sent: Tuesday, November 19, 2002 1:17 PM To: Multiple recipients of list ORACLE-L Hi Listers: Has anyone ever seen something like

RE: Win2k/8.1.7.3/Optimizer Weirdness

2002-11-19 Thread Jamadagni, Rajendra
Title: RE: Win2k/8.1.7.3/Optimizer Weirdness 9.2 on AIX ... same problem ... Wait they must have fixed it in 10i Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal

RE: Win2k/8.1.7.3/Optimizer Weirdness

2002-11-19 Thread Fink, Dan
Title: RE: Win2k/8.1.7.3/Optimizer Weirdness Here are the different explain plans. This is on an 8.1.7.0 db on Solaris.One idea isthe problem could be on the merge-join. I've heard of some problems with this operation. SQL select file_name from dba_temp_files; FILE_NAME

RE: Win2k/8.1.7.3/Optimizer Weirdness

2002-11-19 Thread Gogala, Mladen
Title: RE: Win2k/8.1.7.3/Optimizer Weirdness It is very hard to believe that there is a big problem with merge join as it is the oldest join method, next to the nested loops. Hash join and star schema are much newer. I remember merge joins at least from version 5. Merge join