Skip to Main Content
Forums

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!

The Meaning of elapsed time in sql

784287Aug 24 2010 — edited Aug 24 2010
hi all

A simple question about elapsed time in v$sql.

I know it means that a total time when a query is executing.

I think that

elapsed time = cpu time + user i/o wait time + application_wait_time
+ concurrency_wait_time + cluster_wait_time + plsql_exec_time + java_exec_time

of course elapsed time couldn't be exactly same with a sum of above stuff, because its value is accumulated value.

but i have some weird data. its value is bigger 130% than the sum. i have no idea where other 30% comes from.

its value is too big to ignore.

does anybody have a idea?

(it is single core environment)

thanks in advance..
This post has been answered by Salman Qureshi on Aug 24 2010
Jump to Answer

Comments

Can you please have a look at the VS Code Windowing options to see if any of them do what you want?
In the VS Code menu, select View->Editor Layout

User_ZZQ0F

Everytime I run query I use shortcut Ctrl+Alt+Right to split pane.
Would be nice to do make it automatically.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 21 2010
Added on Aug 24 2010
#general-database-discussions, #sql, #time
7 comments
15,362 views