Database Tuning (MOSC)

MOSC Banner

dbms_sqltune.report_tuning_task gets ORA-00910

repeatedly. I run this script:


for sqlid in 0jd9np2k8hs1z fktqfn7vhvdbv bg5dxf7twwtyz 6gs6jz12v9n9v 0tyd45m9wpmaw

do

  sqlplus a/b@c <<EOG

set echo on feedback on linesize 160


DECLARE

l_sql_tune_task_id VARCHAR2(200);

BEGIN

l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (

--  begin_snap=> 8424,

--  end_snap=> 8425,

   sql_id => '$sqlid',

  scope => DBMS_SQLTUNE.scope_comprehensive,

  time_limit => 1800,

  task_name => '${sqlid}_tune_task1',

  description => 'Tuning task1 for statement $sqlid');

DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id);

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