ADSM-L

Re: OFF TOPIC: Oracle DB on ESS.

2002-03-04 14:08:20
Subject: Re: OFF TOPIC: Oracle DB on ESS.
From: "Davidson, Becky" <Becky.Davidson AT SLBG DOT COM>
Date: Mon, 4 Mar 2002 13:05:13 -0600
What we did was put the indexes, data, log, and rollback in their own
filesystems.  We then determined what were the hot datafiles and indexes.
From that we determined the disk sizes.  We used 10.5 for our large
filesystems, 5.3 for medium size, and 1.5 for hot small.  We then spread the
filesystems across as many arrays as possible trying to keep from putting 2
disks from the same filesystem on the same array if we could.  We saw an
incredible boost in performance on writes and a good increase on reads.  We
have discovered that when a filesystem becomes over 100 GB that we start to
have some I/O problems.  I did a presentation on what we did at the Storage
Symposium and if you want could send you that presentation offline.

Becky Davidson
Data Manager/AIX Administrator
EDS/Sara Lee Bakery Group
voice: 314-259-7589
fax: 314-877-8589
email: becky.davidson AT slbg DOT com



<Prev in Thread] Current Thread [Next in Thread>