Re: SYS.OBJ$ contention

From: Grant Allen <gxallen_at_gmail.com>
Date: Tue, 28 Nov 2006 14:15:11 +1100
Message-ID: <e2451e6a0611271915o6ed1fbe3o762f6b75a6167c82@mail.gmail.com>

On 11/28/06, Grant Allen <gxallen_at_gmail.com> wrote:
> On 11/28/06, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> > How about using GTTs rather than creating tables on the fly.
>
> GTTs still touch sys.obj$ (at least, in the 9i test I just did)

Of course, I just answered my own question ... create the GTTs once, not every time the report jobs are run.

Sorry Wolfgang ... I've not had enough coffee yet this morning.

Ciao
Fuzzy
:-)

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 27 2006 - 21:15:11 CST