Enable 32K Block in 8K Block DB

Enable 32K Block in 8K Block DB

Post by David Will » Wed, 07 Apr 2004 09:34:07



Really Oracle benchmarks all use raw?...As an Informix person why did
I used to keep hearing

"according to Oracle raw devices are not faster, in fact filesystems are
quicker"

FROM MY CUSTOMERS than?
^^^^^^^^^^^^^^^^^^^^^^

Used to really annoy me...so Oracle have come around to my way of
thinking than?
As it's faster? What a suprise...



Dunno.
 
 
 

Enable 32K Block in 8K Block DB

Post by Howard J. » Wed, 07 Apr 2004 09:56:09


are


The discussion is not so much whether raw is faster or slower than a file
system, on which the jury is still out. The issue here is: with a file
system that does buffered I/O, am I free to choose any Oracle block size I
like? (nope). Can I achieve performance gains by adopting multiple
blocksizes within the one database? (nope).

That's a completely different discussion than the one you seem to want to
start.

Regards
HJR
--
-------------------------------------------
Dizwell Informatics: http://www.yqcomputer.com/
-A mine of useful Oracle information-
-Windows Laptop Rac-
-Oracle Installations on Linux-
===========================================

 
 
 

Enable 32K Block in 8K Block DB

Post by Paul Watso » Wed, 07 Apr 2004 16:42:03

[cutting]

I'd disagree, the jury is in, all things being equal raw is faster. But
all things are not equal :-)) so the debate goes on


--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #
 
 
 

Enable 32K Block in 8K Block DB

Post by McCabe-Ree » Thu, 08 Apr 2004 05:02:15


I have yet to meet an Oracle Rep. who doesn't still insist that cooked files
are better than raw.

-----Original Message-----
From: Howard J. Rogers [mailto: XXXX@XXXXX.COM ]
Sent: Monday, April 05, 2004 8:56 PM
To: XXXX@XXXXX.COM
Subject: Re: Enable 32K Block in 8K Block DB







are


The discussion is not so much whether raw is faster or slower than a file
system, on which the jury is still out. The issue here is: with a file
system that does buffered I/O, am I free to choose any Oracle block size I
like? (nope). Can I achieve performance gains by adopting multiple
blocksizes within the one database? (nope).

That's a completely different discussion than the one you seem to want to
start.

Regards
HJR
--
-------------------------------------------
Dizwell Informatics: http://www.yqcomputer.com/
-A mine of useful Oracle information-
-Windows Laptop Rac-
-Oracle Installations on Linux-
===========================================

sending to informix-list
 
 
 

Enable 32K Block in 8K Block DB

Post by McCabe-Ree » Thu, 08 Apr 2004 05:02:15


I have yet to meet an Oracle Rep. who doesn't still insist that cooked files
are better than raw.

-----Original Message-----
From: Howard J. Rogers [mailto: XXXX@XXXXX.COM ]
Sent: Monday, April 05, 2004 8:56 PM
To: XXXX@XXXXX.COM
Subject: Re: Enable 32K Block in 8K Block DB







are


The discussion is not so much whether raw is faster or slower than a file
system, on which the jury is still out. The issue here is: with a file
system that does buffered I/O, am I free to choose any Oracle block size I
like? (nope). Can I achieve performance gains by adopting multiple
blocksizes within the one database? (nope).

That's a completely different discussion than the one you seem to want to
start.

Regards
HJR
--
-------------------------------------------
Dizwell Informatics: http://www.yqcomputer.com/
-A mine of useful Oracle information-
-Windows Laptop Rac-
-Oracle Installations on Linux-
===========================================

sending to informix-list
sending to informix-list
 
 
 

Enable 32K Block in 8K Block DB

Post by McCabe-Ree » Thu, 08 Apr 2004 05:02:15


I have yet to meet an Oracle Rep. who doesn't still insist that cooked files
are better than raw.

-----Original Message-----
From: Howard J. Rogers [mailto: XXXX@XXXXX.COM ]
Sent: Monday, April 05, 2004 8:56 PM
To: XXXX@XXXXX.COM
Subject: Re: Enable 32K Block in 8K Block DB







are


The discussion is not so much whether raw is faster or slower than a file
system, on which the jury is still out. The issue here is: with a file
system that does buffered I/O, am I free to choose any Oracle block size I
like? (nope). Can I achieve performance gains by adopting multiple
blocksizes within the one database? (nope).

That's a completely different discussion than the one you seem to want to
start.

Regards
HJR
--
-------------------------------------------
Dizwell Informatics: http://www.yqcomputer.com/
-A mine of useful Oracle information-
-Windows Laptop Rac-
-Oracle Installations on Linux-
===========================================

sending to informix-list
sending to informix-list
sending to informix-list
 
 
 

Enable 32K Block in 8K Block DB

Post by McCabe-Ree » Thu, 08 Apr 2004 05:02:15


I have yet to meet an Oracle Rep. who doesn't still insist that cooked files
are better than raw.

-----Original Message-----
From: Howard J. Rogers [mailto: XXXX@XXXXX.COM ]
Sent: Monday, April 05, 2004 8:56 PM
To: XXXX@XXXXX.COM
Subject: Re: Enable 32K Block in 8K Block DB







are


The discussion is not so much whether raw is faster or slower than a file
system, on which the jury is still out. The issue here is: with a file
system that does buffered I/O, am I free to choose any Oracle block size I
like? (nope). Can I achieve performance gains by adopting multiple
blocksizes within the one database? (nope).

That's a completely different discussion than the one you seem to want to
start.

Regards
HJR
--
-------------------------------------------
Dizwell Informatics: http://www.yqcomputer.com/
-A mine of useful Oracle information-
-Windows Laptop Rac-
-Oracle Installations on Linux-
===========================================

sending to informix-list
sending to informix-list
sending to informix-list
sending to informix-list
 
 
 

Enable 32K Block in 8K Block DB

Post by JEDIDIA » Wed, 21 Apr 2004 06:27:34

["Followup-To:" header set to comp.databases.oracle.server.]


It's not at obvious that the claimed speed increase associated with
raw devices in Oracle is significant enough to warrant the use of
raw devices. So, in that respect the jury is infact still out.

Choice of hardware also effects the results. This can be particularly
stark with other engines. The best that can be claimed is an
indefinite maybe.

[deletia]

--
The public has a right to free music. It's part of the bargain that
was originally made with musicians and publishers. It's time that the |||
debate was shifted to reflect that. Robber Barons and their Toadies / | \
are distracting us from the original facts of the situation.