Re: 9i-OCP Question

[Mladen Gogala]

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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[Kirtikumar Deshpande]

I will guess -- 1. 


- Kirti



--- Senthil Kumar <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[KENNETH JANUSZ]

Why?  What is the logic?

Ken Janusz, CPIM

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[rgaffuri]

according to the 8i osborne ocp book, the answer is 2. 
> 
> From: "Senthil Kumar" <[EMAIL PROTECTED]>
> Date: 2003/07/30 Wed PM 01:19:31 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: 9i-OCP Question
> 
> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[Mladen Gogala]

So, what do you need us for?



On 2003.07.30 13:29, [EMAIL PROTECTED] wrote:
according to the 8i osborne ocp book, the answer is 2.
>
> From: "Senthil Kumar" <[EMAIL PROTECTED]>
> Date: 2003/07/30 Wed PM 01:19:31 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: 9i-OCP Question
>
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[AK]

Answe is 4 disks . to keep each member on different disks . 

-ak



- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 30, 2003 10:19 AM


> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: AK
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Orr, Steve]

Nah, the answer is 42. :-)

-Original Message-
Sent: Wednesday, July 30, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L


I will guess -- 1. 


- Kirti



--- Senthil Kumar <[EMAIL PROTECTED]> 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 
> Q> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Orr, Steve
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[Mladen Gogala]

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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[April Wells]

Title: RE: 9i-OCP Question





"depends"
... that answer usually works


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas


Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Kirtikumar Deshpande [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 30, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: 9i-OCP Question



I will guess -- 1. 



- Kirti




--- Senthil Kumar <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).



__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: 9i-OCP Question

[Pardee, Roy E]

I thought you need to preserve the groups, not (necessarily) the members.

If you have each group on its own disk then if one disk goes, you've got a complete 
set of logs on the other.  Or am I not thinking about this correctly?

Cheers,

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, July 30, 2003 11:10 AM
To: Multiple recipients of list ORACLE-L


Answe is 4 disks . to keep each member on different disks . 

-ak



- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 30, 2003 10:19 AM


> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: AK
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Pardee, Roy E
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Ramon E. Estevez]

I would say 4.

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994



-Original Message-
Senthil Kumar
Sent: Wednesday, July 30, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L


Hi all,

What is the correct answer for this?

Q> If you have 2 redo log groups with 4 members each, how many disks 
Q> 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Ramon E. Estevez
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Kirtikumar Deshpande]

Right, You Are!! :) 
That's how I arrived at my answer 1. - 8 disks  ;) 

- Kirti 

--- "Orr, Steve" <[EMAIL PROTECTED]> wrote:
> Nah, the answer is 42. :-)
> 
> -Original Message-
> Sent: Wednesday, July 30, 2003 11:39 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I will guess -- 1. 
> 
> 
> - Kirti
> 
> 
> 
> --- Senthil Kumar <[EMAIL PROTECTED]> 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 
> > Q> 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
> > 

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[AK]

In that case you dont need more then 1 member per group . :)

-ak

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 30, 2003 12:14 PM


> I thought you need to preserve the groups, not (necessarily) the members.
>
> If you have each group on its own disk then if one disk goes, you've got a
complete set of logs on the other.  Or am I not thinking about this
correctly?
>
> Cheers,
>
> -Roy
>
> Roy Pardee
> Programmer/Analyst/DBA
> SWFPAC Lockheed Martin IT
> Extension 8487
>
> -Original Message-
> Sent: Wednesday, July 30, 2003 11:10 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Answe is 4 disks . to keep each member on different disks .
>
> -ak
>
>
>
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 30, 2003 10:19 AM
>
>
> > 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: AK
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: Pardee, Roy E
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: AK
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[Peter Gram]

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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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  : [EMAIL PROTECTED] - http://MiracleAS.dk


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Peter Gram
 INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[Mladen Gogala]

That would be the most optimal. I believe that the original question was about 
OFA. And I also believe that the "middle of the road" configuration would have
4 disks.
On 2003.07.30 16:09, Peter Gram wrote:
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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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  : [EMAIL PROTECTED] - http://MiracleAS.dk


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Peter Gram
 INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (note EXACT spelling

RE: 9i-OCP Question

[Gudmundur Bjarni Josepsson]

Roy,

I think you've got this backwards.  To preserve the groups you need to
preserve the members and thus you would multiplex the members.  

If you multiplex the 4 members of the 2 groups over 4 disks you will
minimize the risk of failure.  If you lose one disk you still have three
members left in each group so you can have up to 3 disks fail without
the instance stopping.

With 2 groups, if you put all the members of a group on a single disk
and you lose that disk you have lost the whole group and the instance
will fail instantly or at the next log switch (depending on whether it
was the current group or not).

Gudmundur

> I thought you need to preserve the groups, not (necessarily) 
> the members.
> 
> If you have each group on its own disk then if one disk goes, 
> you've got a complete set of logs on the other.  Or am I not 
> thinking about this correctly?
> 
> Cheers,
> 
> -Roy
> 
> Roy Pardee
> Programmer/Analyst/DBA
> SWFPAC Lockheed Martin IT
> Extension 8487
> 
> -Original Message-
> Sent: Wednesday, July 30, 2003 11:10 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Answe is 4 disks . to keep each member on different disks . 
> 
> -ak
> 
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 30, 2003 10:19 AM
> 
> 
> > Hi all,
> > 
> > What is the correct answer for this?
> > 
> > Q> If you have 2 redo log groups with 4 members each, how 
> many disks 
> > Q> 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: [EMAIL PROTECTED]
> > 
> > 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: [EMAIL PROTECTED] (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: AK
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: Pardee, Roy E
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: Gudmundur Bjarni Josepsson
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Igor Neyman]

Well, in archivelog mode LogWriter may use one group and Archiver may
use the other group, so I'd agree with Kirti.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-Original Message-
Mladen Gogala
Sent: Wednesday, July 30, 2003 12:59 PM
To: Multiple recipients of list ORACLE-L

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" <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Igor Neyman
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Pardee, Roy E]

