Re: Performance issues with GTT.??

"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?

Lots of people. There are some nasty bugs...

>
> 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
All I can say is: why not consider (ie, assess and evaluate) upgrades to the latest patch level (.0.5 if I'm not much mistaken).

And then what I'd say is: why are you using temporary tables in the first place? Are you *sure* their use is required, because Oracle's read-consistency model means it very seldom is.

Check Google for reference to bugs with temporary tables in this newsgroup in the past. It has come up many times.

Sorry not to be much more help than that. Regards
HJR Received on Sat Jun 05 2004 - 06:25:36 CDT