SQL Performance (MOSC)

MOSC Banner

Total time spent by a sql in database.

edited Aug 11, 2016 5:00AM in SQL Performance (MOSC) 3 commentsAnswered

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.

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