RE: 9i-OCP Question

2003-08-14 Thread 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

RE: 9i-OCP Question

2003-08-14 Thread Ron Thomas
cc: [EMAIL PROTECTED]Subject: RE: 9i-OCP Question

RE: 9i-OCP Question

2003-08-14 Thread 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

Re: 9i-OCP Question

2003-08-04 Thread 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 point

RE: 9i-OCP Question

2003-08-04 Thread 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

Re: 9i-OCP Question

2003-08-04 Thread 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 the

RE: 9i-OCP Question

2003-08-04 Thread 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 technolo

Re: 9i-OCP Question

2003-08-04 Thread 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

Re: 9i-OCP Question

2003-08-04 Thread 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 fai

Re: 9i-OCP Question

2003-08-01 Thread 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, becau

RE: 9i-OCP Question

2003-07-31 Thread 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 PROTECT

RE: 9i-OCP Question

2003-07-31 Thread 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

RE: 9i-OCP Question

2003-07-31 Thread 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

RE: 9i-OCP Question

2003-07-31 Thread 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 a

RE: 9i-OCP Question

2003-07-31 Thread 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-5

RE: 9i-OCP Question

2003-07-31 Thread 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

RE: 9i-OCP Question

2003-07-30 Thread Ukrit . K
TECTED]>         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 rec

RE: 9i-OCP Question

2003-07-30 Thread 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 a

RE: 9i-OCP Question

2003-07-30 Thread Ukrit . K
              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

RE: 9i-OCP Question

2003-07-30 Thread 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 s

Re: 9i-OCP Question

2003-07-30 Thread 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

RE: 9i-OCP Question

2003-07-30 Thread 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 inst

RE: 9i-OCP Question

2003-07-30 Thread Josh Collier
m 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]>

RE: 9i-OCP Question

2003-07-30 Thread Pardee, Roy E
t 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 >

RE: 9i-OCP Question

2003-07-30 Thread 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 rea

RE: 9i-OCP Question

2003-07-30 Thread 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 i

Re: Re: 9i-OCP Question

2003-07-30 Thread 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

2003-07-30 Thread 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

Re: 9i-OCP Question

2003-07-30 Thread 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) wil

Re: 9i-OCP Question

2003-07-30 Thread 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

Re: RE: 9i-OCP Question

2003-07-30 Thread rgaffuri
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 t

RE: 9i-OCP Question

2003-07-30 Thread 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

RE: 9i-OCP Question

2003-07-30 Thread 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

RE: 9i-OCP Question

2003-07-30 Thread 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 Mar

RE: 9i-OCP Question

2003-07-30 Thread 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 Deshpan

Re: 9i-OCP Question

2003-07-30 Thread 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) I

RE: 9i-OCP Question

2003-07-30 Thread 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

Re: Re: 9i-OCP Question

2003-07-30 Thread 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 >

Re: 9i-OCP Question

2003-07-30 Thread 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

Re: 9i-OCP Question

2003-07-30 Thread 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

Re: 9i-OCP Question

2003-07-30 Thread 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 y

Re: 9i-OCP Question

2003-07-30 Thread 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

Re: 9i-OCP Question

2003-07-30 Thread 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 > > Wh

Re: 9i-OCP Question

2003-07-30 Thread 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 f