Query hang detected when I used a parallel query which is located in Package.

Hello.

Query hang detected when I used a parallel query which is located in Package.

When I execute this query on the SQLPLUS directly, the query is successfully finished within 30sec. 

However, when I execute this query in Package(PL/SQL Package), the query is never ended.(over 4~5 hours)

Unfortunately, Oracle SR Engineer could not find any reason about this during one month. 

 

EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML PARALLEL 8';

EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL QUERY PARALLEL 8';

Give me some advice about this issue.

Have a nice day. Thanks~!

 

DB: Oracle Database 11gR2( Oracle RDBMS 11.2.0.3 with BP14 )