Home » RDBMS Server » Performance Tuning » parallel DML
parallel DML [message #222099] Thu, 01 March 2007 15:01 Go to next message
rcd70
Messages: 14
Registered: April 2006
Location: Auckland, New Zealand
Junior Member
Hi

How do I check if Parallel DML is enabled for a session or not after executing the statement Alter session enable parallel dml.
Re: parallel DML [message #222104 is a reply to message #222099] Thu, 01 March 2007 18:59 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
SQL> select pdml_status from v$session
  2  where sid in (select sid from v$mystat);

PDML_STA
--------
DISABLED

SQL> alter session enable parallel dml;

Session altered.

SQL> select pdml_status from v$session
  2  where sid in (select sid from v$mystat);

PDML_STA
--------
ENABLED
Previous Topic: Row Chaining Issue
Next Topic: Tuning of a sql querry
Goto Forum:
  


Current Time: Sun Dec 04 22:42:24 CST 2016

Total time taken to generate the page: 0.21840 seconds