Hi,
I am still looking for experiences on Oracle databases over LSM +
ADVFS. Below are some worries on the best way to setup a new
system, before installing Oracle.
I plan to dedicate 2x3 RZ28 disks for Oracle data + indexes . Each set of
3 disks is mirrored (soft via LSM) onto a separate BA350 cabinet
Another set of 2x2 disks will be dedicated to Oracle structures like
redologs, rollback segments, ...
I plan to make use of ADVFS, because this brings usefull tools (like
clonefsets for very fast backups, defragmentation, online volume
extension ,...). I have the feeling that using Advfs instead of raw devices
will slow down performances (compared to raw devices), but this
should be (at least) balanced by the fact I will stripe each plex over the
three disks. I decided to (mirror +) stripe ( Raid 0+1 soft) when I saw that
Oracle made use of datafiles sequentially, that is filling up the first
allocated datafile before going to the second one.
My questions are :
a/ do I setup LSM volumes with gen or fsgen usage type ? LSM
documentation only recommends fsgen if you plan to install a file system
over the volume. This does not really help me.
b/ what would be a suited stripe width (adapted to Oracle behavior).
Have not been able to get recommendations neither from DEC nor from
Oracle
Any expertise on this topic will be appreciated
Jean-Claude PETIOT
Agence Internationale de l'Energie - PARIS
jean-claude.petiot_at_iea.fr
Received on Thu Jan 11 1996 - 19:13:05 NZDT