Re: Win2k/8.1.7.3/Optimizer Weirdness

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 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 */ file_name from dba_temp_files;
>
>no rows selected
>
>SQL>
>
>---
>===========================================================================
>Michael P. Vergara
>Oracle DBA
>Guidant Corporation
>
>
>

-- 
Peter Gram, Miracle A/S
Phone : +45 2527 7107, Fax : +45 4466 8856
mailto:peter.gram@MiracleAS.dk - http://MiracleAS.dk





Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.

--------------ms070905080202050203080505--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

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



application/x-pkcs7-signature attachment: smime.p7s