Oracle Error ORA-19380: invalid plan filter

Oracle Error Message

ORA-19380: invalid plan filter

Reason for the Error

The user specified an invalid filter for the plan when calling the select_sqlset table function.

Solution

Adjust the the filter to be one of the following values and retry the operation: MAX_ELAPSED_TIME, MAX_CPU_TIME, MAX_DISK_READS, MAX_OPTIMIZER_COST, MAX_BUFFER_GETS, FIRST_LOADED LAST_LOADED, FIRST_GENERATED, or LAST_GENERATED.