Need help speeding up my query in Siebel Database

hi guys

heres my query and it takes a really long time to finish

SELECT /*+ PARALLEL(i 36)*/ o1.ORDER_NUM,i.SERVICE_NUM,p.NAME,i.ACTION_CD,i.X_ACTION_CD,ix.ATTRIB_03

FROM SIEBEL.S_ORDER_ITEM i,SIEBEL.S_PROD_INT p, SIEBEL.S_ORDER o1,SIEBEL.S_ORDER_X o1x, SIEBEL.S_ORDER_ITEM_X ix

where

o1.row_id=i.ORDER_ID and

o1.row_id=o1x.row_id and

p.ROW_ID=i.PROD_ID and

i.row_id=ix.row_id and

(p.Type='Package' and

i.X_ACTION_CD='Delete' and