OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » parallel DML

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

parallel DML [message #222099]

Thu, 01 March 2007 15:01

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.

Report message to a moderator

Re: parallel DML [message #222104 is a reply to message #222099]

Thu, 01 March 2007 18:59

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

Report message to a moderator

Previous Topic:	Row Chaining Issue
Next Topic:	Tuning of a sql querry

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 05:10:26 CST 2024