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 intensive fetch

Re: CPU intensive fetch

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Thu, 29 Mar 2001 18:28:24 +0200
Message-ID: <3AC362A8.9A24AD41@0800-einwahl.de>

Even if you have one table with 20 rows it is not a problem to construct a query that runs forever on whatever big system you offer.

So if you want us to help you please include the query (no problem with cut & paste) and the table descriptions *with* indexes of the the underlying tables.

Martin

u783416748_at_spawnkill.ip-mobilphone.net wrote:
>
> Could someone perhaps help to explain the following.
> The query is VERY long so I haven't included it, but
> no table (7 of them) has more than 20 rows.
> The CPU time is genuine, it takes over the machine for 2 minutes,
> which seems excessive give the disk, query, and current values.
>
> call count cpu elapsed disk query current rows
> ------- ------ -------- ---------- ---------- ---------- ---------- ----------
> Parse 1 0.02 0.02 0 0 0 0
> Execute 1 18.65 18.68 0 0 0 0
> Fetch 2 118.81 120.05 1 19 28 1
> ------- ------ -------- ---------- ---------- ---------- ---------- ----------
> total 4 137.48 138.75 1 19 28 1
>
> TIA
>
> Eric
>
>
> --
> Sent by eric from deptj in field demon element from co within field uk
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Mar 29 2001 - 10:28:24 CST

Original text of this message

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