Trying to analyze report's tkprof
hello,
Since my upgraded database to the version 12.1 i see that the behavior is different.
then i try to understand a report's tkprof
I see that the behavior of the oracle engine is different between the 12.1 version and the 11.2.0.3 engine
then i have :
| call | count | cpu | elapsed | disk | query | current | rows |
------- ------ -------- ---------- ---------- ---------- ---------- ----------
| Parse | 0 | 0.00 | 0.00 | 0 | 0 | 0 | 0 |
| Execute | 1 | 1.97 | 1.97 | 0 | 0 | 0 | 0 |
| Fetch | 0 | 0.00 | 0.00 | 0 | 0 | 0 | 0 |
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 84372 0.24 110.80
Disk file operations I/O 9 0.00 0.00
********************************************************************************
1 - I see that all disk, query, current, rows are '0'