Failed to execute the creation of sql baseline, an error was reported
windows2012R2 oracle11.2.0.4.0
I run the sql optimization guide, @?/rdbms/admin/sqltrpt,and got the following results
- Alternative Plan Finding
The following table lists these plans ranked by their average elapsed time.
See section "ALTERNATIVE PLANS SECTION" for detailed information on each
plan.
id plan hash last seen elapsed (s) origin note
-- ---------- -------------------- ------------ --------------- ----------------
1 2577401391 2021-09-02/16:00:31 0.289 AWR
2 3275311314 2021-08-31/13:00:36 1.740 AWR
3 207433069 2021-09-06/10:09:59 2.661 Cursor Cache original plan
Recommendation
--------------
execute dbms_sqltune.create_sql_plan_baseline(task_name => 'tasks_48621',
owner_name => 'SYS', plan_hash_value => 2577401391);
When i implement the suggestion，Failed to execute the creation of sql baseline, an error was reported