Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 Jonathan Lewis in his book Practical Oracle 8i
"Although it is possible to create a few problems with network traffic,
excess CPU usage and process contention, ultimately the only significant
threat to a database system is physical I/O". (page 38)
CONFIDENTIAL: The information contained in this email (including any attachments) is confidential, subject to copyright and for the use of the intended recipient only. If you are not the intended recipient please delete this message after notifying the sender. Unauthorised retention, alteration or distribution of this email is forbidden and may be actionable.
Attachments are opened at your own risk and you are advised to scan incoming email for viruses before opening any attached files. We give no guarantee that any communication is virus-free and accept no responsibility for virus contamination or other system loss or damage of any kind.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Garry Gillies INET: g.gillies_at_weir.co.uk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Oct 02 2003 - 10:44:46 CDT