Re: hanging package compile

From: Martin <martin.j.evans_at_gmail.com>
Date: Wed, 17 Mar 2010 01:48:06 -0700 (PDT)
Message-ID: <579e4a40-58d1-41cc-8786-f4453d306e96_at_y17g2000yqd.googlegroups.com>

On Mar 16, 5:47�pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> Martin wrote:
> > We have a large schema and packages that compile find on Oracle 11.1.
> > When I try the same procedure to build our schema and packages on a
> > new Oracle 11.2 on a new box it hangs during the compilation of a
> > package:
>
> > sqlplus -S xxx/..._at_a.b.c:1521/sid @xxx_body.sql
>
> > SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,
> > id1, id2, lmode, request, type
> > FROM V$LOCK
> > WHERE (id1, id2, type) IN
> > (SELECT id1, id2, type FROM V$LOCK WHERE request>0)
> > ORDER BY id1, request
>
> > shows nothing and
>
> > select * from v$sql where users_executing> �0
>
> > shows:
>
> > BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
> > select TIME_WAITED_MICRO from V$SYSTEM_EVENT �where event = 'Shared IO
> > Pool Memory'
> > select 1 from obj$ where name='DBA_QUEUE_SCHEDULES'
>
> > I'm not an expert Oracle DBA. Any ideas?
>
> > Martin
>
> The package you are trying to compile is in use?

I don't see how. I have stopped and started the database and there is only me using the database and I'm not doing anything. Also, the package did not exist in the database before I started compiling it.

Martin Received on Wed Mar 17 2010 - 03:48:06 CDT