Total time spent by a sql in database.
Hello Oracle Gurus,
I hear many times people say during sql performance analysis that " the time spent was mostly in sqlnet message from client ".
So,I am interested to find all the elements of a sql elapsed time including IDLE wait events related to the SQL starting from the last_load_time...to get an idea of time spent in all places(although idle wait events are not considered as part of sql tuning analysis).I am aware that i can get it by running a sql trace but is there an simple way of finding.
i just realized my question was wrong...will update shortly.