Oracle parallel not working, why ?

Run this and let me know the result..

SELECT DECODE (ps.server_set, '', s.program, ' PX Slave') "Program",
ps.qcsid "Parent SID",
DECODE (ps.server_set, '', ' --', ps.sid) "Child SID",
ps.degree || DECODE (ps.degree, '', ' --', '/') || ps.req_degree
"DOP/REQ",
DECODE (ps.server_set, '', 'Coordinator Process', ps.server_set)
"Server Set", NVL (p.server_name, ' --') "PX Server",
NVL (p.status, ' --') "PX Server Status", pss.VALUE "Physical Reads",
DECODE (ps.server_set, '', s.sql_hash_value, '') "SQL Hash Value",
DECODE (ps.server_set, '', s.last_call_et, '') "Seconds Elapsed"
FROM v$px_session ps, v$session s, v$px_process p, v$px_sesstat pss,
v$statname sn
WHERE s.sid = ps.qcsid(+)
AND ps.sid = p.sid(+)
AND ps.sid = pss.sid(+)
AND pss.statistic# = sn.statistic#(+)
AND sn.name = 'physical reads'
AND s.status = 'ACTIVE'
AND NOT s.program LIKE '%(A%' --Eliminate Streams Apply Process
AND NOT s.program LIKE '%(C%' --Eliminate Streams Capture Process
ORDER BY ps.qcsid, "Server Set" DESC, "PX Server";

Oops I am out of date. I did some checking and as of 9.2 parallel delete is supported, with some restrictions. Sorry for misguiding.

Can you give some info about the table. Some things listed as disabling parallel DML:
Triggers
Self-referential integrity
Bitmap indexes

SQL> show parameter parallel

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fast_start_parallel_rollback         string      LOW
parallel_adaptive_multi_user         boolean     TRUE
parallel_automatic_tuning            boolean     FALSE
parallel_execution_message_size      integer     2152
parallel_instance_group              string      
parallel_max_servers                 integer     320
parallel_min_percent                 integer     0
parallel_min_servers                 integer     0
parallel_server                      boolean     FALSE
parallel_server_instances            integer     1
parallel_threads_per_cpu             integer     2
recovery_parallelism                 integer     0

query results from 2nd comment, attached.

mrjoltcola,

- I can't see triggers (not authorized), but I don't think there are any

- RI exists but for subordinate tables (and I delete in the proper order)
      - no self- RI

- I'm not familiar with bit map indexes, but I don't think we have them, I probably would have heard them being talked about

sventhan, sorry for not getting back on this quickly.

I'm not familiar with the concept of "create as select" when trying to delete, can you explain ?

williampeck:

How big your table is?

What I mean is

1) create a temp table
     create temp_t as select data_to_keep from real_t; -- CTAS
2) drop real_t
3) rename temp_t to real_t


It all depends upon your table size and space requirement.

Ok, makes sense on the temp table approach.

But on my initial question, it seems as if it doesn't parallel deletes. I do get parallel processing for selects and I was just wondering.

It's Oracle 10.2