如何理解这个CPU和ELAPSED的区别

Yong Huang

原帖由 viadeazhu 于 2009-1-17 05:28 发表

减出来应该是io time吧

I believe it can also include network wait time. Try running a SQL through a very slow SQL*Net connection and then flush shared pool and run it locally on the server. Make sure the CPU time in v$sql% view(s) is about the same. Elapsed time should be very different.

Yong Huang