DROP_SQL_PLAN_DIRECTIVE : Drops the specified SQL plan directive. The length of time an unused SQL plan directive is retained for is determined by the SPD_RETENTION_WEEKS preference, default 53 weeks. This is displayed and modified using the following routines. GET_PREFS : Displays the specified preference.
For More Information Please Refer:
You May Also Like to Read: