oracle 执行计划 ref,sql根据参数不同执行计划不同，这样的情况优怎么处理

执行计划

----------------------------------------------------------

Plan hash value: 2139939376

-------------------------------------------------------------------------------------------------------------

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |

-------------------------------------------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | 20 |146K| 3799 (1)| 00:00:46 |

|* 1 | VIEW | | 20 |146K| 3799 (1)| 00:00:46 |

|* 2 | WINDOW SORT PUSHED RANK | | 20 | 6860 | 3799 (1)| 00:00:46 |

| 3 | NESTED LOOPS OUTER | | 20 | 6860 | 3798 (1)| 00:00:46 |

| 4 | NESTED LOOPS | | 20 | 6280 | 3798 (1)| 00:00:46 |

| 5 | NESTED LOOPS | | 1250 |170K| 1296 (1)| 00:00:16 |

|* 6 | INDEX RANGE SCAN | T_FLOW_USERS_UN | 1249 | 87430 | 22 (0)| 00:00:01 |

|* 7 | TABLE ACCESS BY INDEX ROWID| T_FLOW_ACTIVITIES | 1 | 70 | 2 (0)| 00:00:01 |

|* 8 | INDEX UNIQUE SCAN | PK_T_FLOW_ACTIVITIES | 1 | | 1 (0)| 00:00:01 |

|* 9 | TABLE ACCESS BY INDEX ROWID | T_FLOW_TEMPLET | 1 |174 | 2 (0)| 00:00:01 |

|* 10 | INDEX UNIQUE SCAN | PK_T_FLOW_TEMPLET1 | 1 | | 1 (0)| 00:00:01 |

|* 11 | INDEX UNIQUE SCAN | PK_T_BASEINFO_DICT_VALUE | 1 | 29 | 0 (0)| 00:00:01 |

-------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

1 - filter("rownum">=1 AND "rownum"<=14)

2 - filter(ROW_NUMBER() OVER ( ORDER BY INTERNAL_FUNCTION("T1"."LASTSTATETIME") DESC )<=14)

6 - access("C"."FLOWUSER"='EB2011091913164146748481954589888')

7 - filter("B"."STATES"<>'2')

8 - access("B"."ID"="C"."ACTIVITIESID")

9 - filter("T1"."STATES"='1' AND "T1"."SOFTDELE" IS NULL AND SYSDATE@!-"T1"."LASTSTATETIME"<=60 AND "T1"."ISREFFLOW"='1')

10 - access("T1"."ID"="B"."TEMPLETID")

11 - access("T1"."TYPE"="T3"."ID"(+))