The thing I've found to be the most beneficial is to just ensure you
have a single file on a single device (be it for db, log, or stg). If
that device is a 4.5GB drive make the file as large as you can (about
4.0-4.2 GB) If the device is 9GB make the file 9GB, if it is 2GB make
it 2GB...
ADSM seems to balance its work across defined volumes. What I've seen
in the past is...Ex. if you have two physical devices holding three
adsm volumes, one with a single adsm volume on it and the other with
two adsm volumes on it, you will see one of those devices get 1/3 the
work and the other device get 2/3 the work... each logical adsm volume
will get equal work.
later,
Dwight
______________________________ Reply Separator _________________________________
Subject: Number of database volumes.
Author: carl (carl AT XENA.AIPO.GOV DOT AU) at unix,mime
Date: 1/17/99 10:11 PM
We currently have 19 database "volumes" made up of a mixture of 500Mb, 1Gb
and 2Gb files totalling 13,800 Mb.
Would it be faster to consolidate into a smaller number of larger files?
Cache hit percentage is currently 99.34%.
Carl.
|