"Newbie" <learning_still_at_hotmail.com> wrote in message
news:6093c29e.0406050214.699388b_at_posting.google.com...
> Hi,
>
> Has anyone faced any performance issues with use of Global Temporary
> Tables?
>
> We have an application where a piece of code within a loop inserts
> 38000 records into an Oracle Temp table. Using pl/sql developer's
> profiler feature, we found that INSERTs into the temp table is taking
> almost 70% of the total execution time. I am not sure how to measure
> other performance parameters and bottlenecks. But are there issues
> with using TEMP tables having to do with so much INSERTs.?? TEMP
> tables reside in temporary tablespace. So does that mean INSERT of
> 38000 records will actually be 38000 hits to disk (I/O) ??
>
> O9i - 9.2.0.2
> OS - HP Unix
> I am lost here. Could anyone please help?
>
> TIA
Are you using bind variables? row by row is slow by slow. Do things in a
set basis if possible.
Jim
Received on Sat Jun 05 2004 - 12:31:32 CDT
