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