If you set object level parallelism then all the queries accessing that object will run in parallel. However, in yor case table scan will happen in parallel but index will not.
by the way, check the parallel sessions in v$px_session (especially DEGREE / REQ_DEGREE columns) & v$px_process views.
Regards,




Reply With Quote