Oracle Solution for Error ora-19380

ORA-19380: invalid plan filter

What triggered the Error:

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

What should we do to fix it:

just 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.