SQL Performance (MOSC)

MOSC Banner

Sqltunning then i see my time |999:59:59 | how is it possible ?

edited Feb 15, 2014 12:00PM in SQL Performance (MOSC) 10 commentsAnswered

hello,

     I executed by select dbms_sqltune.report_tuning_task('&task') from dual;

            Enter value for task: SQL_TUNING_1391523658512

            old   1: select dbms_sqltune.report_tuning_task('&task') from dual

            new   1: select dbms_sqltune.report_tuning_task('SQL_TUNING_1391523658512') from dual

then in my log file how is it possible to find by Oracle Tunning these values :

--------------------------------------------------------------------------------------------------------------------------------------

| Id  | Operation                                   | Name                           | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |

--------------------------------------------------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT                            |                                |  6416K|  6009M|       |   757M  (1)|999:59:59 |

|   1 |  VIEW                                       | AX_BALANCES_SRS_V              |  6416K|  6009M|       |   757M  (1)|999:59:59 |

|   2 |   SORT UNIQUE                               |                                |  6416K|  1226M|  1351M|   757M(100)|999:59:59 |

|   3 |    UNION-ALL                                |                                |       |       |       |            |          |

Why Oracle tunning apply it Time : 999:59:59 ?

best regards

Jean-Pierre

Tagged:

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