ORA-19380: invalid plan filter

ORA-19380: invalid plan filter
Cause: The user specified an invalid filter for the plan when calling the select_sqlset table function.
Action: 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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:44

ORA-19380：无效计划过滤器,
.原因：调用select_sqlset表函数时，用户为计划指定了一个无效的过滤器。,
.操作：将过滤器调整为以下值之一，然后重试操作：MAX_ELAPSED_TIME，MAX_CPU_TIME，MAX_DISK_READS，MAX_OPTIMIZER_COST，MAX_BUFFER_GETS，FIRST_LOADED LAST_LOADED，FIRST_GENERATED或LAST_GENERATED。,
.

aiaiDBA

13718043309

010-86462881

ORA-19380: invalid plan filter

1 个回答

相似问题