Re: SYS.dba_ddl_locks

On Dec 10, 6:17 am, "Tomo" <tkoko..._at_varteks.com> wrote:
> On Oracle 9.2.0.5, windows 2000 server,
>
> select * from SYS.dba_ddl_locks
>
> after a time being resulted with an error
> ORA-04030: out of process memory when trying to allocate 2628 bytes
> (callheap,temporary memory)
> later
> ORA-04030: out of process memory when trying to allocate 480 bytes
> (Typecheck heap,frodef : qcpitnm)
>
> We tried to track why compilation of the package resluted with an error
> ORA-04021: timeout occurred while waiting to lock object
>
> any suggestions...

Patch up to 9.2.0.8 (the terminal release of 9.2.0); it appears to be a bug or memory leak addressed by a later patch.

David Fitzjarrell Received on Tue Dec 11 2007 - 15:22:15 CST