Database Tuning (MOSC)

MOSC Banner

I would like create a sqlprofile then have got a problem with ' ' ' error

edited Nov 29, 2011 4:53AM in Database Tuning (MOSC) 9 commentsAnswered
hello,

I would create a sqlprofile to understand the principe :

my sql is :

DECLARE
   my_task_name VARCHAR2(30);
   my_sqltext   CLOB;
  BEGIN
   my_sqltext :=  'select * from v$instance where INSTANCE_NAME='WT9PRD01'';
   my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
   sql_text    => my_sqltext,
   user_name   => 'WT9PRD01',
   scope       => 'COMPREHENSIVE',
   time_limit  => 60,
   task_name   => 'my_sql_tuning_task_3',
   description => 'Task to tune a query for test JPS ');
END;
/

>>>>>>>>>>> when I launched my script I have this next :

 SQL> @CreateTest.sql
   my_sqltext :=  'select * from v$instance where INSTANCE_NAME='WT9PRD01'';
                                                                 *
ERROR at line 5:

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