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

spool performance

From: chan01 <chandra_2000_us_at_yahoo.com>
Date: 3 Nov 2004 04:00:45 -0800
Message-ID: <480cb9d4.0411030400.7fe935ea@posting.google.com> 





I have sql query, it will create a data file. The query execution is
taking 20minutes but spool is taking 4 hours to create 600MB file. My
question is do we have any other way to handle this condition? I would
appreciate your openions.



Thanks.
Received on Wed Nov 03 2004 - 06:00:45 CST












Original text of this message













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