Re: hanging package compile

From: sandeep pande <sandy.soft80_at_gmail.com>
Date: Tue, 11 May 2010 03:00:07 -0700 (PDT)
Message-ID: <9d71a7b8-b49b-4529-8b0e-5845252fe5c2_at_n37g2000prc.googlegroups.com>

On Mar 16, 10: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

Hi,

query v$sess_io, v$session_events and v$session_waits

Regards
Sandy Received on Tue May 11 2010 - 05:00:07 CDT