Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Doubt about SQL Advisor

KeenOnOracleOct 20 2009 — edited Oct 20 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2009
Added on Oct 20 2009
2 comments
201 views