Yep, that's right--I had it wrong.  You need to have at least one member from each 
group in order to do a full recovery.  I see now from my trusty dba fundamentals I 
class text that each member of a group is identical (or is supposed to be).

So I guess I'll go back to being confused about why the answer to the question below 
is 2.  I guess 2 is the minimum required to survive a single disk failure?

Cheers,

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, July 30, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L


dont know from experience, since I dont handle backups and redo, but according to the 
books, you are multiplexing your redo log groups. so if one of the files gets 
corrupted, etc... you have exact duplicates on different storage devices. 

So if you put all the members on the same storage device and you move onto the the 
next redo log group and then that storage device goes bad, you lose all the redo. 

now lets say you are in archive log mode and your archive log hasnt kept up... and was 
still archiving data. you cant recover from that point in time. 

please correct me if Im wrong. Im half responding to make sure I understand it 
correctly. 
> 
> From: "Pardee, Roy E" <[EMAIL PROTECTED]>
> Date: 2003/07/30 Wed PM 03:14:30 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: 9i-OCP Question
> 
> I thought you need to preserve the groups, not (necessarily) the members.
> 
> If you have each group on its own disk then if one disk goes, you've got a complete 
> set of logs on the other.  Or am I not thinking about this correctly?
> 
> Cheers,
> 
> -Roy
> 
> Roy Pardee
> Programmer/Analyst/DBA
> SWFPAC Lockheed Martin IT
> Extension 8487
> 
> -Original Message-
> Sent: Wednesday, July 30, 2003 11:10 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Answe is 4 disks . to keep each member on different disks . 
> 
> -ak
> 
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 30, 2003 10:19 AM
> 
> 
> > 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: [EMAIL PROTECTED]
> > 
> > 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: [EMAIL PROTECTED] (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: AK
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: Pardee, Roy E
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).
> 

RE: 9i-OCP Question

[Josh Collier]

I believe the answer is 2 because you need to multiplex each group member
and you need a minimum of two spindles to do this. 

You can't begin to reuse a redo log until it has finished archiving,
therefore, you need to put your archive logs on DISK 3 in order to prevent
your ARCH and Log Writer processes from competing. At least that is how I
think about things. 

group A
log 1a DISK 1
log 1b DISK 2
log 2a DISK 1
log 2b DISK 2
log 3a DISK 1
log 3b DISK 2
log 4a DISK 1
log 4b DISK 2


group B
log 1a DISK 1
log 1b DISK 2
log 2a DISK 1
log 2b DISK 2
log 3a DISK 1
log 3b DISK 2
log 4a DISK 1
log 4b DISK 2

That way if you loose one disk, you can still recover your redo via the
remaining log. 

Josh

-Original Message-
Sent: Wednesday, July 30, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L


Yep, that's right--I had it wrong.  You need to have at least one member
from each group in order to do a full recovery.  I see now from my trusty
dba fundamentals I class text that each member of a group is identical (or
is supposed to be).

So I guess I'll go back to being confused about why the answer to the
question below is 2.  I guess 2 is the minimum required to survive a single
disk failure?

Cheers,

-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Wednesday, July 30, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L


dont know from experience, since I dont handle backups and redo, but
according to the books, you are multiplexing your redo log groups. so if one
of the files gets corrupted, etc... you have exact duplicates on different
storage devices. 

So if you put all the members on the same storage device and you move onto
the the next redo log group and then that storage device goes bad, you lose
all the redo. 

now lets say you are in archive log mode and your archive log hasnt kept
up... and was still archiving data. you cant recover from that point in
time. 

