yeah, but this is logical I/Os? That is all CPU isnt it?
----- Original Message -----
From: "Mladen Gogala" <mladen_at_wangtrading.com>
To: <oracle-l_at_freelists.org>
Sent: Wednesday, April 14, 2004 9:04 AM
Subject: Re: deciding which query plan to use
>
> On 04/14/2004 08:04:59 AM, ryan.gaffuri_at_cox.net wrote:
>
> > Anyone ever run into this situation? Where logical I/Os are radically
reduced, but overall stress on the system > > is radically increased?
>
> Well, you have to use something on your box. The thing is that you can't
use disks and CPU
> simultaneously in most of the cases. So, if you cut down the number of
I/O's, you'll use
> more CPU. It's sort of a natural thing, as much as anything about
computers can be natural.
> I am expecting to see herbal computers with no fat or cholesterol any day
now. Balancing
> will be much better with next generation of computers, the one which will
have the RPM
> instruction implemented in the hardware.
> --
> Mladen Gogala
> Oracle DBA
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Apr 14 2004 - 16:32:12 CDT
