Sqltunning then i see my time |999:59:59 | how is it possible ?
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