Hi,
I am working with Oracle 19c.
Does someone what privileges I need for a common user (not SYS or SYSTEM) to run this procedure:
set serveroutput on
declare
l_sql_tune_task_id varchar2(100);
begin
l_sql_tune_task_id := dbms_sqltune.create_tuning_task (
sql_id => 'g0ujpp7y5s1wp',
scope => dbms_sqltune.scope_comprehensive,
time_limit => 60,
task_name => 'g0ujpp7y5s1wp_tuning_task',
description => 'tuning task for statement g0ujpp7y5s1wp.'
);
dbms_output.put_line('l_sql_tune_task_id (task name): ' || l_sql_tune_task_id);
end;
/
I end up with this error:
ORA-13773: insufficient privileges to select data from the cursor cache
It is solved if I grant select any dictionary to the user. But I would like to avoid it.
Kind Regards