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 missing from 10046 trace of cached table

Re: CPU time missing from 10046 trace of cached table

From: <sybrandb_at_hccnet.nl>
Date: Thu, 19 Jul 2007 22:25:56 +0200
Message-ID: <n0iv93l8i6u05q0d1afuje4aaf3elgtp8n@4ax.com>


On Thu, 19 Jul 2007 11:56:59 -0700, bdurrettccci_at_yahoo.com wrote:

>Looks like 10046 traces don't correctly report the CPU usage of full
>scans of cached tables.

I don't see a 10046 trace, ie RAW data, so what is your issue? You didn't post this for a second time because my response didn't suit you, did you?
You don't provide any details: not on how busy the database is, not how busy the server is, you just complain that the wall clock ticks faster than the CPU!
What a big surprise.
Come up with *evidence* instead of unfounded 'claims' and 'myths'.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jul 19 2007 - 15:25:56 CDT

Original text of this message

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