Re: 8.1.7 + Designer 6.0 --> A bug ?

Sybrand Bakker wrote:
>
> On Mon, 05 Mar 2001 17:48:04 GMT, Walter Pircali <walter_at_entity-ag.it>
> wrote:
>
> >
> >
> >Hi to all,
> >
> >we have an Win2kServer SP1 with an 8.1.7 over it and 3 instances.
> >We use one of this instance for Oracle Designer 6.0.
> >As soon as we try to create the oracle designer repository it starts
> >to make all, and then on package CIOUELEMENT_TYPE it hangs (CPU 100%).
> >
> >Initially I've thought it was win2k, so I've tried with NT 4.0 SP6 but
> >it's
> >the same. I've tried to recompile it manually ... nothing (CPU 100% and
> >stop).
> >
> >I've take a look at metalink and technet ... nothing !
> >
> >Someone of you have had the same problem ? (or no problem at all ?)
> >
> >Thanks in advice for every answer
> >
> >bye
>
> Problems like this are usually being caused by insufficient shared
> pool, and/or an too small SYSTEM tablespace. IMO: not a bug
> shared_pool_size could easily be 30 or 40 M. The pl/sql involved is
> more as 60 Mb compiled
>
> Hth,
>
> Sybrand Bakker, Oracle DBA

Its a known bug in 8.1.7 PL/SQL - there's a description on my site

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"