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: [EMAIL PROTECTED] -----Original Message----- From: Ilja G. Coolen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 8:58 AM To: [EMAIL PROTECTED] Subject: OFF TOPIC: Oracle DB on ESS. Sorry for this off topic question, but i need a helping hand, and i know you are all the best in the storage business. We are about to put some big Oracle instances on one of our ESS boxes, and we are wondering what the best configuration is, because we are used to split indexes and data, also log and rollback, and place them on separate disks physically to get a better performance. I know this is not required on an ESS box, but i'd like to know if there is anyone of you who has gone through this before. If you have any reference i could use, it would be greatly appreciated. The main question is: Continue splitting data/index/log/rollback/temp and place them on different 8packs, or go a completely different way and put it all together on one or more 8packs? Thanks in advance. Ilja G. Coolen _____ ABP / USZO CIS / BS / TB / Storage Management Telefoon : +31(0)45 579 7938 Fax : +31(0)45 579 3990 Email : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Intranet : Storage <http://intranet/cis_bstb/html_content/sm/index_sm.htm> Web _____ - Everybody has a photographic memory, some just don't have film. -