-
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
-
"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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|