Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: temporary tablespace performance

Re: temporary tablespace performance

From: Paul Bennett <bennett_at_cc.gatech.edu>
Date: 1998/03/31
Message-ID: <3521425D.63130CAF@cc.gatech.edu>#1/1 







I found the solution to the problem.  I was storing a rowid in a numeric column and then useing that in a join to the rowid of a table.  Apparently, Oracle
was using the temp space to convert the rowids.  I changed the type from numeric to rowid, and since oracle is now comparing apples to apples, it works fine.




This is consistent with why the report was working fine in Oracle 7, because rowid's were a different format.




Received on Tue Mar 31 1998 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US