dbms_sqltune.report_tuning_task gets ORA-00910
repeatedly. I run this script:
for sqlid in 0jd9np2k8hs1z fktqfn7vhvdbv bg5dxf7twwtyz 6gs6jz12v9n9v 0tyd45m9wpmaw
do
sqlplus a/b@c <<EOG
set echo on feedback on linesize 160
DECLARE
l_sql_tune_task_id VARCHAR2(200);
BEGIN
l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (
-- begin_snap=> 8424,
-- end_snap=> 8425,
sql_id => '$sqlid',
scope => DBMS_SQLTUNE.scope_comprehensive,
time_limit => 1800,
task_name => '${sqlid}_tune_task1',
description => 'Tuning task1 for statement $sqlid');
DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id);