PROTECTED]
Date: 2003/10/02 Thu PM 12:34:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Physical I/O and databases other than oracle
On Thu, 2003-10-02 at 11:44, Garry Gillies wrote:
Im reading an academic book on databases and it states that
Physical I/O
: DENNIS WILLIAMS [EMAIL PROTECTED]
Date: 2003/10/06 Mon AM 09:34:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: Physical I/O and databases other than oracle
Cary - Thanks so much for providing the historical perspective on this
issue. Perhaps you could confirm
of list ORACLE-L
my email states that in oracle this isnt true. HOWEVER, what about other
databases?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/10/02 Thu PM 12:34:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Physical I/O and databases other than oracle
Im reading an academic book on databases and it states that Physical I/O
is often the primary bottleneck in tuning. Its not the case in Oracle.
Is this statement correct
with sybase, sql server, or DB2? or maybe mysql?
Eh?
What IS the primary bottleneck in tuning Oracle?
I go along with
On Thu, 2003-10-02 at 11:44, Garry Gillies wrote:
Im reading an academic book on databases and it states that Physical I/O
Eh?
What IS the primary bottleneck in tuning Oracle?
Cache hit ratio. You tune the buffer cache hit ratio (BCHR) and your job
is done. Database with 99.9% BCHR must be
Title: RE: Physical I/O and databases other than oracle
According to one recently published source*, in a well-tuned database system, the server should be CPU-limited. The reasoning here is that in a perfectly tuned system, the other bottlenecks of I/O, network, etc. have been eliminated, so
To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
@wangtrading.com cc:
Subject: Re: Physical I/O and databases
This is not an issue of answering the question, but pointing out that the question is
not correct.
Why do databases exist (aside to make Larry money)? To 'permanently' store data. As
this storage must survive a system failure, we choose to place the data on a
non-volatile medium (disk, paper,
my email states that in oracle this isnt true. HOWEVER, what about other databases?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/10/02 Thu PM 12:34:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Physical I/O and databases other than oracle
On Thu, 2003
]
@wangtrading.com cc:
Subject: Re: Physical I/O and
databases other than oracle
Title: RE: Physical I/O and databases other than oracle
So to look good,
I should unplug all the CPU boards except one or two to end up with CPU
limitation :)
Regards,
Waleed
-Original Message-From: David Wagoner
[mailto:[EMAIL PROTECTED]Sent: Thursday, October 02,
2003 12
01:09:36 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Physical I/O and databases other than oracle
This is not an issue of answering the question, but pointing out that the question
is not correct.
Why do databases exist (aside to make Larry money
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 3:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Physical I/O and databases other than oracle
my email states that in oracle this isnt true. HOWEVER, what
about
13 matches
Mail list logo