Re: SYS.OBJ$ contention

From: Grant Allen <gxallen_at_gmail.com>
Date: Tue, 28 Nov 2006 13:58:24 +1100
Message-ID: <e2451e6a0611271858t7410af88ic1476cb4b0ffc7e2@mail.gmail.com>

On 11/28/06, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> How about using GTTs rather than creating tables on the fly. Changing
> attributes of dictionary tables, if that's what you mean by
> increasing freelist, is a sure way for your database to become unsupported.

GTTs still touch sys.obj$ (at least, in the 9i test I just did)

SQL> create table foo (bar number);

Table created.

SQL> create global temporary table tempfoo (bar number);

Table created.

SQL> select name from sys.obj$ where ctime > '28-NOV-06';

NAME

---

FOO
TEMPFOO Is there something less "impactful" about GTTs here?

Ciao
Fuzzy
:-)

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

Received on Mon Nov 27 2006 - 20:58:24 CST