ALTER SESSION for explain plan window

[Bert Gombos]

Hi anybody,

Parallel DML works only after ALTER SESSION ENABLE/FORCE PARALLEL DML. In not single session mode I'm unable to execute this in the 'technical' session, therefore only non-parallel plans are visible.
I suggest to add new buttons in explain plan window next to 'preferences' button, which execute ALTER SESSION DISABLE/ENABLE/FORCE PARALLEL DML/DDL/QUERY.

 

[Marco Kalter]

I have added this to the list of enhancement requests. Note that you can already explicitly execute these alter session statements in the Explain Plan Window.

 

[Bert Gombos]

How?
In dual session mode "alter session enable parallel dml" in Plan Window results in ORA-12841 (Cannot alter the session parallel DML state within a transaction).

 

[Marco Kalter]

That does indeed fail. We'll check it out.

 

[Marco Kalter]

Apparently there is a transaction open when the alter statement is executed. This has been fixed for 8.0.

 

[Bert Gombos]

Thanks.