Also see V$SQL_HINT for a list of hints. I don't think it tells you which are deprecated unless that's reflected in PROPERTY. Interestingly, there is no PARALLEL hint only SHARED which is listed as the inverse of NOPARALLEL/NO_PARALLEL Cheers, Dominic Sent from my iPhone