Dear Tamil, While trying example provided in the link given by you I got the following problem

Code:
SQL> SELECT count(*) FROM myobjects;

  COUNT(*)
----------
  10427392

Elapsed: 00:00:13.06
I'm trying to run Parallel DML on that table, I have following index on that table
Code:
SQL> SELECT index_name, column_name FROM user_ind_columns WHERE table_name = 'MYOBJECTS';

INDEX_NAME					 COLUMN_NAME
------------------------------ ------------------------------
INDX_MYOB					  OBJECT_NAME

Elapsed: 00:00:00.01
Here is the code for Parallel DML, I'm running only one session which is current. I dont know how comes I got an error saying "DEADLOCK DETECTED"

Code:
SQL> alter session enable parallel dml;

Session altered.

SQL>
SQL> alter session set db_file_multiblock_read_count=128;

Session altered.

SQL> set timin on
SQL>
SQL>
SQL> UPDATE /*+ full(myobjects) parallel(myobjects, 8)*/ myobjects
  2  SET object_name = upper(object_name);
update /*+ full(myobjects) parallel(myobjects, 8)*/
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P015
ORA-00060: deadlock detected while waiting for resource