please correct me if Im wrong. Im half responding to make sure I understand
it correctly. 
> 
> From: "Pardee, Roy E" <[EMAIL PROTECTED]>
> Date: 2003/07/30 Wed PM 03:14:30 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: 9i-OCP Question
> 
> I thought you need to preserve the groups, not (necessarily) the members.
> 
> If you have each group on its own disk then if one disk goes, you've got a
complete set of logs on the other.  Or am I not thinking about this
correctly?
> 
> Cheers,
> 
> -Roy
> 
> Roy Pardee
> Programmer/Analyst/DBA
> SWFPAC Lockheed Martin IT
> Extension 8487
> 
> -Original Message-
> Sent: Wednesday, July 30, 2003 11:10 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Answe is 4 disks . to keep each member on different disks . 
> 
> -ak
> 
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 30, 2003 10:19 AM
> 
> 
> > 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: [EMAIL PROTECTED]
> > 
> > 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: [EMAIL PROTECTED] (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: AK
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the

RE: 9i-OCP Question

[Paul Baumgartel]

I'm constantly amazed (and relieved!) that there's disagreement on the
most fundamental principles.

First, I found myself nodding at Roy's first post.  On some databases,
I have three log groups, with two members each.  Each set of members
has its own disk.  I'll concede the argument that the instance goes
down right away if one of the drives fails, but I _still_ have a full
set of logs on the other drive, and that's a good thing, right?

Second, if I have three groups of two members each and follow what
seems to be the consensus opinion, I have three drives, each holding
two members, one from each group.  In this case, aren't the two members
on the same drive identical?  If I lose that drive, I lose that entire
log group, and therefore no longer have a full set of logs--so what's
the point of having two copies?  I also lose the instance immediately
if that group happens to be the current group at the time of disk
failure.

Third, while I agree that every member of every group should ideally
have its own disk, does ANYONE actually configure their DB this way?  I
had a hard enough time dedicating one or two disks to redo logs; who
can dedicate eight, especially given drive sizes of 72+ GB and (single)
log file sizes of, what, 100 MB?




--- "Pardee, Roy E" <[EMAIL PROTECTED]> wrote:
> Yep, that's right--I had it wrong.  You need to have at least one
> member from each group in order to do a full recovery.  I see now
> from my trusty dba fundamentals I class text that each member of a
> group is identical (or is supposed to be).
> 
> So I guess I'll go back to being confused about why the answer to the
> question below is 2.  I guess 2 is the minimum required to survive a
> single disk failure?
> 
> Cheers,
> 
> -Roy
> 
> Roy Pardee
> Programmer/Analyst/DBA
> SWFPAC Lockheed Martin IT
> Extension 8487


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[Tanel Poder]

Hi!

> First, I found myself nodding at Roy's first post.  On some databases,
> I have three log groups, with two members each.  Each set of members
> has its own disk.  I'll concede the argument that the instance goes
> down right away if one of the drives fails, but I _still_ have a full
> set of logs on the other drive, and that's a good thing, right?

The instance will keep working as long as it can successfully write to at
least one member of current log group.

> Third, while I agree that every member of every group should ideally
> have its own disk, does ANYONE actually configure their DB this way?  I
> had a hard enough time dedicating one or two disks to redo logs; who
> can dedicate eight, especially given drive sizes of 72+ GB and (single)
> log file sizes of, what, 100 MB?

Mirrored solid state disks are the answer, especially in SAN environments
where you can use these disks for several databases' logs. (Check James
Morle's articles @ www.oaktable.net)

Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Jacques Kilchoer]

