Re: hanging package compile
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Tue, 16 Mar 2010 18:47:41 +0100
Message-ID: <4b9fc43c$0$2866$ba620e4c_at_news.skynet.be>
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/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
Date: Tue, 16 Mar 2010 18:47:41 +0100
Message-ID: <4b9fc43c$0$2866$ba620e4c_at_news.skynet.be>
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/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? Received on Tue Mar 16 2010 - 12:47:41 CDT