Performance issues with GTT.??

From: Newbie <learning_still_at_hotmail.com>
Date: 5 Jun 2004 03:14:06 -0700
Message-ID: <6093c29e.0406050214.699388b@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 Received on Sat Jun 05 2004 - 05:14:06 CDT