Skip to Content
avatar image
Former Member

Tablespace datafiles in multiple filesystems

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 25, 2014 at 10:55 AM

    Hello

    There is no problem in extending a tablespace with additional datafiles across multiple /oracle/SID/sapdataX filessystems. As long as there is space in the sapdataX filesystems then you can add data files.

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 26, 2014 at 07:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 26, 2014 at 09:10 PM

    Hi Salesh,

    Have Different data files of a tablespace in different in File Systems is common practise, There is no harm at all..

    You can perfectly use it.

    Regards,

    Shivam

    Add comment
    10|10000 characters needed characters exceeded