Re: Global Temporary Table performance with inserts.

There are a couple of oddities with GTTs, array inserts, and volume of undo/redo
generated; but I had thought they appeared only in version 9.

Are you doing array inserts, and if so, are you doing with the /*+ append */ hint ?

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Hector" <hmiranda_at_lehman.com> wrote in message
news:233833e6.0312050650.6a5d8145_at_posting.google.com...


> I am using an Oracle Temporary table to generate a tree of data

> dependencies. I noticed that Inserts are significantly longer into the

> Temporary table than if I replaced the Global Temporary Table with a

> permanent table (just as a test case), almost by a factor of 50. The

> number of rows being inserted are approx. 100. Has any one experienced

> this issue and what are the workarounds? I am using Oracle 8.1.7 and

> have created the Global Temporary Table with "on commit preserve rows"

> clause. Thank you for your help in advance.