SQL Performance (MOSC)

MOSC Banner

Problem faced during creation of a tuning set for performance

edited Mar 26, 2014 12:00PM in SQL Performance (MOSC) 6 commentsAnswered

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..

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center