Tuning task recommendation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Tuning task recommendation

  1. #1
    Join Date
    Jul 2009
    Posts
    6

    Tuning task recommendation

    Env: Oracle 10.2.0.4 on AIX

    I have executed dbms_sqltune package on a specific sql statement and trying to see the recommendation . Please se the following.

    SQL> SELECT DBMS_SQLTUNE.REPORT_TUNING_TASK( 'm41b_tuning_task')
    FROM DUAL; 2

    DBMS_SQLTUNE.REPORT_TUNING_TASK('M41B_TUNING_TASK')
    ----------------------------------------------------------------------------------------------------
    GENERAL INFORMATION SECTION
    -------------------------------------------------------------------------------
    Tuning Task Name : m41b_tuning_task
    Tuning Task Owner : SYS
    Scope : COMPREHENSIVE
    Time Limit(seconds) : 60
    Completion Status : COMPLETED
    Started at : 04/26/2010 09:16:24
    Completed at : 04/26/2010 09:16:25
    Number of Errors : 1


    DBMS_SQLTUNE.REPORT_TUNING_TASK('M41B_TUNING_TASK')
    ----------------------------------------------------------------------------------------------------
    -------------------------------------------------------------------------------
    Schema Name: SYS
    SQL ID : dvug81mfz6m6b
    SQL Text : SELECT T_00 . "KNUMA_TEMP" , T_00 . "VBELN" , T_00 . "AEDAT" ,
    T_00 .
    "ERDAT" , T_00 . "POSNR" , T_00 . "MEINS" , T_00 .
    "NETPR" , T_00 .
    "WAERK" , T_00 . "ABGRU" , T_00 . "GEWEI" , T_00 .
    "LGORT" , T_00 .
    "VSTEL" , T_00 . "VRKME" , T_00 . "ROUTE" , T_00 .
    "

    DBMS_SQLTUNE.REPORT_TUNING_TASK('M41B_TUNING_TASK')
    ----------------------------------------------------------------------------------------------------



    Where I could see number of errors is 1 ,but no more info is available to me for diagnosing.


    Can anyone show me the way to identify the error code.


    Thank You very much

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480
    Set long 32000 longc 80
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width