Oracle_SQL_Scripts/attach_baseline_one_sql_another.sql at master · as10128/Oracle_SQL_Scripts · GitHub

28 lines (25 loc) · 588 Bytes

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

declare

m_clob clob;

begin

select

sql_fulltext

into

m_clob

from

v$sql

where

sql_id = '&m_sql_id_bad'

and child_number = &m_child_number_bad

;

dbms_output.put_line(m_clob);

dbms_output.put_line(

dbms_spm.load_plans_from_cursor_cache(

sql_id => '&m_sql_id_good',

plan_hash_value => &m_plan_hash_value_good,

sql_text => m_clob,

fixed => 'NO',

enabled => 'YES'

)

);

end;

/