Re: GTT & library cache pin

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Fri, 10 Jun 2005 18:28:55 +0800
Message-ID: <5e304862050610032855cc8e7e@mail.gmail.com>

Do you get the same problem when you=20

1. specify the columns manually
2. use something other than user_objects

hth
connor

On 6/10/05, Barr, Stephen <Stephen.Barr_at_bskyb.com> wrote: > I'm getting very large waits for library cache pin when trying to create = a

> GTT from within a PL/SQL procedure -

>=20
>=20
>=20
>=20

> DW_STATS@>CREATE GLOBAL TEMPORARY TABLE TEST2 on commit preserve rows as
> select * from user_objects where 1=3D0;

>=20
>=20
>=20

> Table created.

>=20
>=20
>=20

> Elapsed: 00:00:00.29

>=20
>=20

--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

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

Received on Fri Jun 10 2005 - 06:34:05 CDT