Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SYS.OBJ$ contention

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US