Database DataWarehousing (MOSC)

MOSC Banner

PLSQL ANONYMOUS BLOCK hangs when executing parallel query on 10g RAC

edited Feb 15, 2011 7:48AM in Database DataWarehousing (MOSC) 3 commentsAnswered
 

 Hello,

We have seen two cases when we ran PLSQL ANONYMOUS BLOCK with parallel query on 10g RAC, when the process hangs and never finished. There were no locks since we were only in the select stage of a cursor with 4 parallel processes (with a hint).

We saw 1 session on one instance and four sessions on the second instance that run the same select statement.

In the first case one of the Instances crashed. In the second case we killed the sessions.

We are hesitant to run more parallel queries in  PLSQL ANONYMOUS BLOCK. (We do use them in packages though without a problem). Please note that the max parallel processes that are possible are 10 and we used only 4 in the query.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center