Tablespace datafiles in multiple filesystems

[#1]

Hello,

I'll try to keep my first discussion/question as brief as possilbe,

One of our ext4 filesystems (RHEL 6.2) that houses a near-max-size tablespace (Oracle 11g) is exhausted, expanding it is a viable option, however that raised a question in my head, what would be the implications of extending this tablespace with a datafile that would reside on a different filesystem, i.e. different /sapdata# filesystem? As far as my little knowledge goes, it's doable, however wanted to know if there could be any downsides.

Best regards

[janos_mucsi-besze]

Hi Saleh,

No, there is no problem at all. It is a common practice to spread the datafiles accross several disks, so the I/O load is distributed through several physical disks.

I have a small tip. Maybe you know this already, but using LVM (Logical Volume Manager) is kind of handy, so you can dynamically extend disk groups with logical volumes. It makes the administration easier. More information can be found e.g. in Red Hat documentation. LVM is also available for Oracle Linux.

Regards,

János