13 lines
286 B
SQL
13 lines
286 B
SQL
/*
|
|
exec :ret := dbms_spm.load_plans_from_cursor_cache(-
|
|
sql_id=>'&v_sql_id', -
|
|
plan_hash_value=>&v_plan_hash_value, -
|
|
*/
|
|
var ret number
|
|
exec :ret := dbms_spm.load_plans_from_cursor_cache(-
|
|
sql_id=>'&sql_id', -
|
|
plan_hash_value=>&plan_hash_value,-
|
|
fixed=>'&fixed');
|
|
|
|
|