> -Original Message-
> From: Senthil Kumar [mailto:[EMAIL PROTECTED]
> 
> 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

The question specifically says "how many disks does Oracle recommend...?"
It seems to me that the correct answer is answer number 4, Oracle recommends 4 disks. 
(Quote: "When setting up a multiplexed online redo log, place members of a group on 
different disks. If a single disk fails, then ONLY ONE MEMBER of a group becomes 
unavailable..." - capitalization mine)
Therefore 4 members -> 4 disks.

Here is a link to a relevant section from an Oracle manual.

Oracle9i Database Administrator's Guide, Release 2 (9.2), Part Number A96521-01 
Chapter 7 - Managing the Online Redo Log: Placing Online Redo Log Members on Different 
Disks 

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/onlineredo.htm#5414

"Placing Online Redo Log Members on Different Disks
When setting up a multiplexed online redo log, place members of a group on different 
disks. If a single disk fails, then only one member of a group becomes unavailable to 
LGWR and other members remain accessible to LGWR, so the instance can continue to 
function.

If you archive the redo log, spread online redo log members across disks to eliminate 
contention between the LGWR and ARCn background processes. For example, if you have 
two groups of duplexed online redo log members, place each member on a different disk 
and set your archiving destination to a fifth disk. Consequently, there is never 
contention between LGWR (writing to the members) and ARCn (reading the members)."

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Ukrit . K]

Hello,
        The answer is 2.
Ukrit K,
OCP Oracle 8i






"Jacques Kilchoer" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/31/2003 10:19 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: 9i-OCP Question


> -Original Message-
> From: Senthil Kumar [mailto:[EMAIL PROTECTED]
> 
> 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

The question specifically says "how many disks does Oracle recommend...?"
It seems to me that the correct answer is answer number 4, Oracle recommends 4 disks. (Quote: "When setting up a multiplexed online redo log, place members of a group on different disks. If a single disk fails, then ONLY ONE MEMBER of a group becomes unavailable..." - capitalization mine)
Therefore 4 members -> 4 disks.

Here is a link to a relevant section from an Oracle manual.

Oracle9i Database Administrator's Guide, Release 2 (9.2), Part Number A96521-01 
Chapter 7 - Managing the Online Redo Log: Placing Online Redo Log Members on Different Disks 

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/onlineredo.htm#5414

"Placing Online Redo Log Members on Different Disks
When setting up a multiplexed online redo log, place members of a group on different disks. If a single disk fails, then only one member of a group becomes unavailable to LGWR and other members remain accessible to LGWR, so the instance can continue to function.

If you archive the redo log, spread online redo log members across disks to eliminate contention between the LGWR and ARCn background processes. For example, if you have two groups of duplexed online redo log members, place each member on a different disk and set your archiving destination to a fifth disk. Consequently, there is never contention between LGWR (writing to the members) and ARCn (reading the members)."

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Ron Yount]

Well Who knows what the author of the question intended, but in the
example of 2 (duplexed) redo log groups with archiving, they speak of five
disks.  One of EACH log member (not shared with log members of another
group) and one for the archive log destination.

That being said, I believe the answer to the question is A: 8

Hth,
-Ron-

-Original Message-
Jacques Kilchoer
Sent: Wednesday, July 30, 2003 9:19 PM
To: Multiple recipients of list ORACLE-L


> -Original Message-
> From: Senthil Kumar [mailto:[EMAIL PROTECTED]
> 
> 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

The question specifically says "how many disks does Oracle recommend...?" It
seems to me that the correct answer is answer number 4, Oracle recommends 4
disks. (Quote: "When setting up a multiplexed online redo log, place members
of a group on different disks. If a single disk fails, then ONLY ONE MEMBER
of a group becomes unavailable..." - capitalization mine) Therefore 4
members -> 4 disks.

Here is a link to a relevant section from an Oracle manual.

Oracle9i Database Administrator's Guide, Release 2 (9.2), Part Number
A96521-01 
Chapter 7 - Managing the Online Redo Log: Placing Online Redo Log Members on
Different Disks 

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/onlinere
do.htm#5414

"Placing Online Redo Log Members on Different Disks
When setting up a multiplexed online redo log, place members of a group on
different disks. If a single disk fails, then only one member of a group
becomes unavailable to LGWR and other members remain accessible to LGWR, so
the instance can continue to function.

If you archive the redo log, spread online redo log members across disks to
eliminate contention between the LGWR and ARCn background processes. For
example, if you have two groups of duplexed online redo log members, place
each member on a different disk and set your archiving destination to a
fifth disk. Consequently, there is never contention between LGWR (writing to
the members) and ARCn (reading the members)."

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Ron Yount
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Ukrit . K]

Opps sorry,
        Need to be 4 disks the answer is 4
Ukrit K,






"Jacques Kilchoer" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/31/2003 10:19 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        RE: 9i-OCP Question


> -Original Message-
> From: Senthil Kumar [mailto:[EMAIL PROTECTED]
> 
> 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

The question specifically says "how many disks does Oracle recommend...?"
It seems to me that the correct answer is answer number 4, Oracle recommends 4 disks. (Quote: "When setting up a multiplexed online redo log, place members of a group on different disks. If a single disk fails, then ONLY ONE MEMBER of a group becomes unavailable..." - capitalization mine)
Therefore 4 members -> 4 disks.

Here is a link to a relevant section from an Oracle manual.

Oracle9i Database Administrator's Guide, Release 2 (9.2), Part Number A96521-01 
Chapter 7 - Managing the Online Redo Log: Placing Online Redo Log Members on Different Disks 

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/onlineredo.htm#5414

"Placing Online Redo Log Members on Different Disks
When setting up a multiplexed online redo log, place members of a group on different disks. If a single disk fails, then only one member of a group becomes unavailable to LGWR and other members remain accessible to LGWR, so the instance can continue to function.

If you archive the redo log, spread online redo log members across disks to eliminate contention between the LGWR and ARCn background processes. For example, if you have two groups of duplexed online redo log members, place each member on a different disk and set your archiving destination to a fifth disk. Consequently, there is never contention between LGWR (writing to the members) and ARCn (reading the members)."

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Boivin, Patrice J]

We use a SAN.

Where does that leave me?

: )

Patrice.

-Original Message-
Sent: Wednesday, July 30, 2003 7:10 PM
To: Multiple recipients of list ORACLE-L


I'm constantly amazed (and relieved!) that there's disagreement on the
most fundamental principles.

First, I found myself nodding at Roy's first post.  On some databases,
I have three log groups, with two members each.  Each set of members
has its own disk.  I'll concede the argument that the instance goes
down right away if one of the drives fails, but I _still_ have a full
set of logs on the other drive, and that's a good thing, right?

Second, if I have three groups of two members each and follow what
seems to be the consensus opinion, I have three drives, each holding
two members, one from each group.  In this case, aren't the two members
on the same drive identical?  If I lose that drive, I lose that entire
log group, and therefore no longer have a full set of logs--so what's
the point of having two copies?  I also lose the instance immediately
if that group happens to be the current group at the time of disk
failure.

Third, while I agree that every member of every group should ideally
have its own disk, does ANYONE actually configure their DB this way?  I
had a hard enough time dedicating one or two disks to redo logs; who
can dedicate eight, especially given drive sizes of 72+ GB and (single)
log file sizes of, what, 100 MB?




--- "Pardee, Roy E" <[EMAIL PROTECTED]> wrote:
> Yep, that's right--I had it wrong.  You need to have at least one
> member from each group in order to do a full recovery.  I see now
> from my trusty dba fundamentals I class text that each member of a
> group is identical (or is supposed to be).
> 
> So I guess I'll go back to being confused about why the answer to the
> question below is 2.  I guess 2 is the minimum required to survive a
> single disk failure?
> 
> Cheers,
> 
> -Roy
> 
> Roy Pardee
> Programmer/Analyst/DBA
> SWFPAC Lockheed Martin IT
> Extension 8487


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Boivin, Patrice J]

