Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CPU time << elapsed time (trace): Why?

Re: CPU time << elapsed time (trace): Why?

From: Yong Huang <yong321_at_yahoo.com>
Date: 4 Jun 2002 09:53:16 -0700
Message-ID: <b3cb12d6.0206040853.6a75547b@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US