Re: hanging package compile

From: Martin <martin.j.evans_at_gmail.com>
Date: Tue, 16 Mar 2010 10:22:50 -0700 (PDT)
Message-ID: <d9d1d2c7-9bbb-46c3-b7b0-155110e5166c_at_d27g2000yqf.googlegroups.com>

On Mar 16, 5:14�pm, Martin <martin.j.ev..._at_gmail.com> 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

Some additional info:

select * from v$session_wait where sid = 33

33	228	db file sequential read	file#	4	0000000000000004	block#	978
00000000000003D2	blocks	1	0000000000000001	1740759767	8	User I/O	1
2399	WAITED KNOWN TIME	5170	(null)	2399084207

Martin Received on Tue Mar 16 2010 - 12:22:50 CDT