I am wondering... where do these questions come from?

There is a disclosure agreement at the beginning of each Oracle exam...

Patrice.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Senthil Kumar]

Hi

This ques from a model examnothing to worry about disclosure and
all!!!

-Original Message-
Boivin, Patrice J
Sent: Thursday, July 31, 2003 6:24 PM
To: Multiple recipients of list ORACLE-L


I am wondering... where do these questions come from?

There is a disclosure agreement at the beginning of each Oracle exam...

Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Senthil Kumar
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[April Wells]

Title: RE: 9i-OCP Question





didn't you say it was a question/answer out of the book?


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas


Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Senthil Kumar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 31, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 9i-OCP Question



Hi


This ques from a model examnothing to worry about disclosure and
all!!!


-Original Message-
Boivin, Patrice J
Sent: Thursday, July 31, 2003 6:24 PM
To: Multiple recipients of list ORACLE-L



I am wondering... where do these questions come from?


There is a disclosure agreement at the beginning of each Oracle exam...


Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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: Senthil Kumar
  INET: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

RE: 9i-OCP Question

[Jared Still]

Our Prod SAP system has 4 RAID1's dedicated to redo of 500m each
on an Clariion CX600 SAN.

Several groups with 2 members each.  That's 600 gig
of physical disk dedicated to redo, and nothing else.

Jared


On Thu, 2003-07-31 at 04:59, Boivin, Patrice J wrote:
> We use a SAN.
> 
> Where does that leave me?
> 
> : )
> 
> Patrice.
> 
> -Original Message-
> Sent: Wednesday, July 30, 2003 7:10 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I'm constantly amazed (and relieved!) that there's disagreement on the
> most fundamental principles.
> 
> First, I found myself nodding at Roy's first post.  On some databases,
> I have three log groups, with two members each.  Each set of members
> has its own disk.  I'll concede the argument that the instance goes
> down right away if one of the drives fails, but I _still_ have a full
> set of logs on the other drive, and that's a good thing, right?
> 
> Second, if I have three groups of two members each and follow what
> seems to be the consensus opinion, I have three drives, each holding
> two members, one from each group.  In this case, aren't the two members
> on the same drive identical?  If I lose that drive, I lose that entire
> log group, and therefore no longer have a full set of logs--so what's
> the point of having two copies?  I also lose the instance immediately
> if that group happens to be the current group at the time of disk
> failure.
> 
> Third, while I agree that every member of every group should ideally
> have its own disk, does ANYONE actually configure their DB this way?  I
> had a hard enough time dedicating one or two disks to redo logs; who
> can dedicate eight, especially given drive sizes of 72+ GB and (single)
> log file sizes of, what, 100 MB?
> 
> 
> 
> 
> --- "Pardee, Roy E" <[EMAIL PROTECTED]> wrote:
> > Yep, that's right--I had it wrong.  You need to have at least one
> > member from each group in order to do a full recovery.  I see now
> > from my trusty dba fundamentals I class text that each member of a
> > group is identical (or is supposed to be).
> > 
> > So I guess I'll go back to being confused about why the answer to the
> > question below is 2.  I guess 2 is the minimum required to survive a
> > single disk failure?
> > 
> > Cheers,
> > 
> > -Roy
> > 
> > Roy Pardee
> > Programmer/Analyst/DBA
> > SWFPAC Lockheed Martin IT
> > Extension 8487
> 
> 
> __
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: Boivin, Patrice J
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: Jared Still
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Jacques Kilchoer]

Except that:
1) five disks was not one of the possible answers, and
2) we don't know that the database is in archivelog mode.
For the 9i OCP examination the correct answer is answer number 4 (4 disks). I'm 
willing to bet on it!

