Linux performance for LVM vs independent partition on 10G XE?
9073Jan 3 2006 — edited Jan 3 2006Hi groups,
I am a programmer and now requested to evaluate using Oracle 10G XE to replace MySQL for some of running web application. I remember the old experience that when playing with oracle 8i with linux, the guideline said that datafile of oracle should be placed at a independent partition. I m now testing XE with SUSE Enterprise 9, which using LVM(logical volume management).
So far there's not seen guideline that talking about if 10G XE should using dependent partition. And the case is that SUSE using LVM that application see multiple physical partitions as one logicial partition. This is totally an opposite to what Oracle intended for using independent partition. I would like is that the 4GB datafile limit make this not a concern?
I m not a DBA, thus hoping some gurus can give me some advise. Thanks!