Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: 9i-OCP Question

Re: Re: 9i-OCP Question

From: <rgaffuri_at_cox.net>
Date: Wed, 30 Jul 2003 12:39:30 -0800
Message-ID: <F001.005C7E2A.20030730123930@fatcity.com>


yeah that might be the right answer, but you would get it wrong on the OCP... assuming the books are right.
>
> From: Peter Gram <peter.gram_at_miracleas.dk>
> Date: 2003/07/30 Wed PM 04:09:28 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.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).
Received on Wed Jul 30 2003 - 15:39:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US