> -Original Message-
> From: Ron Yount [mailto:[EMAIL PROTECTED]
> 
> Well Who knows what the author of the question intended, 
> but in the
> example of 2 (duplexed) redo log groups with archiving, they 
> speak of five
> disks.  One of EACH log member (not shared with log members of another
> group) and one for the archive log destination.
> 
> That being said, I believe the answer to the question is A: 8
> 
> -Original Message-
> Jacques Kilchoer
> Sent: Wednesday, July 30, 2003 9:19 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> > -Original Message-
> > From: Senthil Kumar [mailto:[EMAIL PROTECTED]
> > 
> > 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
> 
> The question specifically says "how many disks does Oracle 
> recommend...?" It
> seems to me that the correct answer is answer number 4, 
> Oracle recommends 4
> disks. (Quote: "When setting up a multiplexed online redo 
> log, place members
> of a group on different disks. If a single disk fails, then 
> ONLY ONE MEMBER
> of a group becomes unavailable..." - capitalization mine) Therefore 4
> members -> 4 disks.
> 
> Here is a link to a relevant section from an Oracle manual.
> 
> Oracle9i Database Administrator's Guide, Release 2 (9.2), Part Number
> A96521-01 
> Chapter 7 - Managing the Online Redo Log: Placing Online Redo 
> Log Members on
> Different Disks 
> 
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a
> 96521/onlinere
> do.htm#5414
> 
> "Placing Online Redo Log Members on Different Disks
> When setting up a multiplexed online redo log, place members 
> of a group on
> different disks. If a single disk fails, then only one member 
> of a group
> becomes unavailable to LGWR and other members remain 
> accessible to LGWR, so
> the instance can continue to function.
> 
> If you archive the redo log, spread online redo log members 
> across disks to
> eliminate contention between the LGWR and ARCn background 
> processes. For
> example, if you have two groups of duplexed online redo log 
> members, place
> each member on a different disk and set your archiving 
> destination to a
> fifth disk. Consequently, there is never contention between 
> LGWR (writing to
> the members) and ARCn (reading the members)."
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[Jonathan Gennick]

Wednesday, July 30, 2003, 1:19:31 PM, you wrote:
Q>> If you have 2 redo log groups with 4 members each, how many disks does
SK> Oracle recommend
SK>to keep the redo log files?

My first thought was 8, and I think you might be able to
make a case for 8. However, you should have at least 4,
because the whole reason for multiple members is have copies
on separate disks, so the maximum number of members in a
group ends up being the minimum number of disks, otherwise
you should reduce the number of members.

Does Oracle truly even make a recommendation with respect to
this question? Jacques Kilchoer came up with this quote from
the manuals:

When setting up a multiplexed online redo log, place
members of a group on different disks.

However, this quote does not speak to the total number of
disks. It says put each member of a group on a different
disk. Ok, fine, but either 4 or 8 disks will meet that
recommendation equally well.

It occurs to me though, that the question approaches the
issue all backwards. The implication is that you:

first decide how many members you have

secondly decide how many disks to spread those members
across

But who thinks like that that? I've always approached things
this way:

first I decided how many redundant copies I want of each
log file

then I create that many members, each on a separate
drive

My point here is that in real life, I don't think I'd ever
be asking myself the question Senthil posted from that
practice exam.

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word "subscribe" in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[Tim Gorman]

Experience with various flavors of storage technology plus a decade of DBA
experience can't possibly prepare me for what I haven't read (i.e. "Oracle's
recommendations").  In a multiple-choice test format, unlike real life, I
can't possibly argue with what Oracle has recommended...

No wonder I failed my first try at the 9iOCP upgrade exam.  Yes, I'll try
again, once the lobotomy scars heal...



on 7/30/03 10:19 AM, Senthil Kumar at [EMAIL PROTECTED] 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: Tim Gorman
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[Tim Gorman]

Unless ordering superannuated storage from eBay, disks are sized at either
36Gb, 73Gb, or larger.  Dedicating these devices to online redo log files of
size 100Mb, 500Mb, or 1Gb might be tough to get past the CFO.

The CIO/CTO might well also ask why some form of RAID-1 or RAID-5 redundancy
is not recommended for use here.  What would that reality do for the answer
to this question?  Especially if RAID-5 is in use (yes, BAARF)!  Steve's
answer of 42 would be closer to the mark than any answer yet provided,
besides being celestially correct...

Also, we're talking about a single process named LGWR and another 1-2
processes named ARCn.  Isn't it possible that these storage devices can
handle occasional concurrency of 2-3 without degrading performance?  Yup,
the answer is "it depends", not "A", or "B", or "C"

Whatever "Oracle's recommendation" is for this question, it is certainly a
tad on the simplistic side and useless in real life.  The discussion is
certainly worthwhile, but as a multiple-choice question with only one answer
it is worthless.  The OCP exam does not deal in reasoning and discussion...




on 7/30/03 12:34 PM, Igor Neyman at [EMAIL PROTECTED] wrote:

> Well, in archivelog mode LogWriter may use one group and Archiver may
> use the other group, so I'd agree with Kirti.
> 
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
> 
> 
> 
> -Original Message-
> Mladen Gogala
> Sent: Wednesday, July 30, 2003 12:59 PM
> To: Multiple recipients of list ORACLE-L
> 
> 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" <[EMAIL PROTECTED]>
>> 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: [EMAIL PROTECTED]
 
 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>>> 
>>> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>> 
>> 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: [EMAIL PROTECTED] (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: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California

RE: 9i-OCP Question

[Stephen Lee]

An invaluable aid for test taking is -- I learned this when I took Organic
Chemistry -- bourbon in water with ice in your favorite convenience drink
cup.  Everyone at the test site is sure you have a soft drink.

> -Original Message-
> 
> Experience with various flavors of storage technology plus a 
> decade of DBA
> experience can't possibly prepare me for what I haven't read 
> (i.e. "Oracle's
> recommendations").  In a multiple-choice test format, unlike 
> real life, I
> can't possibly argue with what Oracle has recommended...
> 
> No wonder I failed my first try at the 9iOCP upgrade exam.  
> Yes, I'll try
> again, once the lobotomy scars heal...
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[M.Godlewski]

I took the 8i OCP upgrade exam this weekend. I was amazed at one question.  It was asking about the OUI and installing third party software.  Now I've been an Oracle DBA for many years, and I would have thought Oracle would be more concerned about the Oracle database and the way it works rather then third party software, but apparently that is an important enough piece of information to Oracle Education to make it into a 45 question exam.Tim Gorman <[EMAIL PROTECTED]> wrote:
Experience with various flavors of storage technology plus a decade of DBAexperience can't possibly prepare me for what I haven't read (i.e. "Oracle'srecommendations"). In a multiple-choice test format, unlike real life, Ican't possibly argue with what Oracle has recommended...No wonder I failed my first try at the 9iOCP upgrade exam. Yes, I'll tryagain, once the lobotomy scars heal...on 7/30/03 10:19 AM, Senthil Kumar at [EMAIL PROTECTED] 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: Tim GormanINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

RE: 9i-OCP Question

[Eberhard, Jeff]

Perhaps it is a question which doesn't get scored (hopefully).  I'm not sure
if all the tests are like this but I took the 9i upgrade exam last week.  It
had 60 questions but only scores on 53 of them (it tosses out 7).
Unfortunately you don't know which questions will be scored or not.
 
--Jeff
 
 

-Original Message-
Sent: Monday, August 04, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L


I took the 8i OCP upgrade exam this weekend. I was amazed at one question.
It was asking about the OUI and installing third party software.  Now I've
been an Oracle DBA for many years, and I would have thought Oracle would be
more concerned about the Oracle database and the way it works rather then
third party software, but apparently that is an important enough piece of
information to Oracle Education to make it into a 45 question exam.

Tim Gorman <[EMAIL PROTECTED]> wrote: 

Experience with various flavors of storage technology plus a decade of DBA
experience can't possibly prepare me for what I haven't read (i.e. "Oracle's
recommendations"). In a multiple-choice test format, unlike real life, I
can't possibly argue with what Oracle has recommended...

No wonder I failed my first try at the 9iOCP upgrade exam. Yes, I'll try
again, once the lobotomy scars heal...



on 7/30/03 10:19 AM, Senthil Kumar at [EMAIL PROTECTED] 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: Tim Gorman
INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



  _  

Do you Yahoo!?
The New  
Yahoo! Search - Faster. Easier. Bingo.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Eberhard, Jeff
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: 9i-OCP Question

[Tim Gorman]

In high school, I took the SAT exams and got a great score, enough to be
satisfied with.  My guidance counselor insisted I gild the lily and take the
exams again.  I showed up that morning with no sleep, a throbbing hangover,
and eyes looking like fried eggs pasted to my head...

...scored 60 points better...



on 8/4/03 11:49 AM, Stephen Lee at [EMAIL PROTECTED] wrote:

> 
> An invaluable aid for test taking is -- I learned this when I took Organic
> Chemistry -- bourbon in water with ice in your favorite convenience drink
> cup.  Everyone at the test site is sure you have a soft drink.
> 
>> -Original Message-
>> 
>> Experience with various flavors of storage technology plus a
>> decade of DBA
>> experience can't possibly prepare me for what I haven't read
>> (i.e. "Oracle's
>> recommendations").  In a multiple-choice test format, unlike
>> real life, I
>> can't possibly argue with what Oracle has recommended...
>> 
>> No wonder I failed my first try at the 9iOCP upgrade exam.
>> Yes, I'll try
>> again, once the lobotomy scars heal...
>> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: 9i-OCP Question

[Ron Thomas]

I've seen some of that research many moons ago.  One of the conclusions was to always 
be in the same
state of mind when you take the test as you were in when you studied.  Now, where the 
 did I put
that bottle!

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


   
   
  [EMAIL PROTECTED]
   
  Com  To:   [EMAIL PROTECTED] 

  Sent by: cc: 
   
  [EMAIL PROTECTED]Subject:  RE: 9i-OCP Question   
   
  .com 
   
   
   
   
   
  08/05/2003 08:09 
   
  AM   
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   





There is scientific research that shows that moderate consumption of alcohol
while learning and while testing improves scores.  NOW you have a good
excuse!

> -Original Message-
>
> In high school, I took the SAT exams and got a great score,
> enough to be
> satisfied with.  My guidance counselor insisted I gild the
> lily and take the
> exams again.  I showed up that morning with no sleep, a
> throbbing hangover,
> and eyes looking like fried eggs pasted to my head...
>
> ...scored 60 points better...
>
>
>
> on 8/4/03 11:49 AM, Stephen Lee at [EMAIL PROTECTED] wrote:
>
> >
> > An invaluable aid for test taking is -- I learned this when
> I took Organic
> > Chemistry -- bourbon in water with ice in your favorite
> convenience drink
> > cup.  Everyone at the test site is sure you have a soft drink.
> >
> >> -Original Message-
> >>
> >> Experience with various flavors of storage technology plus a
> >> decade of DBA
> >> experience can't possibly prepare me for what I haven't read
> >> (i.e. "Oracle's
> >> recommendations").  In a multiple-choice test format, unlike
> >> real life, I
> >> can't possibly argue with what Oracle has recommended...
> >>
> >> No wonder I failed my first try at the 9iOCP upgrade exam.
> >> Yes, I'll try
> >> again, once the lobotomy scars heal...
> >>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--

RE: 9i-OCP Question

[Gudmundur Bjarni Josepsson]

Title: Message



The silliest questions I remember seeing in an OCP exam 
were the questions in the Oracle8 Networking exam which asked about the sequence 
of dialog boxes in the Network Configuration 
Assistant!

  I took the 8i OCP upgrade exam this weekend. I was amazed at one 
  question.  It was asking about the OUI and installing third party 
  software.  Now I've been an Oracle DBA for many years, and I would have 
  thought Oracle would be more concerned about the Oracle database and the way 
  it works rather then third party software, but apparently that is an important 
  enough piece of information to Oracle Education to make it into a 45 question 
  exam.

RE: 9i-OCP Question

[Stephen Lee]

There is scientific research that shows that moderate consumption of alcohol
while learning and while testing improves scores.  NOW you have a good
excuse!

> -Original Message-
> 
> In high school, I took the SAT exams and got a great score, 
> enough to be
> satisfied with.  My guidance counselor insisted I gild the 
> lily and take the
> exams again.  I showed up that morning with no sleep, a 
> throbbing hangover,
> and eyes looking like fried eggs pasted to my head...
> 
> ...scored 60 points better...
> 
> 
> 
> on 8/4/03 11:49 AM, Stephen Lee at [EMAIL PROTECTED] wrote:
> 
> > 
> > An invaluable aid for test taking is -- I learned this when 
> I took Organic
> > Chemistry -- bourbon in water with ice in your favorite 
> convenience drink
> > cup.  Everyone at the test site is sure you have a soft drink.
> > 
> >> -Original Message-
> >> 
> >> Experience with various flavors of storage technology plus a
> >> decade of DBA
> >> experience can't possibly prepare me for what I haven't read
> >> (i.e. "Oracle's
> >> recommendations").  In a multiple-choice test format, unlike
> >> real life, I
> >> can't possibly argue with what Oracle has recommended...
> >> 
> >> No wonder I failed my first try at the 9iOCP upgrade exam.
> >> Yes, I'll try
> >> again, once the lobotomy scars heal...
> >> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Tim Gorman
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Re: 9i-OCP Question

[rgaffuri]

i didnt ask the question. I was responding. what is up with the attitude? 
> 
> From: Mladen Gogala <[EMAIL PROTECTED]>
> Date: 2003/07/30 Wed PM 02:04:57 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: 9i-OCP Question
> 
> So, what do you need us for?
> 
> 
> 
> On 2003.07.30 13:29, [EMAIL PROTECTED] wrote:
> > according to the 8i osborne ocp book, the answer is 2.
> > >
> > > From: "Senthil Kumar" <[EMAIL PROTECTED]>
> > > Date: 2003/07/30 Wed PM 01:19:31 EDT
> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > Subject: 9i-OCP Question
> > >
> > > 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: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED]
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: RE: 9i-OCP Question

[rgaffuri]

dont know from experience, since I dont handle backups and redo, but according to the 
books, you are multiplexing your redo log groups. so if one of the files gets 
corrupted, etc... you have exact duplicates on different storage devices. 

So if you put all the members on the same storage device and you move onto the the 
next redo log group and then that storage device goes bad, you lose all the redo. 

now lets say you are in archive log mode and your archive log hasnt kept up... and was 
still archiving data. you cant recover from that point in time. 

please correct me if Im wrong. Im half responding to make sure I understand it 
correctly. 
> 
> From: "Pardee, Roy E" <[EMAIL PROTECTED]>
> Date: 2003/07/30 Wed PM 03:14:30 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: 9i-OCP Question
> 
> I thought you need to preserve the groups, not (necessarily) the members.
> 
> If you have each group on its own disk then if one disk goes, you've got a complete 
> set of logs on the other.  Or am I not thinking about this correctly?
> 
> Cheers,
> 
> -Roy
> 
> Roy Pardee
> Programmer/Analyst/DBA
> SWFPAC Lockheed Martin IT
> Extension 8487
> 
> -Original Message-
> Sent: Wednesday, July 30, 2003 11:10 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Answe is 4 disks . to keep each member on different disks . 
> 
> -ak
> 
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 30, 2003 10:19 AM
> 
> 
> > 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: [EMAIL PROTECTED]
> > 
> > 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: [EMAIL PROTECTED] (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: AK
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: Pardee, Roy E
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Re: 9i-OCP Question

[rgaffuri]

yeah that might be the right answer, but you would get it wrong on the OCP... assuming 
the books are right. 
> 
> From: Peter Gram <[EMAIL PROTECTED]>
> Date: 2003/07/30 Wed PM 04:09:28 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> 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" <[EMAIL PROTECTED]>
> >> 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: [EMAIL PROTECTED]
> >> > >
> >> > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >> >
> >> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >>
> >> Fat City Network Services-- 858-538-5051 http://www.fatcity.com