Problem faced during creation of a tuning set for performance
SQL> DECLARE
2 tune_task varchar2(30);
3 tune_sql CLOB;
4 begin
5 tune_task := DBMS_SQLTUNE.CREATE_TUNING_TASK(
6 sql_id => '3hay9aw39zpma'
7 , task_name => 'tune_test2'
8 , description => 'Provide sql ID'
9 );
10 end;
11 /
DECLARE
*
ERROR at line 1:
ORA-01654: unable to extend index SYS.WRI$_ADV_PARAMETERS_PK by 128 in
tablespace SYSAUX
ORA-06512: at "SYS.PRVT_SQLADV_INFRA", line 123
ORA-06512: at "SYS.DBMS_SQLTUNE", line 606
ORA-06512: at line 5
Thanks in advance..