Guest User

Untitled

a guest
Jul 17th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. declare
  2. l_result number;
  3. begin
  4. l_result:= dbms_spm.load_plans_from_cursor_cache(
  5. sql_id => 'g1gad19d2baa0',
  6. plan_hash_value =>2051789865);
  7. end;`
  8.  
  9. begin
  10. dbms_spm.create_stgtab_baseline(table_name => 'table_name');
  11. end;
  12.  
  13. declare
  14. l_result number;
  15. begin
  16. l_result := dbms_spm.pack_stgtab_baseline(
  17. table_name => 'table_name',
  18. enabled =>'yes',
  19. creator => 'VIKTOROV_AA');
  20. end;
  21.  
  22. declare
  23. l_result number;
  24. begin
  25. l_result:= dbms_spm.drop_sql_plan_baseline(sql_handle => 'SQL_dc1fb582419833d4');
  26. end;
  27.  
  28. create table table_name as select * from table_name@db_link
  29.  
  30. declare
  31. l_result number;
  32. begin
  33. l_result := dbms_spm.unpack_stgtab_baseline(table_name => 'table_name');
  34. end;
Add Comment
Please, Sign In to add comment