Re: Unusually high number of current mode reads for a GTT insert

From: VC <boston103_at_hotmail.com>
Date: Tue, 02 Mar 2004 22:04:18 GMT
Message-ID: <Cx71c.165671$jk2.607244@attbi_s53>

"VC" <boston103_at_hotmail.com> wrote in message news:8s71c.104613$4o.121280_at_attbi_s52...
> In Oracle 8i, there is no such difference.
>

I shoud probably re-prase this one. Under Oracle 8i, there is not much difference in the number of the current gets between GGTs and ordinary tables. Actually, the 9i GTT behaviour was discovered after having migrated some applications to 9i when quite a few inserts became slower whilst retaining the same execution plan (on the same hardware).

> Thank you for any thoughts.
>
> VC
>
>
Received on Tue Mar 02 2004 - 16:04:18 CST