Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL details report Duration/DB time

Sekar_BLUE4EVERFeb 14 2018 — edited Feb 15 2018

Hi , I am looking at a SQL details report for a query and it shows that DUration of query is 10 minutes and DB time is 6.2 seconds . How is this possible , the query is a serial query . Does duration include the inactive time from application as well (SQL*Net message from client)

Shouldnt the duration and DB time be same ? This is the screenshot from the report .Or is the stats not updated as the query is still executing ?

Thanks

This post has been answered by AndrewSayer on Feb 15 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2018

Added on Feb 14 2018

#general-database-discussions, #performance, #report, #sql, #tuning

8 comments

1,066 views