Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CPU time << elapsed time (trace): Why?
100.17706_at_germanynet.de wrote in message news:<adhsm8$gfu$1_at_news.netmar.com>...
> DB physical setup, global parameters and other administrative measures. I
> used tkprof to evaluate a trace file, where I found that CPU time was
> considerable smaller that elapsed time. Well, usually, this is due to
> harddisk activity. The problem ist that we cannot understand this, because
How about network time? OK. What's in v$session_wait for the session in question? Can you run truss -p [pid] and show us portion of it?
Yong Huang Received on Tue Jun 04 2002 - 11:53:16 CDT