ALTER SESSION ENABLE PARALLEL DML;


DELETE /*+ PARALLEL(ra 4) */ ira  ra
WHERE id_cde LIKE 'QP%'
  AND edte    > TO_DATE('01-APR-2007', 'DD-MON-YYYY')
  AND sdte >= TO_DATE('31-DEC-2006', 'DD-MON-YYYY')
/

COMMIT;

Oracle 9.2.0.7, Sun Solaris, Unix OS, 1 index on tab

CREATE TABLE new_ira AS
SELECT * FROM ira
WHERE id_cde LIKE 'QP%'
  AND edte    > TO_DATE('01-APR-2007', 'DD-MON-YYYY')
  AND sdte >= TO_DATE('31-DEC-2006', 'DD-MON-YYYY');

CREATE INDEX ...;

DROP TABLE ira;
RENAME new_ira TO ira;

Here is my observation

i have noticed 4 parallel slave process at one particular time
v$session_longops view

sql was deleting rows on the table, at the same time another table inserted was rows into the same table simultanelously.

question:
how and where can i see the number of parallel slaves running for particular sql with PARALLEL HINT

How come oracle allow table is deleting rows at the same time inserting rows into the same table by another insert statement.