Re: 9i-OCP Question

Hi

I don't want to create a fight, but in a configuration with 2 groups and 4 members you need 8 disks :

1 disk for every member.

When the db is writing to one group the archiver will be reading from the other group, by the
why since there are multibe members in the group the db (archiver) will read 64 Kb chunks
from the each member and there by distribute the IO

That's my 2 cent's of knowledge, comment and correction are welcome :-)

Mladen Gogala wrote:

> There are two reasons:
> 1) Redo log groups are never used simultaneously, so they can reside on
> the same disk. Log members should not be on the same disks for
> increased
> survivability. That gives us 2 groups with 4 members, each two members
> sharing the same device - 4 disks alltogether.
> 2) It's because I say so and I'm an 8i OCP.
>
>
> On 2003.07.30 13:44, KENNETH JANUSZ wrote:
>
>> Why? What is the logic?
>>
>> Ken Janusz, CPIM
>>
>> ----- Original Message -----
>> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>> Sent: Wednesday, July 30, 2003 12:29 PM
>>
>>
>> > The answer is 4. Of course, no one in the right mind would have
>> > 2 groups with 4 members each.
>> >
>> > On 2003.07.30 13:19, Senthil Kumar wrote:
>> > > Hi all,
>> > >
>> > > What is the correct answer for this?
>> > >
>> > > Q> If you have 2 redo log groups with 4 members each, how many disks
>> does
>> > > Oracle recommend
>> > > to keep the redo log files?
>> > >
>> > > 1. 8
>> > > 2. 2
>> > > 3. 1
>> > > 4. 4
>> > >
>> > > Which is the correct answer.
>> > >
>> > > TIA
>> > > Senthil
>> > >
>> > > --
>> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > > --
>> > > Author: Senthil Kumar
>> > > INET: senthilkumard_at_summitworks.com
>> > >
>> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> > > San Diego, California -- Mailing list and web hosting
>> services
>> > >
>> ---------------------------------------------------------------------
>> > > To REMOVE yourself from this mailing list, send an E-Mail message
>> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> > > the message BODY, include a line containing: UNSUB ORACLE-L
>> > > (or the name of mailing list you want to be removed from). You may
>> > > also send the HELP command for other information (like subscribing).
>> > >
>> >
>> > --
>> > Mladen Gogala
>> > Oracle DBA
>> > --
>> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> > --
>> > Author: Mladen Gogala
>> > INET: mgogala_at_adelphia.net
>> >
>> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> > San Diego, California -- Mailing list and web hosting services
>> > ---------------------------------------------------------------------
>> > To REMOVE yourself from this mailing list, send an E-Mail message
>> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> > the message BODY, include a line containing: UNSUB ORACLE-L
>> > (or the name of mailing list you want to be removed from). You may
>> > also send the HELP command for other information (like subscribing).
>> >
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: KENNETH JANUSZ
>> INET: kjanusz_at_att.net
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>

-- 
Peter Gram, Miracle A/S
Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696
mail  : peter.gram@MiracleAS.dk - http://MiracleAS.dk



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).