Database Tuning (MOSC)

MOSC Banner

Is there a way to get query duration on server side ?

edited Jul 15, 2014 5:00AM in Database Tuning (MOSC) 3 commentsAnswered

Oracle 11.2.0.1 :

we can get informations on querys in ASH view. so we can have elasped time of a query, but with parrallel processing, we get db time , wich is much more than real time.

For example the user report query wich  takes 20 sec, (in place of 0.5 sec), but when we get information on sql_id in the ASH view, the query time is 96 seconds,

I know that it is possible to to "set timing on" in sqlplus, to get this real time in a client tools, but we would like get the real time (ex : < 20 sec) from the server side in history view, or grid reports.

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