Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: logical volumes/filesystems for db's on AIX
I tend to split off my large tables (10G+) into separate LV's, just to
make them easier to maintain and move around to get more balanced I/O.
To be honest, with IBM SSA drives starting at a minimum of 4.5G in
size, either approach would work on jfs. It's just that if you
allocate all the space to a big jfs up front you don't leave yourself
with many options...
I tend to use raw LV's on AIX, all of 1G size to make things simpler to manage. Large LV's make me nervous when it comes to backup/restore/reallocation.
MotoX.
On Tue, 15 Dec 1998 09:16:33 -0600, Susan Malisch <susan.malisch_at_ctp.com> wrote:
>We are installing a large Oracle 7.3.4 implementation on AIX 4.3. If we
>have some tables that are going to be 5 - 10 gb in size, we're wondering
>if it's more beneficial to configure 2-4 logical volumes so that we can
>then mount the filesystems as multiple pieces? Or is it better to
>create one huge filesystem to accommodate the tables/groups of tables?
>We plan to stripe data across disks and mirror the data in a HACMP
>cascading configuration.
>
>I appreciate any insights on this. Please send any replies to me
>directly at smalis02_at_ctp.com as well as posting the reply so that I
>don't miss them.
>Thanks,
>Susan
Received on Tue Dec 15 1998 - 14:38:47 CST