opt_param usage

After 10g you can use opt_param with only below parameter

- OPTIMIZER_DYNAMIC_SAMPLING,
- OPTIMIZER_INDEX_CACHING,
- OPTIMIZER_INDEX_COST_ADJ,
- OPTIMIZER_SECURE_VIEW_MERGING
- STAR_TRANSFORMATION_ENABLED

like this

SELECT /*+ OPT_PARAM('star_transformation_enabled' 'true') */ * FROM ... ;