Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!b1g2000pra.googlegroups.com!not-for-mail
From: Mark D Powell <Mark.Powell@eds.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: SYS.dba_ddl_locks
Date: Wed, 12 Dec 2007 17:03:01 -0800 (PST)
Organization: http://groups.google.com
Lines: 30
Message-ID: <f6e46d1c-ba4e-4965-8dad-d13ae2d950a3@b1g2000pra.googlegroups.com>
References: <fjjanp$ise$1@ss408.t-com.hr> <43c2f661-9a90-4d60-93a2-f9c5ded9d182@t1g2000pra.googlegroups.com>
NNTP-Posting-Host: 69.245.97.247
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1197507781 22791 127.0.0.1 (13 Dec 2007 01:03:01 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 13 Dec 2007 01:03:01 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: b1g2000pra.googlegroups.com; posting-host=69.245.97.247; 
 posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 
 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.misc:250999
X-Received-Date: Wed, 12 Dec 2007 20:03:01 EST (text.usenetserver.com)

On Dec 11, 4:22 pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
> On Dec 10, 6:17 am, "Tomo" <tkoko...@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

Searching on metalink on dba_ddl_locks only found 4 bug reports and
only one is recent: bug 4161164 E-Business Intelligence so I think
opening a Service Request might be necessary if the problem is
reproducible and all spare OS memory has not be exhausted.

HTH -- Mark D Powell --