Doubt about SQL Advisor
Friends, I'm trying to start using this magic feature, but my DB is quite strange or I missed something out.
10.2.0.1.0 Windows 2003 St.
SQL> CONN OCP
Enter password: ******
Connected.
SQL> CREATE or REPLACE PROCEDURE create_tuning_task IS
2 tuning_task VARCHAR2(80);
3 sqltext CLOB;
4 BEGIN
5 sqltext := 'SELECT * FROM NOMES WHERE NUMERO=25';
6 tuning_task := DBMS_SQLTUNE.CREATE_TUNING_TASK(
7 sql_text => sqltext,
8 user_name => 'OCP',
9 scope => 'COMPREHENSIVE',
10 time_limit => 30,
11 task_name => 'TUNING_TASK_NOMES',
12 description => 'Tuning effort for counting customer orders');
13 END create_tuning_task;
14 /
Procedure created.
SQL> BEGIN
2 DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name => 'TUNING_TASK_NOMES' );
3 END;
4 /
BEGIN
*
ERROR at line 1:
ORA-13605: The specified task or object TUNING_TASK_NOMES does not exist for
the current user.
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SQLTUNE", line 1002
ORA-06512: at line 2
I've just created tre tuning task but it seems to not recognize it.
Are there any tryck?
Thanks to everyone