understanding performance of my query
hello,
I try to understand if it is possible to improve my query which have a view.
1 - I did a trace and a tkprof. I join you the trace file and the tkprof report. my query is big it is why I join you a file.
because the copy/past is not correct. see next :
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 3 1.90 2.00 0 0 0 0
Fetch 3 146.46 162.01 8005 13002580 0 3
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 148.37 164.02 8005 13002580 0 3
2 - the SQL ID: 91bxyszsc1arw Plan Hash: 2073534628
If I understand the tkprof : I see next :