RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mohan, Ross
Ed, Ever since ZBR, the need to use the outside of the disk ( to reduce seeks ) is significantly reduced. Ross -Original Message- To: Multiple recipients of list ORACLE-L Sent: 4/24/2001 12:00 AM Dick, Thanks! SAME also suggests using the outer half of each disk for data

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mark Leith
Care to elaborate on ZBR for those of us with enquiring minds and absolutely no idea what you are on about :) Cheers Mark -Original Message- Sent: Tuesday, April 24, 2001 01:56 To: Multiple recipients of list ORACLE-L Ed, Ever since ZBR, the need to use the outside of the disk ( to

Re: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Nuno Souto
- Original Message - Ever since ZBR, the need to use the outside of the disk ( to reduce seeks ) is significantly reduced. PMFJI. The reason for using the outside of the disk is the increased linear velocity there re the heads. Larger circle, same angular velocity, larger

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Haskins, Ed
Here's some info I was able to dig up! Ed Haskins Oracle DBA Verizon Wireless Zoned Bit Recording One way that capacity and speed have been improved on hard disks over time is by improving the utilization of the larger, outer tracks of the disk. The first hard disks were rather primitive

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Tim Sawmiller
- || From: Mark Leith [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, April 24, 2001 10:36 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: HYPER VOLUMES - RE: Never split index and data || files ... || || || Care to elaborate on ZBR for those of us with enquiring || minds

OT RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mohan, Ross
Title: OT RE: HYPER VOLUMES - RE: Never split index and data files ... Zymurgy Beats Recidivism? || -Original Message- || From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, April 24, 2001 11:51 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: HYPER

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mohan, Ross
|| Subject: RE: HYPER VOLUMES - RE: Never split index and data || files ... || || || Thank you for the very informative and detailed explanation. || || [EMAIL PROTECTED] 04/24/01 12:51PM || Oops, I guess I was just too obtuse and brief. Sorry 'bout that! || || Here is an amplification

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mark Leith
(Oracle Certified DBA) -Original Message- From: Mark Leith [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Subject:RE: HYPER VOLUMES - RE: Never split index and data files

RE: HYPER VOLUMES - RE: Never split index and data files ...

2001-04-24 Thread Mohan, Ross
|| -Original Message- || From: Tim Sawmiller [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, April 24, 2001 1:05 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: HYPER VOLUMES - RE: Never split index and data || files ... || || || Ok, enlighten me...an outside track holds the same amount

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

HYPER VOLUMES - RE: Never split index and data files ...

2001-04-23 Thread Ed . Haskins
Dick, Thanks! SAME also suggests using the outer half of each disk for data storage...as I/O performance is increased due to the natural circular shape of the platter. My question...how do you specify which sections of each disk are utilized? From what I've been able to read, I'm guessing

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: Never split index and data files ...

2001-04-20 Thread Steve Adams
ROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: "Never split index and data files ..." Date: Thu, 19 Apr 2001 23:25:25 -0800 Hi All, The author (Anjo Kolk) is an advocate of SAME (stripe and mirror everything). The SAME philosophy

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: Never split index and data files ...

2001-04-20 Thread Boivin, Patrice J
] -Original Message- From: Steve Adams [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 20, 2001 10:42 AM To: Multiple recipients of list ORACLE-L Subject:RE: "Never split index and data files ..." Hi Allan, Thanks for that

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: RE: Never split index and data files ...

2001-04-20 Thread dgoulet
ED, Damn good question! No I won't take it as sarcastic at all. Now to your point: We had to implement this particular strategy about 4 years ago due to the vendor we bought a disk array from (IPL). They were somewhat ahead of the curve here. Simple theory, they configured the 30GB

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