Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare
- l_result number;
- begin
- l_result:= dbms_spm.load_plans_from_cursor_cache(
- sql_id => 'g1gad19d2baa0',
- plan_hash_value =>2051789865);
- end;`
- begin
- dbms_spm.create_stgtab_baseline(table_name => 'table_name');
- end;
- declare
- l_result number;
- begin
- l_result := dbms_spm.pack_stgtab_baseline(
- table_name => 'table_name',
- enabled =>'yes',
- creator => 'VIKTOROV_AA');
- end;
- declare
- l_result number;
- begin
- l_result:= dbms_spm.drop_sql_plan_baseline(sql_handle => 'SQL_dc1fb582419833d4');
- end;
- create table table_name as select * from table_name@db_link
- declare
- l_result number;
- begin
- l_result := dbms_spm.unpack_stgtab_baseline(table_name => 'table_name');
- end;
Add Comment
Please, Sign In to add comment