Re: deciding which query plan to use
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 14 Apr 2004 09:04:09 -0400
On 04/14/2004 08:04:59 AM, ryan.gaffuri@xxxxxxx 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
