SQL Performance (MOSC)

MOSC Banner

understanding performance of my query

edited Apr 18, 2016 11:51AM in SQL Performance (MOSC) 11 commentsAnswered

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 :

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