RE: RE: Never split index and data files ...

2001-04-23 Thread Haskins, Ed
Steve, Thanks for sharing your experiences! Quick question: In the end, once the new hardware was purchased and properly setup, how was the performance of the DB and backup? Were you able to meet the requirement of the 3 hour backup window? Ed Haskins Oracle DBA Verizon Wireless

RE: RE: Never split index and data files ...

2001-04-22 Thread Mohan, Ross
. There's nothing like having enough disk and I.O. :) == -Original Message- == From: Mohan, Ross == Sent: Friday, April 20, 2001 1:17 PM == To: '[EMAIL PROTECTED]' == Subject: RE: RE: Never split index and data files ... == == == Long ago in a galaxy, far far away, I did == a semi

RE: RE: Never split index and data files ...

2001-04-20 Thread Haskins, Ed
Dick, Don't take this the wrong way...it's NOT meant to be sarcastic: You said "SAME is a great theory, but I can't and haven't seen it perform well in practice, yet." My question to you: Have you seen it in practice at all? An actual working implementation? For that matter; has ANYONE seen

RE: RE: Never split index and data files ...

2001-04-20 Thread Mohan, Ross
s == Sent: Friday, April 20, 2001 1:17 PM == To: '[EMAIL PROTECTED]' == Subject: RE: RE: "Never split index and data files ..." == == == Long ago in a galaxy, far far away, I did == a semi-SAME thing on a Sequent box. Everything -- Please see the official ORACLE-L FAQ: ht

RE: RE: Never split index and data files ...

2001-04-20 Thread Mohan, Ross
Title: RE: RE: Never split index and data files ... Long ago in a galaxy, far far away, I did a semi-SAME thing on a Sequent box. Everything but logsfour controllers, each with full four-channel fastwide SCSI. Software raid0+1 (not 1+0). Stripe width 128Kblocks, 64Kbytes. Worked like

RE: RE: Never split index and data files ...

2001-04-20 Thread Steve Adams
Hi Ed and list, Most of my bad experiences with SAME have been related to adding disk capacity, rather than its performance which is normally OK. The first time I hit it was about 5 years ago when someone had configured the 30 4G drives as a single striped and mirrored volume 15 disks wide, and