[linux-lvm] LVM, raw-io, devfs

[Adrien Farkas]

Fernando Dammous (ferdam at internetcom.com.br) wrote :

> Hi (again!),
> 
> From: Adrien Farkas <freddy at redneck.sk.oracle.com>
> > Forget it, Linux port of Oracle DB doesn't support raw-io.
> 
> I admit that I'm not a deep expert of Oracle, mainly regarding interaction
> with the I/O devices and with the operating system.
> 
> However, I have been finding in the documentation of Oracle for Linux,
> several references of utilization of RAW-DEVICES (among others).
> I'm not, here, wanting to create controversy, because it is dealt with a
> matter extra-LVM and being you a member of Oracle (I saw for your e-mail
> address freddy at sk.oracle.com), you must have knowledge of this subject. Then
> I ask:
>  What does mean the references about RAW-DEVICES in documentation?
> To illustrate, I separated some from :
> 
> Oracle8 Administrator's Reference for LINUX
> Release 8.0.5
> A66585-01

Oh, I'm sorry, Linux port of Oracle _does_ support raw io, but it depends on Oracle8 release, 8.0.5 does not, 8.0.5.1 (not released for public for free, afaik) and 8i (aka 8.1.5) both do. But definitely, I've never tried it. The last time I was interested in using raw partitions was in the time of 8.0.5, so prehaps that's why I still thought Oracle doesn't support them.

> <SNIP>
> - Tuning of I/O Loads across all Drives
> I/O loads are tuned across all drives, including drives storing Oracle data
> in raw devices
> <SNIP>
> - Raw Device Sizes
> Choose a small set of standard sizes for all raw devices that may be used to
> store Oracle database files.
> 
> In general, standardizing on a single size is recommended. If a single size
> is used, raw files can be moved from one partition to another safely. The
> size should be small enough so that a fairly large number can be created,
> but large enough to be convenient.
> 
> For example, a 2 GB drive could be divided into 10 partitions of 200 MB
> each-a good balance between size and number. Any tablespace using raw
> devices should stripe them across several drives. If possible, the striping
> should be done with a Logical Volume Manager."
> <SNIP>
> - Tuning the LINUX Buffer Cache Size
> To take full advantage of raw devices, adjust the size of the Oracle8 buffer
> cache and, if memory is limited, the LINUX buffer cache.
> 
> The LINUX buffer cache is provided by the operating system. It holds blocks
> of data in memory while they are being transferred from memory to disk, or
> vice versa.
> 
> The Oracle8 buffer cache is the area in memory that stores the Oracle
> database buffers. Since Oracle8 can use raw devices, it does not need to use
> the LINUX buffer cache.
> 
> When moving to raw devices, increase the size of the Oracle8 buffer cache.
> If the amount of memory on the system is limited, make a corresponding
> decrease in the LINUX buffer cache size.
> 
> The LINUX command vmstat may help you determine which buffer caches should
> be increased or decreased.
> <SNIP>
> ------------------------
> 
> Cheers and sorry for the long mail!
> Fernando
> 

-- 
                                             freddy

----==-- _                      Adrien "freddy" Farkas
---==---(_)__  __ ____  __       freddy at sk.oracle.com
--==---/ / _ \/ // /\ \/ /  We all know Linux is great... It
-=====/_/_//_/\___/ /_/\_\  does infinite loops in 5 seconds