RE: ** OCP for 9i requirements -- Instructor Led Class is a

[DENNIS WILLIAMS]

I heard from an Oracle instructor that some idiots were bragging about how
they passed the OCP without logging in once. This distressed some important
people, so this requirement was added. I asked if this meant each instructor
was tasked with ensuring each student logged in, and he just smiled.



Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, January 14, 2004 8:09 AM
To: Multiple recipients of list ORACLE-L



Sure.

Read 
"Important Program Announcement: Oracle University Hands-On Course
Requirement
Oracle customers and business partners are demanding hands-on experience -
with all aspects of Oracle's database - from their Oracle Certified
Professionals. In order to meet our commitment to our customers and
constituents, Oracle University has recently made a significant investment
in its Certification Program. Three distinct changes are being rolled out
with the goal of increasing the level of quality of our certification skill
and ability benchmarks: 
Scenario-based testing in all Oracle9i DBA Certified Professional
exams . 
Instructor-led class requirement for candidates starting on the
Oracle9i DBA Certified Professional credential exam path. 
A new hands-on Masters Practicum Exam for the Oracle9i Database
Administrator Certified Master credential. 
"

at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html
 

"Instructure-led class" is a requirement.

You CAN take the Online Training to _prepare_ for the Exams.  But you MUST
attend at least one Instructor-led class
to qualify for the certification.
Hemant
At 10:34 AM 13-01-04 -0800, you wrote:


why dont you just read what is on the oracle website?
 
www.oracle.com  
 
do a search for certification. 

- Original Message - 


To: Multiple recipients of   list ORACLE-L 

Sent: Tuesday, January 13, 2004 9:34 AM 






Are you sure that the on-line version qualifies as fulfilling the
pre-requisite ?  I thought that 

the pre-requisite is "at least one Instructor Led Training".



Hemant 

At 12:04 AM 13-01-04 -0800, you wrote: 


At 06:14 PM 1/12/2004, Ryan wrote: 



www.oracle.com   

  

do a search for certification. Its all explained there. You can take an
online course for $300. If your company is an oracle partner the course is
free. 

My understanding is that you need to take a class that corresponds to one of
the four OCP exams, which are all 5-day classes.  The in-classroom versions
run $2500 and the on-line versions run $1250.  Oracle partners get a 35%
discount (advantage and certified advantage partners may get a larger
discount).



http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.
html
 



Justin Cave 


- Original Message - 


To: Multiple recipients of   list ORACLE-L 

Sent: Monday, January 12, 2004 7:34 PM 




Hi, 

  For taking Oracle9i OCP exam is it necessary to have attended a Oracle
course by Oracle University. What is the minimum?  Is any small course good
enough? Can someone who has gone through this provide details? Thank you







Do you Yahoo!? 

Yahoo! Hotjobs: Enter
 the "Signing Bonus"
Sweepstakes 

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com   {last updated
05-Jan-04}

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- Author: Hemant K Chitale 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). 

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com    {last updated
05-Jan-04}

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:
Hemant K Chitale 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: ** OCP for 9i requirements -- Instructor Led Class is a

[Paula_Stankus]

If you 
go to the Update 9i exam listing - there are no course 
requirements.

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Hemant K 
  ChitaleSent: Wednesday, January 14, 2004 9:09 AMTo: 
  Multiple recipients of list ORACLE-LSubject: Re: ** OCP for 9i 
  requirements -- Instructor Led Class is 
  aSure.Read "Important Program 
  Announcement: Oracle University Hands-On Course RequirementOracle 
  customers and business partners are demanding hands-on experience - with all 
  aspects of Oracle's database - from their Oracle Certified Professionals. In 
  order to meet our commitment to our customers and constituents, Oracle 
  University has recently made a significant investment in its Certification 
  Program. Three distinct changes are being rolled out with the goal of 
  increasing the level of quality of our certification skill and ability 
  benchmarks: ·   Scenario-based 
  testing in all Oracle9i DBA Certified Professional exams . ·   Instructor-led 
  class requirement for candidates starting on the Oracle9i DBA Certified 
  Professional credential exam path. ·   A 
  new hands-on Masters Practicum Exam for the Oracle9i Database Administrator 
  Certified Master credential. "at http://www.oracle.com/education/certification/index.html?dba9i_ocp.html"Instructure-led 
  class" is a requirement.You CAN take the Online Training to _prepare_ 
  for the Exams.  But you MUST attend at least one Instructor-led 
  classto qualify for the certification.HemantAt 10:34 AM 13-01-04 
  -0800, you wrote:
  why dont 
you just read what is on the oracle website? www.oracle.com do a search for certification. 

  - Original Message - 
  From: Hemant K 
  Chitale 
  To: Multiple recipients of 
  list ORACLE-L 
  Sent: Tuesday, January 13, 2004 9:34 AM 
  Subject: Re: ** OCP for 9i requirements
  Are you sure that the on-line version qualifies as fulfilling the 
  pre-requisite ?  I thought that 
  the pre-requisite is "at least one Instructor Led Training".
  Hemant 
  At 12:04 AM 13-01-04 -0800, you wrote:
  
At 06:14 PM 1/12/2004, Ryan wrote:

  www.oracle.com 
   
  do a search for certification. Its all explained there. You can 
  take an online course for $300. If your company is an oracle partner 
  the course is free. 
My understanding is that you need to take a class that corresponds 
to one of the four OCP exams, which are all 5-day classes.  The 
in-classroom versions run $2500 and the on-line versions run 
$1250.  Oracle partners get a 35% discount (advantage and certified 
advantage partners may get a larger discount).
http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html
Justin Cave 

  - Original Message - 
  From: A Joshi 
  To: Multiple recipients of 
  list ORACLE-L 
  Sent: Monday, January 12, 2004 7:34 PM 
  Subject: ** OCP for 9i requirements
  Hi, 
    For taking Oracle9i OCP exam is it necessary to have 
  attended a Oracle course by Oracle University. What is the 
  minimum?  Is any small course good enough? Can someone who has 
  gone through this provide details? Thank you
  Do you Yahoo!? 
  Yahoo! Hotjobs: Enter 
  the "Signing Bonus" Sweepstakes 
  Hemant K 
  ChitaleOracle 9i Database Administrator Certified Professionalhttp://hkchital.tripod.com {last updated 
  05-Jan-04}-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 
  Author: Hemant K Chitale 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).
  
  
  Hemant K ChitaleOracle 9i Database Administrator Certified 
  Professionalhttp://hkchital.tripod.com  {last updated 
  05-Jan-04}-- Please see the official ORACLE-L FAQ: 
  http://www.orafaq.net -- Author: Hemant K Chitale 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 

Re: ** OCP for 9i requirements -- Instructor Led Class is a

[Hemant K Chitale]

Sure.
Read 
"Important Program Announcement: Oracle University Hands-On Course
Requirement
Oracle customers and business partners are demanding hands-on experience
- with all aspects of Oracle's database - from their Oracle Certified
Professionals. In order to meet our commitment to our customers and
constituents, Oracle University has recently made a significant
investment in its Certification Program. Three distinct changes are being
rolled out with the goal of increasing the level of quality of our
certification skill and ability benchmarks: 
·   Scenario-based
testing in all Oracle9i DBA Certified Professional exams . 
·   Instructor-led
class requirement for candidates starting on the Oracle9i DBA Certified
Professional credential exam path. 
·   A
new hands-on Masters Practicum Exam for the Oracle9i Database
Administrator Certified Master credential. 
"
at
http://www.oracle.com/education/certification/index.html?dba9i_ocp.html
"Instructure-led class" is a requirement.
You CAN take the Online Training to _prepare_ for the Exams.  But
you MUST attend at least one Instructor-led class
to qualify for the certification.
Hemant
At 10:34 AM 13-01-04 -0800, you wrote:
why dont
you just read what is on the oracle website?
 
www.oracle.com
 
do a search for certification. 

- Original Message - 
From: Hemant K
Chitale 
To: Multiple recipients of
list ORACLE-L 
Sent: Tuesday, January 13, 2004 9:34 AM
Subject: Re: ** OCP for 9i requirements


Are you sure that the on-line version qualifies as fulfilling the
pre-requisite ?  I thought that
the pre-requisite is "at least one Instructor Led
Training".

Hemant
At 12:04 AM 13-01-04 -0800, you
wrote:
At 06:14 PM 1/12/2004, Ryan
wrote:
www.oracle.com
 
do a search for certification. Its all explained there. You can take
an online course for $300. If your company is an oracle partner the
course is free. 
My understanding is that you need to take a class that corresponds to
one of the four OCP exams, which are all 5-day classes.  The
in-classroom versions run $2500 and the on-line versions run $1250. 
Oracle partners get a 35% discount (advantage and certified advantage
partners may get a larger discount).

http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html

Justin Cave 
- Original Message - 
From: A Joshi 
To: Multiple recipients of list
ORACLE-L 
Sent: Monday, January 12, 2004 7:34 PM 
Subject: ** OCP for 9i requirements

Hi, 
  For taking Oracle9i OCP exam is it necessary to have attended
a Oracle course by Oracle University. What is the minimum?  Is any
small course good enough? Can someone who has gone through this provide
details? Thank you



Do you Yahoo!? 
Yahoo! Hotjobs:
Enter
the "Signing Bonus" Sweepstakes 
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com
 {last updated 05-Jan-04}
-- Please see the official ORACLE-L FAQ:
http://www.orafaq.net
-- Author: Hemant K Chitale 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).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com  {last updated 05-Jan-04}


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
  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: ** OCP for 9i requirements

[Ryan]

why dont you just read what is on the oracle 
website?
 
www.oracle.com
 
do a search for certification. 

  - Original Message - 
  From: 
  Hemant 
  K Chitale 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, January 13, 2004 9:34 
  AM
  Subject: Re: ** OCP for 9i 
  requirements
  Are you sure that the on-line version qualifies as 
  fulfilling the pre-requisite ?  I thought thatthe pre-requisite is 
  "at least one Instructor Led Training".HemantAt 12:04 AM 13-01-04 
  -0800, you wrote:
  At 06:14 PM 1/12/2004, Ryan 
wrote:
www.oracle.com do a search for certification. Its all explained there. 
  You can take an online course for $300. If your company is an oracle 
  partner the course is free. My understanding is that 
you need to take a class that corresponds to one of the four OCP exams, 
which are all 5-day classes.  The in-classroom versions run $2500 and 
the on-line versions run $1250.  Oracle partners get a 35% discount 
(advantage and certified advantage partners may get a larger 
discount).http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.htmlJustin Cave

  
- Original Message - 
From: A Joshi 
To: Multiple recipients of 
list ORACLE-L 
Sent: Monday, January 12, 2004 7:34 PM 
Subject: ** OCP for 9i requirements
Hi, 
  For taking Oracle9i OCP exam is it necessary to have attended 
a Oracle course by Oracle University. What is the minimum?  Is any 
small course good enough? Can someone who has gone through this provide 
details? Thank you
Do you Yahoo!? 
Yahoo! Hotjobs: Enter 
the "Signing Bonus" Sweepstakes 
Hemant K ChitaleOracle 9i Database Administrator Certified 
Professionalhttp://hkchital.tripod.com  {last updated 
05-Jan-04}-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.net -- Author: Hemant K Chitale 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: ** OCP for 9i requirements

[Hemant K Chitale]

Are you sure that the on-line version qualifies as fulfilling the
pre-requisite ?  I thought that
the pre-requisite is "at least one Instructor Led
Training".
Hemant
At 12:04 AM 13-01-04 -0800, you wrote:
At 06:14 PM 1/12/2004, Ryan
wrote:
www.oracle.com
 
do a search for certification. Its all
explained there. You can take an online course for $300. If your company
is an oracle partner the course is free. 
My understanding is that you need to take a class that corresponds to one
of the four OCP exams, which are all 5-day classes.  The
in-classroom versions run $2500 and the on-line versions run $1250. 
Oracle partners get a 35% discount (advantage and certified advantage
partners may get a larger discount).
http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html
Justin
Cave

- Original Message - 
From: A Joshi 
To: Multiple recipients of list
ORACLE-L 
Sent: Monday, January 12, 2004 7:34 PM
Subject: ** OCP for 9i requirements

Hi,
  For taking Oracle9i OCP exam is it necessary to have attended
a Oracle course by Oracle University. What is the minimum?  Is any
small course good enough? Can someone who has gone through this provide
details? Thank you


Do you Yahoo!?
Yahoo! Hotjobs:
Enter
the "Signing Bonus" Sweepstakes


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com 
{last updated 05-Jan-04}


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  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: ** OCP for 9i requirements

[Justin Cave]

At 06:14 PM 1/12/2004, Ryan wrote:
www.oracle.com
 
do a search for certification. Its all
explained there. You can take an online course for $300. If your company
is an oracle partner the course is free. 
My understanding is that you need to take a class that corresponds to one
of the four OCP exams, which are all 5-day classes.  The
in-classroom versions run $2500 and the on-line versions run $1250. 
Oracle partners get a 35% discount (advantage and certified advantage
partners may get a larger discount).
http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html
Justin Cave


- Original Message - 

From: A Joshi 

To: Multiple recipients of
list ORACLE-L 

Sent: Monday, January 12, 2004 7:34 PM

Subject: ** OCP for 9i requirements

Hi,

  For taking Oracle9i OCP exam is it necessary to have attended
a Oracle course by Oracle University. What is the minimum?  Is any
small course good enough? Can someone who has gone through this provide
details? Thank you


Do you Yahoo!?

Yahoo! Hotjobs:
Enter
the "Signing Bonus" Sweepstakes

Re: ** OCP for 9i requirements

[Ryan]

www.oracle.com
 
do a search for certification. Its all explained 
there. You can take an online course for $300. If your company is an oracle 
partner the course is free. 

  - Original Message - 
  From: 
  A Joshi 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, January 12, 2004 7:34 
  PM
  Subject: ** OCP for 9i requirements
  
  Hi,
    For taking Oracle9i OCP exam is it necessary to have attended a 
  Oracle course by Oracle University. What is the minimum?  Is any 
  small course good enough? Can someone who has gone through this provide 
  details? Thank you
  
  
  Do you Yahoo!?Yahoo! Hotjobs: Enter 
  the "Signing Bonus" Sweepstakes

Re: OCP question from Boson practice tests

[A Joshi]

Hi,
  This is from a metalink note 1039341.6. It is about 'DEFAULT STORAGE'. I do not know if the OCP question was regarding that. 
***

Use the following guidelines to specify DEFAULT STORAGE: Set INITIAL=NEXT.Since a process always writes data equal to  SORT_AREA_SIZE to a temporary segment, a good value for the extent size is (n*s + b) 
 
    where:  n is a positive integer  
    s is the value of SORT_AREA_SIZE initialization parameter
    b is the value of DB_BLOCK_SIZE initialization parameter 
 
    Using this value optimizes temporary segment usage by allowing sufficient space for a header block and multiple sort run data to be stored in each extent. 
Is this not correct? Forget OCP. I was just want clarify this issue.  Good luck for the exams  Prem. 
Further to that if I give my sort area size as a very odd number which is not a multiple of OS block size then what happens.
Thank You[EMAIL PROTECTED] wrote:
Prem ,OCP has nothing to do with knowledge and nothing to do with the real world.So if you want to give OCP, forget what you know and humbly, play by itsrules.Right now if your are serious about giving OCP exams then pleaseenable "suspension of disbelief" , don't ask why and just mug up thefollowing 3 (any one of them may come up in the ocp exam , though nottogether) :1.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be a multiple of the parameter sort_area_size2.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be a multiple of sort_area_size * db_block_size3.To optimize the performance of a sort in a temprary tablespace , set theUNIFORM SIZE to be n * sort_area_size + db_block_size.OCP has nothing to do with
 knowledge and nothing to do with the real world.So if you want to give OCP, forget what you know and play by its rules.Best of luck .
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

Re: OCP Question (Perf Tuning)

[Tanel Poder]

> After the students have scribbled everything down, he then leans forward
and
> quietly whispers to them that in the "real world", heart surgeons actual
> first check whether or not it's actually necessary to cut out the heart
> *beforehand*. He then gives them a little wink and a nod, the students
> usually reply with an "hh" and the class moves on to discuss how
to
> remove blood stains from their white surgical outfits.
>
> IMHO it's all a little scary and a touch surreal and yet it all sounds
> strangely familiar ...

And they don't have too many backups either :(

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: OCP Question (Perf Tuning)

[Richard Foote]

> We'll thats exactly what I'm doing right now, studying Oracle University
> instructor guides to temporarily start thinking like OU myself again -
I'll
> be instructing an OCP Review course next week, meant for people who want
to
> pass OCP. And in order to not distract the students, I won't even mention
> the real life situation too much, except in really misleading cases...
>

Hi  Tanel

I have a Dr. friend of mine who teaches heart surgeons how to pass their
medical exams.

Basically he simply teaches them to rip out the offending organ (generally
found towards the left hand side of the upper chest), give it a bit of a
squeeze, shake out any crap that might be inside, measure the Beats outside
Chest Heart Ratio (BCHR), stick it back in, hope it's done some good and
that the patient at least survives until they're 10 miles from the hospital.

He tells the students that it's important to do the above steps in the
correct order as it's in the medical exam.

After the students have scribbled everything down, he then leans forward and
quietly whispers to them that in the "real world", heart surgeons actual
first check whether or not it's actually necessary to cut out the heart
*beforehand*. He then gives them a little wink and a nod, the students
usually reply with an "hh" and the class moves on to discuss how to
remove blood stains from their white surgical outfits.

IMHO it's all a little scary and a touch surreal and yet it all sounds
strangely familiar ...

Cheers ;)

Richard


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Foote
  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: OCP question from Boson practice tests

[bulbultyagi]

Prem ,
OCP has nothing to do with knowledge and nothing to do with the real world.
So if you want to give OCP, forget what you know and humbly, play by its
rules.

Right now if your are serious about giving OCP exams then please
enable "suspension of disbelief" , don't ask why and just mug up the
following 3 (any one of them may come up in the ocp exam , though not
together) :

1.
To optimize the performance of a sort in a temprary tablespace , set the
UNIFORM SIZE to be a multiple of the parameter sort_area_size

2.
To optimize the performance of a sort in a temprary tablespace , set the
UNIFORM SIZE to be a multiple of  sort_area_size * db_block_size

3.
To optimize the performance of a sort in a temprary tablespace , set the
UNIFORM SIZE to ben * sort_area_size  +  db_block_size.


OCP has nothing to do with knowledge and nothing to do with the real world.
So if you want to give OCP, forget what you know and play by its rules.
Best of luck .



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 16:14


> Hi List, this is the question .
>
> 
> You are calculating the proper size for a temporary tablespace .
> Which of the following are two most important factors to consider ?
>
> A. users
> B. sort_area_size
> C. type of tablespace management
> D. db_block_size
> 
>
> my choice is A & B .
>
> but boson's choice is B & D . the explanation given by boson is :
> when sizing a temporary tablespace , the formula is
> db_block_size * sort_area_size .
>
> is it so ? do we need not take no. of users into account ?
> kindly explain me .
>
> Regards,
> Prem.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Prem Khanna 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: <[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: OCP Question (Perf Tuning)

[Tanel Poder]

> What I have heard is that all the OCP questions are taken from the Oracle
> University Student Guide. After all, you wouldn't you expect the class to
> prepare you? Someone suggested that you "think like a computer". Well, for
> the philosophy behind the exam, "think like an organization", namely
Oracle
> University.

We'll thats exactly what I'm doing right now, studying Oracle University
instructor guides to temporarily start thinking like OU myself again - I'll
be instructing an OCP Review course next week, meant for people who want to
pass OCP. And in order to not distract the students, I won't even mention
the real life situation too much, except in really misleading cases...

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: OCP question from Boson practice tests

[Goulet, Dick]

Well, you've certainly gotten a few decent replies.  I've never used Boson so 
I can't comment on their exams, I prefer going to Oracle Press.  Anyway, sizing temp 
is a combination of things many of which are black magic at best.  Number of users is 
an interesting variable to add, but not of an extreme value since it's actually the 
number of CONNECTED users that will really affect the value arrived at.  
Sort_Area_size, Maybe.  If it's large enough it may well negate the need for temp in a 
number of cases, but don't bet on it.  Type of Tablespace management?  OK, who's 
smoking what.  That's a giveaway toss out.  DB_Block_Size, again a giveaway, it has no 
real bearing since the temp tablespace will have the same size, unless you use 9i 
features, but even then a MB is a MB.

The real answer is know what your database is suppose to be doing.  If your 
setting up an OLTP database you may well get away with a very small temp space.  On 
the other hand a data warehouse or decision support system is, by design, going to 
consume mountains of temp.  Also do not forget things like index rebuilds that you 
will need to do, they do sorts and consequently consume temp in the process.  Then 
there's always that wild user who lets loose the Cartesian product from haties that 
will blow all of your calculations off the map.  

Therefore the answer in this case is E: None of the above.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-Original Message-
Sent: Wednesday, January 07, 2004 5:44 AM
To: Multiple recipients of list ORACLE-L


Hi List, this is the question .


You are calculating the proper size for a temporary tablespace .
Which of the following are two most important factors to consider ?

A. users
B. sort_area_size
C. type of tablespace management
D. db_block_size


my choice is A & B .

but boson's choice is B & D . the explanation given by boson is :
when sizing a temporary tablespace , the formula is 
db_block_size * sort_area_size .

is it so ? do we need not take no. of users into account ?
kindly explain me .

Regards,
Prem.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna 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: Goulet, Dick
  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: OCP question from Boson practice tests

[Richard Foote]

Hi again Prem,

OK, I've changed my opinion of dear Boson. At first I simply thought they
had no idea, now I suspect it's all a big joke designed to make DBAs have a
bit of a giggle on warm summer nights ...

Sizing the temp tablespace by the formula you've given is really quite
witty. Perhaps a little on the silly side but I love Monty Python so I liked
it.

The correct answer is actually none of the four listed (so I'm really
struggling to find two of the buggers).

A. Users: Not really. I could show you a DW database with only a handful of
users that requires a much larger temp tablespace than an OLTP database with
1000s of users. It not the number of users but what the users *do* that's
important.

B. Sort Area Size. Not really. Although it can influence whether a sort is
performed on temp or not, it's the size of the *sort*, not the size of the
S_A_S that's important. And not just the size of one sort, but the size of
the *max concurrent* sort activity. I guess a badly set S_A_S could result
in needing a larger temp tablespace but I doubt that's the point of the
question. And then there's hash joins, etc, ooops, the question has kinda
forgotten about non sort activity in temp

C. tablespace management. Not really although I guess those bitmaps do take
up some space ...

D. db_block_size. What the #@&* ??.

Thinking about all this a bit more, if Boson's practice questions puts
people off doing OCPs, it might not be such a bad thing after all ...

Cheers ;)

Richard

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 8:44 PM


> Hi List, this is the question .
>
> 
> You are calculating the proper size for a temporary tablespace .
> Which of the following are two most important factors to consider ?
>
> A. users
> B. sort_area_size
> C. type of tablespace management
> D. db_block_size
> 
>
> my choice is A & B .
>
> but boson's choice is B & D . the explanation given by boson is :
> when sizing a temporary tablespace , the formula is
> db_block_size * sort_area_size .
>
> is it so ? do we need not take no. of users into account ?
> kindly explain me .
>
> Regards,
> Prem.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Prem Khanna 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: Richard Foote
  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: OCP Question (Perf Tuning)

[Jonathan Lewis]

A bigger error in option (d) is that it leaves
open the ambiguity of whether the rows
should, or should not, be part of the answer
to the join.

Oracle's choice of join could be affected
by adding 100 rows to the table that
should be included in the join, but remain
unchanged if you add 100 rows that
should not be included in the join.

Frankly it's an appallingly bad question,  and
I think your assumption about the wrong answer
you are required to give is correct.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06, 2004 9:54 PM


> Jonathan noted that
> > > Nope. The answer is b). In the FIRST_ROWS mode, optimizer
> > prefers NL
> > > to
> > all other
> > > methos despite the price.
> > >
> >
> > Unless the alternative is a full tablescan on the inner
> > table - in which case merge or hash joins can be
> > considered.
>
> For some reason hash joins were excluded from the question. I can't
> speculate as to what, other than oversight or limiting the answers to 4,
the
> reason for this might be.
>
>
> I suspect the answer *wanted* is b) the focus being that FIRST_ROWS
favours
> index scans and NL joins. ISTM that d) ought to be ruled out as it refers
to
> rows not blocks but as usual I am probably wrong.
>
> Niall
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: OCP Question (Perf Tuning)

[Jonathan Lewis]

I see you're running on Oracle 9 there, and that
can make a big difference.  After posting my
hypothesis, I created a test case, which behaved
as I had predicted - but the behaviour changed
in Oracle 9, and I had to do some tweaking.

Turns out my test case highlighted what looks
like a but in the SORT costing in Oracle 8
for a sort/merge join.  The Oracle 9 costing
is better, so Oracle 9 didn't switch to an NL
when Oracle 8 did.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06, 2004 9:14 PM


> Jonathan, you're right. Interesting thing is that bitmap indexes, which
were made for
> DW processing and not for OLTP will also be considered for NL context in
First_Rows mode.
> Here is the proof, which also proves that I'm a lousy typist:
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: OCP Question (Perf Tuning)

[Niall Litchfield]

Jonathan noted that
> > Nope. The answer is b). In the FIRST_ROWS mode, optimizer 
> prefers NL 
> > to
> all other
> > methos despite the price.
> >
> 
> Unless the alternative is a full tablescan on the inner
> table - in which case merge or hash joins can be
> considered.

For some reason hash joins were excluded from the question. I can't
speculate as to what, other than oversight or limiting the answers to 4, the
reason for this might be. 


I suspect the answer *wanted* is b) the focus being that FIRST_ROWS favours
index scans and NL joins. ISTM that d) ought to be ruled out as it refers to
rows not blocks but as usual I am probably wrong. 

Niall 

OCP DBA (the last time you'll see that sig for a while). 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  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: OCP Question (Perf Tuning)

[Jay Wade]

Thanks for the help.
Do you have any ideas to the FIRST_ROWS behavior in regards to NL?
I've been looking and found

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm#39473

it goes into detail about using hints for joins but now how the FIRST_ROWS 
forces a join selection on anything other then sample size. I'm interested 
to know more about the behavior and the links that I am finding don't seem 
to offer the depth I thought they would.  Or maybe they do and I'm missing 
the boat

From: "Ryan" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: OCP Question (Perf Tuning)
Date: Tue, 06 Jan 2004 11:34:26 -0800
thought so, I'm not 100% certain the OCP will say that though. alot of
inaccuracies in that test.
btw, Ive been playing with first_rows lately. I've noticed that it has a
preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in
some test cases where you have two tables approximately 3m and 1.5m rows in
size, that INDEX RANGE SCAN actually returns the first 25 or so records
faster, than 'INDEX FULL SCAN', there by making FIRST_ROWS, inferior.
Surprised me. I've read some docs on this and I think that a range scan is
always preferably when you only want a few rows? What am I missing?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06, 2004 1:59 PM
> Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to
all other
> methos despite the price.
>
> On 2004.01.06 13:44, Jay Wade wrote:
> > Hello:
> >
> > I was looking through some OCP questions posted on the web and came
across
> > the one below.
> > I believe the answer is (D), because the join type would be dependent 
on
the
> > number of rows within the table.  Is this correct or does the
OPTIMIZER_MODE
> > set to FIRST_ROWS alter this behavior?
> >
> >
> > The cost-based optimizer can choose between a nested loops join and a
sort
> > merge join operation. All tables are analyzed and the OPTIMIZER_MODE 
is
set
> > to FIRST_ROWS. Which execution plan will be the result?
> >
> > a. The sort-merge join.
> >
> > b. The nested loops join.
> >
> > c. This depends on some sort parameter values.
> >
> > d. This depends on the number of rows in each table.
> >
> > _
> > Check your PC for viruses with the FREE McAfee online computer scan.
> > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jay Wade
> >   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: Ryan
  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 wan

RE: OCP Question (Perf Tuning)

[Stephen.Lee]

What I meant is that the question cannot be answered without making human
assumptions about the question itself.  It is a little difficult (Note
"little" not "lot") to believe that such a poorly written question would
appear on a test that costs money to take.

-Original Message-

Someone suggested that you "think like a computer". Well, for
the philosophy behind the exam, "think like an organization", namely Oracle
University.
-- 
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: OCP Question (Perf Tuning)

[Mladen Gogala]

Jonathan, you're right. Interesting thing is that bitmap indexes, which were made for
DW processing and not for OLTP will also be considered for NL context in First_Rows 
mode.
Here is the proof, which also proves that I'm a lousy typist:


SQL> set autorace on explain
SP2-0158: unknown SET option "autorace"
SQL> set autotrace on explain
SQL> select /*+ first_rows ordered */ ename,dname,loc from emp e,dept d
  2  where e.deptno=d.deptno
  3  /
 
ENAME  DNAME  LOC
-- -- -
ALLEN  SALES  CHICAGO
WARD   SALES  CHICAGO
JAMES  SALES  CHICAGO
FORD   RESEARCH   DALLAS
MILLER ACCOUNTING NEW YORK
SMITH  RESEARCH   DALLAS
JONES  RESEARCH   DALLAS
MARTIN SALES  CHICAGO
BLAKE  SALES  CHICAGO
CLARK  ACCOUNTING NEW YORK
SCOTT  RESEARCH   DALLAS
 
ENAME  DNAME  LOC
-- -- -
KING   ACCOUNTING NEW YORK
TURNER SALES  CHICAGO
ADAMS  RESEARCH   DALLAS
 
14 rows selected.
 
 
Execution Plan
--
   0  SELECT STATEMENT Optimizer=HINT: FIRST_ROWS (Cost=135 Card=8
  2 Bytes=4100)
 
   10   TABLE ACCESS (BY INDEX ROWID) OF 'DEPT' (Cost=135 Card=1 B
  ytes=30)
 
   21 NESTED LOOPS (Cost=135 Card=82 Bytes=4100)
   32   TABLE ACCESS (FULL) OF 'EMP' (Cost=2 Card=82 Bytes=164
  0)
 
   42   BITMAP CONVERSION (TO ROWIDS)
   54 BITMAP INDEX (SINGLE VALUE) OF 'DEPT_DEPTNO'
 
 
 


On 2004.01.06 14:49, Jonathan Lewis wrote:
> 
> Note in-line.
> 
> Regards
> 
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
> 
>   The educated person is not the person
>   who can answer the questions, but the
>   person who can question the answers -- T. Schick Jr
> 
> 
> One-day tutorials:
> http://www.jlcomp.demon.co.uk/tutorial.html
> 
> 
> Three-day seminar:
> see http://www.jlcomp.demon.co.uk/seminar.html
> UK___November
> 
> 
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 06, 2004 6:59 PM
> 
> 
> > Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to
> all other
> > methos despite the price.
> >
> 
> Unless the alternative is a full tablescan on the inner
> table - in which case merge or hash joins can be
> considered.
> 
> The question itself is non-trivial, as the cost of
> a nested loop is:
> Cost of outer acquisition  +
> Cost of inner access * cardinality of outer acquisition.
> 
> But the cost of a merge join is:
> Cost of first acquisition + cost of first sort +
> Cost of second acquisition + cost of second sort +
> Cost of merge
> 
> It seems likely that if the first table returned 1 or 2 rows,
> then a nested loop with FTS could be cheaper than a
> sort merge, but if the outer table returned 3 Oracle would
> switch to a sort merge.  (Assuming equijoin).
> 
> On the other hand, if the second table required a very
> large sort, I'm sure you could engineer a sort_area_size
> that would make the sort cost more than three times the
> cost of a simple tablescan - which means you could change
> the access path by changing the sort_area_size.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jonathan Lewis
>   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: OCP Question (Perf Tuning)

[DENNIS WILLIAMS]

What I have heard is that all the OCP questions are taken from the Oracle
University Student Guide. After all, you wouldn't you expect the class to
prepare you? Someone suggested that you "think like a computer". Well, for
the philosophy behind the exam, "think like an organization", namely Oracle
University.
   I can't find anything nearly this detailed in the Student Guide,
therefore I conclude that this question will not appear on the exam.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, January 06, 2004 1:34 PM
To: Multiple recipients of list ORACLE-L


thought so, I'm not 100% certain the OCP will say that though. alot of
inaccuracies in that test.

btw, Ive been playing with first_rows lately. I've noticed that it has a
preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in
some test cases where you have two tables approximately 3m and 1.5m rows in
size, that INDEX RANGE SCAN actually returns the first 25 or so records
faster, than 'INDEX FULL SCAN', there by making FIRST_ROWS, inferior.

Surprised me. I've read some docs on this and I think that a range scan is
always preferably when you only want a few rows? What am I missing?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06, 2004 1:59 PM


> Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to
all other
> methos despite the price.
>
> On 2004.01.06 13:44, Jay Wade wrote:
> > Hello:
> >
> > I was looking through some OCP questions posted on the web and came
across
> > the one below.
> > I believe the answer is (D), because the join type would be dependent on
the
> > number of rows within the table.  Is this correct or does the
OPTIMIZER_MODE
> > set to FIRST_ROWS alter this behavior?
> >
> >
> > The cost-based optimizer can choose between a nested loops join and a
sort
> > merge join operation. All tables are analyzed and the OPTIMIZER_MODE is
set
> > to FIRST_ROWS. Which execution plan will be the result?
> >
> > a. The sort-merge join.
> >
> > b. The nested loops join.
> >
> > c. This depends on some sort parameter values.
> >
> > d. This depends on the number of rows in each table.
> >
> > _
> > Check your PC for viruses with the FREE McAfee online computer scan.
> > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jay Wade
> >   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: Ryan
  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: DENNIS WILLIAMS
  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

RE: OCP Question (Perf Tuning)

[Paula_Stankus]

FIRST_ROWS would alter the behavior regardless of the number of rows.  

-Original Message-
Jay Wade
Sent: Tuesday, January 06, 2004 1:44 PM
To: Multiple recipients of list ORACLE-L


Hello:

I was looking through some OCP questions posted on the web and came across 
the one below.
I believe the answer is (D), because the join type would be dependent on the 
number of rows within the table.  Is this correct or does the OPTIMIZER_MODE 
set to FIRST_ROWS alter this behavior?


The cost-based optimizer can choose between a nested loops join and a sort 
merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set 
to FIRST_ROWS. Which execution plan will be the result?

a. The sort-merge join.

b. The nested loops join.

c. This depends on some sort parameter values.

d. This depends on the number of rows in each table.

_
Check your PC for viruses with the FREE McAfee online computer scan.  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Wade
  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: OCP Question (Perf Tuning)

[Jonathan Lewis]

Note in-line.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06, 2004 6:59 PM


> Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to
all other
> methos despite the price.
>

Unless the alternative is a full tablescan on the inner
table - in which case merge or hash joins can be
considered.

The question itself is non-trivial, as the cost of
a nested loop is:
Cost of outer acquisition  +
Cost of inner access * cardinality of outer acquisition.

But the cost of a merge join is:
Cost of first acquisition + cost of first sort +
Cost of second acquisition + cost of second sort +
Cost of merge

It seems likely that if the first table returned 1 or 2 rows,
then a nested loop with FTS could be cheaper than a
sort merge, but if the outer table returned 3 Oracle would
switch to a sort merge.  (Assuming equijoin).

On the other hand, if the second table required a very
large sort, I'm sure you could engineer a sort_area_size
that would make the sort cost more than three times the
cost of a simple tablescan - which means you could change
the access path by changing the sort_area_size.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  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: OCP Question (Perf Tuning)

[Stephen.Lee]

Think like a computer.
"Which execution plan will be the result?"
result of what?
an insert statement?

-- 
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: OCP Question (Perf Tuning)

[Ryan]

thought so, I'm not 100% certain the OCP will say that though. alot of
inaccuracies in that test.

btw, Ive been playing with first_rows lately. I've noticed that it has a
preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in
some test cases where you have two tables approximately 3m and 1.5m rows in
size, that INDEX RANGE SCAN actually returns the first 25 or so records
faster, than 'INDEX FULL SCAN', there by making FIRST_ROWS, inferior.

Surprised me. I've read some docs on this and I think that a range scan is
always preferably when you only want a few rows? What am I missing?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06, 2004 1:59 PM


> Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to
all other
> methos despite the price.
>
> On 2004.01.06 13:44, Jay Wade wrote:
> > Hello:
> >
> > I was looking through some OCP questions posted on the web and came
across
> > the one below.
> > I believe the answer is (D), because the join type would be dependent on
the
> > number of rows within the table.  Is this correct or does the
OPTIMIZER_MODE
> > set to FIRST_ROWS alter this behavior?
> >
> >
> > The cost-based optimizer can choose between a nested loops join and a
sort
> > merge join operation. All tables are analyzed and the OPTIMIZER_MODE is
set
> > to FIRST_ROWS. Which execution plan will be the result?
> >
> > a. The sort-merge join.
> >
> > b. The nested loops join.
> >
> > c. This depends on some sort parameter values.
> >
> > d. This depends on the number of rows in each table.
> >
> > _
> > Check your PC for viruses with the FREE McAfee online computer scan.
> > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jay Wade
> >   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: Ryan
  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: OCP Question (Perf Tuning)

[Mladen Gogala]

Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other
methos despite the price.

On 2004.01.06 13:44, Jay Wade wrote:
> Hello:
> 
> I was looking through some OCP questions posted on the web and came across 
> the one below.
> I believe the answer is (D), because the join type would be dependent on the 
> number of rows within the table.  Is this correct or does the OPTIMIZER_MODE 
> set to FIRST_ROWS alter this behavior?
> 
> 
> The cost-based optimizer can choose between a nested loops join and a sort 
> merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set 
> to FIRST_ROWS. Which execution plan will be the result?
> 
> a. The sort-merge join.
> 
> b. The nested loops join.
> 
> c. This depends on some sort parameter values.
> 
> d. This depends on the number of rows in each table.
> 
> _
> Check your PC for viruses with the FREE McAfee online computer scan.  
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jay Wade
>   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: OCP Question (Perf Tuning)

[Ryan]

D is probably the answer, but most of the time oracle will choose nested
loop.

Beware the OCP tuning test. It is completely and totally inaccurate. I
emailed the author of the Sybex tuning book and he agreed with me. He said
he wrote the book to the test and knows its garbage.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 06, 2004 1:44 PM


> Hello:
>
> I was looking through some OCP questions posted on the web and came across
> the one below.
> I believe the answer is (D), because the join type would be dependent on
the
> number of rows within the table.  Is this correct or does the
OPTIMIZER_MODE
> set to FIRST_ROWS alter this behavior?
>
>
> The cost-based optimizer can choose between a nested loops join and a sort
> merge join operation. All tables are analyzed and the OPTIMIZER_MODE is
set
> to FIRST_ROWS. Which execution plan will be the result?
>
> a. The sort-merge join.
>
> b. The nested loops join.
>
> c. This depends on some sort parameter values.
>
> d. This depends on the number of rows in each table.
>
> _
> Check your PC for viruses with the FREE McAfee online computer scan.
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jay Wade
>   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: Ryan
  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: OCP 8i

[Nelson, Allan]

Oh, thanks

-Original Message-
Jose Luis Delgado
Sent: Wednesday, December 17, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L


Hm...

try this link:

http://www.oracle.com/education/certification/faq/index.html?faq5.html

HTH
JL

--- "Nelson, Allan" <[EMAIL PROTECTED]> wrote:
> Hi Listers,
> 
> Does anyone know how long the 8i OCP tests will be
> offered.  I can't
> seem to find it on the Oracle Education Web site.
> 
> Thanks
> 
> > Allan L. Nelson
> > Oracle DBA
> > M-I L.L.C.
> > (832) 295-2238 office 
> > (832) 351-4180 fax 
> > [EMAIL PROTECTED] 
> > 
> > 
> > 
> 
>

__
> This email is intended solely for the person or
> entity to which it is addressed and may contain
> confidential and/or privileged information.
> Copying, forwarding or distributing this message by
> persons or entities other than the addressee is
> prohibited. If you have received this email in
> error, please contact the sender immediately and
> delete the material from any computer.  This email
> may have been monitored for policy compliance. 
> [021216]
> 


__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  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: Nelson, Allan
  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: OCP 8i

[Jose Luis Delgado]

Hm...

try this link:

http://www.oracle.com/education/certification/faq/index.html?faq5.html

HTH
JL

--- "Nelson, Allan" <[EMAIL PROTECTED]> wrote:
> Hi Listers,
> 
> Does anyone know how long the 8i OCP tests will be
> offered.  I can't
> seem to find it on the Oracle Education Web site.
> 
> Thanks
> 
> > Allan L. Nelson
> > Oracle DBA
> > M-I L.L.C. 
> > (832) 295-2238 office 
> > (832) 351-4180 fax 
> > [EMAIL PROTECTED] 
> > 
> > 
> > 
> 
>
__
> This email is intended solely for the person or
> entity to which it is addressed and may contain
> confidential and/or privileged information. 
> Copying, forwarding or distributing this message by
> persons or entities other than the addressee is
> prohibited. If you have received this email in
> error, please contact the sender immediately and
> delete the material from any computer.  This email
> may have been monitored for policy compliance. 
> [021216]
> 


__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  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: OCP 9i New Features for DBAs

[Dunscombe, Chris]

Jared,
 
I didn't make a detailed list but where I clearly noticed the inaccuracies
was in the sample exam questions at the back of the book e.g.
 
In which version of Oracle was hash partitioning introduced?
 
A) 7
B) 8
C) 8i
D) 9i
 
Answer D. The real answer as we know is C.
 
Which statement is true about the TIMESTAMP WITH TIME ZONE datatype?
 
A) It represents absolute time.
B) In addition to the date and time, you can store the time zone
displacement (offset), which requires additional bytes of storage.
C) In addition to the date and time, you can store the time zone
displacement (offset), without consuming additional bytes of storage.
D) You can use the NLS_TIMESTAMP_TZ_FORMAT initialisation parameter to
specify the default timestamp format for retrieval.
 
Answer C. The real answer is B.
 
What this means is that you need to checkout the answers when marking
yourself just to be on the safe side. I must point out that on a couple of
occaisions the book was right when I initially thought it was wrong. 
 
Cheers,
 
Chris

-Original Message-
Sent: 20 November 2003 18:35
To: Multiple recipients of list ORACLE-L



Chris, 

Care to share details on the inaccuracies? 

Jared 




"Dunscombe, Chris" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 


 11/20/2003 02:44 AM 
 Please respond to ORACLE-L 



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



Ryan,

I took my exam yesterday and passed!! I used the Oracle Press -  OCP Oracle
9i Database: New Features for Administrators Exam Guide book. Even though
there are a number of inaccuracies it was good preparation especially the
sample exams it provides. Regarding 9.2 vs 9.0 content in the exam it all
seemed to be 9.0.

Hope all goes well when you take your exam.

Cheers,

Chris 

-Original Message-
Sent: 12 November 2003 18:25
To: Multiple recipients of list ORACLE-L


im going to take it soon. I was going to just read howard rogers guide then
the otn one. 

you think that is enough? I just want to pass it and get my piece of paper.
I already know the 9i stuff that is useful to me. 
> 
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/11/12 Wed PM 12:19:32 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: OCP 9i New Features for DBAs
> 
> Chris
>I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle
> would have had to go back and recreate the test. And Oracle would have
felt
> compelled to change the name of the test. However, I think it possible
that
> any question whose answer would be true for 9.0 but false for 9.2 might be
> removed.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 12, 2003 10:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> I'm currently studying for this exam but can't find info to say whether
the
> exam covers 9.2 or just 9.0. Anyone any clues
> 
> Thanks,
> 
> Chris Dunscombe
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Dunscombe, Chris
>   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: DENNIS WILLIAMS
>   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-- Mai

Re: RE: OCP 9i New Features for DBAs

[Tanel Poder]

Yeah, tell me, too!
 
I'm about to teach a 5-day course for passing OCP 
in January. Don't mind if I post completely inaccurate answers to this list at 
this time, I just have to change my way of thinking for then ;)
 
Tanel.
 

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, November 20, 2003 8:35 
  PM
  Subject: RE: RE: OCP 9i New Features for 
  DBAs
  Chris, Care to share details on the inaccuracies? 
  Jared 
  


  
  "Dunscombe, Chris" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 11/20/2003 02:44 AM 
 Please respond to ORACLE-L 
                  To:     
   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:   
        
              Subject:        RE: RE: OCP 9i 
New Features for DBAsRyan,I took my exam yesterday and passed!! I 
  used the Oracle Press -  OCP Oracle9i Database: New Features for 
  Administrators Exam Guide book. Even thoughthere are a number of 
  inaccuracies it was good preparation especially thesample exams it 
  provides. Regarding 9.2 vs 9.0 content in the exam it allseemed to be 
  9.0.Hope all goes well when you take your 
  exam.Cheers,Chris -Original Message-Sent: 
  12 November 2003 18:25To: Multiple recipients of list 
  ORACLE-Lim going to take it soon. I was going to just read howard 
  rogers guide thenthe otn one. you think that is enough? I just 
  want to pass it and get my piece of paper.I already know the 9i stuff that 
  is useful to me. > > From: DENNIS WILLIAMS 
  <[EMAIL PROTECTED]>> Date: 2003/11/12 Wed PM 12:19:32 
  EST> To: Multiple recipients of list ORACLE-L 
  <[EMAIL PROTECTED]>> Subject: RE: OCP 9i New Features for 
  DBAs> > Chris>    I'm betting on 9.0. For it to 
  cover 9.2 would have meant that Oracle> would have had to go back and 
  recreate the test. And Oracle would havefelt> compelled to change 
  the name of the test. However, I think it possiblethat> any 
  question whose answer would be true for 9.0 but false for 9.2 might be> 
  removed.> > Dennis Williams> DBA> Lifetouch, 
  Inc.> [EMAIL PROTECTED] > > -Original 
  Message-> Sent: Wednesday, November 12, 2003 10:24 AM> To: 
  Multiple recipients of list ORACLE-L> > > Hi,> 
  > I'm currently studying for this exam but can't find info to say 
  whetherthe> exam covers 9.2 or just 9.0. Anyone any clues> 
  > Thanks,> > Chris Dunscombe> > > -- 
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net> 
  -- > Author: Dunscombe, Chris>   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: DENNIS WILLIAMS>   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.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).-- Please see the official 
  ORACLE-L FAQ: http://www.orafaq.net-- Author: Dunscombe, 
  Chris INET: [EMAIL PROTECTED]Fat Ci

RE: RE: OCP 9i New Features for DBAs

[Jared . Still]

Chris,

Care to share details on the inaccuracies?

Jared







"Dunscombe, Chris" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 11/20/2003 02:44 AM
 Please respond to ORACLE-L

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


Ryan,

I took my exam yesterday and passed!! I used the Oracle Press -  OCP Oracle
9i Database: New Features for Administrators Exam Guide book. Even though
there are a number of inaccuracies it was good preparation especially the
sample exams it provides. Regarding 9.2 vs 9.0 content in the exam it all
seemed to be 9.0.

Hope all goes well when you take your exam.

Cheers,

Chris 

-Original Message-
Sent: 12 November 2003 18:25
To: Multiple recipients of list ORACLE-L


im going to take it soon. I was going to just read howard rogers guide then
the otn one. 

you think that is enough? I just want to pass it and get my piece of paper.
I already know the 9i stuff that is useful to me. 
> 
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/11/12 Wed PM 12:19:32 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: OCP 9i New Features for DBAs
> 
> Chris
>    I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle
> would have had to go back and recreate the test. And Oracle would have
felt
> compelled to change the name of the test. However, I think it possible
that
> any question whose answer would be true for 9.0 but false for 9.2 might be
> removed.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 12, 2003 10:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> I'm currently studying for this exam but can't find info to say whether
the
> exam covers 9.2 or just 9.0. Anyone any clues
> 
> Thanks,
> 
> Chris Dunscombe
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Dunscombe, Chris
>   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: DENNIS WILLIAMS
>   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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dunscombe, Chris
  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: OCP 9i New Features for DBAs

[Dunscombe, Chris]

Ryan,

I took my exam yesterday and passed!! I used the Oracle Press -  OCP Oracle
9i Database: New Features for Administrators Exam Guide book. Even though
there are a number of inaccuracies it was good preparation especially the
sample exams it provides. Regarding 9.2 vs 9.0 content in the exam it all
seemed to be 9.0.

Hope all goes well when you take your exam.

Cheers,

Chris 

-Original Message-
Sent: 12 November 2003 18:25
To: Multiple recipients of list ORACLE-L


im going to take it soon. I was going to just read howard rogers guide then
the otn one. 

you think that is enough? I just want to pass it and get my piece of paper.
I already know the 9i stuff that is useful to me. 
> 
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/11/12 Wed PM 12:19:32 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: OCP 9i New Features for DBAs
> 
> Chris
>I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle
> would have had to go back and recreate the test. And Oracle would have
felt
> compelled to change the name of the test. However, I think it possible
that
> any question whose answer would be true for 9.0 but false for 9.2 might be
> removed.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 12, 2003 10:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> I'm currently studying for this exam but can't find info to say whether
the
> exam covers 9.2 or just 9.0. Anyone any clues
> 
> Thanks,
> 
> Chris Dunscombe
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Dunscombe, Chris
>   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: DENNIS WILLIAMS
>   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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dunscombe, Chris
  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: OCP 9i New Features for DBAs

[ryan_oracle]

im going to take it soon. I was going to just read howard rogers guide then the otn 
one. 

you think that is enough? I just want to pass it and get my piece of paper. I already 
know the 9i stuff that is useful to me. 
> 
> From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Date: 2003/11/12 Wed PM 12:19:32 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: OCP 9i New Features for DBAs
> 
> Chris
>I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle
> would have had to go back and recreate the test. And Oracle would have felt
> compelled to change the name of the test. However, I think it possible that
> any question whose answer would be true for 9.0 but false for 9.2 might be
> removed.
> 
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Wednesday, November 12, 2003 10:24 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi,
> 
> I'm currently studying for this exam but can't find info to say whether the
> exam covers 9.2 or just 9.0. Anyone any clues
> 
> Thanks,
> 
> Chris Dunscombe
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Dunscombe, Chris
>   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: DENNIS WILLIAMS
>   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: OCP 9i New Features for DBAs

[DENNIS WILLIAMS]

Chris
   I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle
would have had to go back and recreate the test. And Oracle would have felt
compelled to change the name of the test. However, I think it possible that
any question whose answer would be true for 9.0 but false for 9.2 might be
removed.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 12, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L


Hi,

I'm currently studying for this exam but can't find info to say whether the
exam covers 9.2 or just 9.0. Anyone any clues

Thanks,

Chris Dunscombe


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dunscombe, Chris
  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: DENNIS WILLIAMS
  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: OCP 9i New Features for DBAs

[Pete Sharman]

Runs on 9.2 but there's nothing specific to 9.2 rather than 9.0, IIRC.


Pete

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long term Oracle DBA.



-Original Message-
Dunscombe, Chris
Sent: Thursday, November 13, 2003 3:24 AM
To: Multiple recipients of list ORACLE-L


Hi,

I'm currently studying for this exam but can't find info to say whether
the exam covers 9.2 or just 9.0. Anyone any clues

Thanks,

Chris Dunscombe


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dunscombe, Chris
  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: Pete Sharman
  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: OCP 7.3 & 8 upgrade to 9i

[Jared . Still]

Thanks, didn't know this was available.







Ora NT DBA <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/06/2003 02:54 PM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: OCP 7.3 & 8 upgrade to 9i


Hi All,

>From the Oracle Education Certification Page:

http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html

Shows 4 possible tests:
Oracle9i DBA OCP Upgrade Path
Upgrade exams for Oracle7.3, Oracle8 and Oracle8i DBA OCPs. 
In order to make the process of staying current as an Oracle Certified technical professional, those already certified on previous releases of Oracle may upgrade to each future release by simply completing one migration exam. Listed below are the migration exams that are currently available to previously certified Oracle DBAs. 
Please review the listings below for more specific information. Generally, one exam is required for OCPs to upgrade to each new release of an Oracle DBA track. For example, one exam upgrades the Oracle7.3 credential to Oracle8, one exam upgrades the Oracle8 credential to Oracle8i, and one exam upgrades the Oracle8i credential to Oracle9i. 
Oracle7.3 and Oracle8 DBA OCPs now have another option to upgrade their DBA OCP credential directly to Oracle9i: Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs. This exam will be available beginning October 2003. 
Select the exam title below to view the exam objectives. 

Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i
Exam #1Z0-035 Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs
Available October 2003
Upgrade Exam: Oracle7.3 to Oracle8 DBA OCP 
Exam #1Z0-010 Oracle8 New Features for Administrators
Upgrade Exam: Oracle8 to Oracle8i DBA OCP
Exam #1Z0-020 Oracle8i New Features for Administrators 
Upgrade Exam: Oracle8i to Oracle9i DBA OCP
Exam #1Z0-030 Oracle9i Database: New Features for Administrators
Hope this helps,
John

[EMAIL PROTECTED] wrote:

That sounds very interesting. 

I have an 7.3 OCP ( beta exams at OOW ), but don't have 8.0 or 8i. 

Being able to skip the 8/8i exams should make this attractive to many folks. 

Jared 






"Ron Rogers" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED] 
 10/06/2003 08:39 AM 
 Please respond to ORACLE-L 
        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
        cc:         
        Subject:        OCP 7.3 & 8 upgrade to 9i



List,
While looking at the Oracle Education site I located a link about the
Paris OpenWorld this month and the OCP upgrades. In particular was the
upgrade that by-passes the 8 to 8i step on the way to 9i.
http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html
"Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs"

Of the list members that attended Open World in San Francisco, was this
available there also? 
I would like to have this test also available to the DBA's that can
not attend an open world meeting. It could be a great help if it
eliminates the cost of one test along the way to an upgrade of the OCP.

It also raises the questions about the training. A normal new features
course is 5 days in length and costs BIG BUCK$. This course is less than
a day and cheap. What do they do give the answers and hope you remember
them later in the day when you take the test?

Ron

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
 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: OCP 7.3 & 8 upgrade to 9i

[Ora NT DBA]

Hi All,

>From the Oracle Education Certification Page:

http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html

Shows 4 possible tests:
Oracle9i
DBA OCP Upgrade Path
Upgrade exams for Oracle7.3, Oracle8 and Oracle8i DBA OCPs.

In order to make the process of staying
current as an Oracle Certified technical professional, those already
certified on previous releases of Oracle may upgrade to each future
release by simply completing one migration exam. Listed below are the
migration exams that are currently available to previously certified
Oracle DBAs. 
 Please review the listings below for more
specific information. Generally, one exam is required for OCPs to
upgrade to each new release of an Oracle DBA track. For example, one
exam upgrades the Oracle7.3 credential to Oracle8, one exam upgrades
the Oracle8 credential to Oracle8i, and one exam upgrades the Oracle8i credential to
Oracle9i.  
Oracle7.3 and Oracle8 DBA OCPs now have
another option to upgrade their DBA OCP credential directly to Oracle9i: Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs.
This exam will be available beginning October 2003. 
Select the exam title below to view the exam
objectives.  

  Upgrade Exam: Oracle7.3 and Oracle8 DBA
OCPs to Oracle9i
Exam #1Z0-035 Oracle9i DBA New Features
for Oracle7.3 and Oracle8 OCPs
Available October 2003
  Upgrade Exam: Oracle7.3 to Oracle8 DBA OCP

Exam #1Z0-010 Oracle8 New Features for
Administrators
  Upgrade Exam: Oracle8 to Oracle8i DBA OCP
Exam #1Z0-020 Oracle8i New Features for
Administrators 
  Upgrade Exam: Oracle8i to Oracle9i DBA OCP
Exam #1Z0-030 Oracle9i Database: New
Features for Administrators

Hope this helps,
John

[EMAIL PROTECTED] wrote:

  That sounds very interesting.
  
  
  I have an 7.3 OCP ( beta exams at
OOW ), but don't have 8.0 or 8i.
  
  
  Being able to skip the 8/8i exams
should make this attractive to many folks.
  
  
  Jared
  
  
  
  
  

  



"Ron Rogers"
<[EMAIL PROTECTED]>

Sent by: [EMAIL PROTECTED]
 10/06/2003 08:39 AM

 Please respond to ORACLE-L



        

        To:        Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>

        cc:        

        Subject:        OCP
7.3 & 8 upgrade to 9i
  

  
  
  
  
  List,
While looking at the Oracle Education site I located a link about the
Paris OpenWorld this month and the OCP upgrades. In particular was the
upgrade that by-passes the 8 to 8i step on the way to 9i.
http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html
"Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs"
  
Of the list members that attended Open World in San Francisco, was this
available there also? 
I would like to have this test also available to the DBA's that can
not attend an open world meeting. It could be a great help if it
eliminates the cost of one test along the way to an upgrade of the OCP.
  
It also raises the questions about the training. A normal new features
course is 5 days in length and costs BIG BUCK$. This course is less than
a day and cheap. What do they do give the answers and hope you remember
them later in the day when you take the test?
  
Ron
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
 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: OCP 7.3 & 8 upgrade to 9i

[Jared . Still]

That sounds very interesting.

I have an 7.3 OCP ( beta exams at OOW ), but don't have 8.0 or 8i.

Being able to skip the 8/8i exams should make this attractive to many folks.

Jared







"Ron Rogers" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 10/06/2003 08:39 AM
 Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        OCP 7.3 & 8 upgrade to 9i


List,
 While looking at the Oracle Education site I located a link about the
Paris OpenWorld this month and the OCP upgrades. In particular was the
upgrade that by-passes the 8 to 8i step on the way to 9i.
http://www.oracle.com/education/certification/news/index.html?oowexamcram2003.html
"Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs"

Of the list members that attended Open World in San Francisco, was this
available there also? 
 I would like to have this test also available to the DBA's that can
not attend an open world meeting. It could be a great help if it
eliminates the cost of one test along the way to an upgrade of the OCP.

It also raises the questions about the training. A normal new features
course is 5 days in length and costs BIG BUCK$. This course is less than
a day and cheap. What do they do give the answers and hope you remember
them later in the day when you take the test?

Ron

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  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: OCP 7.3 & 8 upgrade to 9i

[Brian McGraw]

I actually sat for the beta of that exam, the week before OracleWorld.  I
haven't received my scores yet, so I doubt that it is actually being offered
to the general public yet.  But that *is* the plan.

Brian

-
| Brian McGraw  -+-  Senior DBA |
| mailto:[EMAIL PROTECTED] |
-

-Original Message-
Rogers
Sent: Monday, October 06, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L

List,
 While looking at the Oracle Education site I located a link about the
Paris OpenWorld this month and the OCP upgrades. In particular was the
upgrade that by-passes the 8 to 8i step on the way to 9i.
http://www.oracle.com/education/certification/news/index.html?oowexamcram200
3.html
"Upgrade Exam: Oracle7.3 and Oracle8 DBA OCPs to Oracle9i Exam #1Z0-035
Oracle9i DBA New Features for Oracle7.3 and Oracle8 OCPs"

Of the list members that attended Open World in San Francisco, was this
available there also? 
 I would like to have this test also available to the DBA's that can
not attend an open world meeting. It could be a great help if it
eliminates the cost of one test along the way to an upgrade of the OCP.

It also raises the questions about the training. A normal new features
course is 5 days in length and costs BIG BUCK$. This course is less than
a day and cheap. What do they do give the answers and hope you remember
them later in the day when you take the test?

Ron

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  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: Brian McGraw
  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: OCP Architecture question

[Jared Still]

Ah, the Sherlock Holmes method.  I've often used the same method
on multiple choice tests with meaningless questions and obscure
answers.

"When you have eliminated the impossible, whatever remains, however
improbable, must be the truth"

I think this is how I passed the Oracle 7 Beta tests, which 
were quite long.

Jared


On Fri, 2003-08-15 at 08:19, Wolfgang Breitling wrote:
> A lot of those multiple choice question are best approached from a reverse 
> standpoint, much like a lot of my recent election experiences. You look at 
> the choices and cross out the ones which are definitely not it until you 
> whittled it down to the number of supposedly correct choices you need. If 
> you don't like any of the choices you have to use those that you least not 
> like.
> 
> At 05:24 PM 8/14/2003 -0800, you wrote:
> >Im using the self test software and here is a question... I dont like the 
> >answers. Please tell me if Im wrong.
> >
> >Which Three methods can be used to avoid snapshot too old errors. This is 
> >for the 8i test.
> >
> >1. User larger extents
> >2. Increase MAXEXTENTS for existing rollback segments
> >3. Create rollback segments with higher optimal values
> >4. Create rollback segments iwth high minextents
> >5. Run long queries when transaction processing is high.
> >
> >Ruling out 5 is obvious. The test says its.
> >
> >1,3,4
> >
> >How does using large extents help this? What about a higher minextents value?
> 
> Wolfgang Breitling
> Oracle7, 8, 8i, 9i OCP DBA
> Centrex Consulting Corporation
> http://www.centrexcc.com
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Wolfgang Breitling
>   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: RE: OCP Architecture question

[DENNIS WILLIAMS]

Ryan
   I have found the actual OCP questions to be clearer. I think it is very
hard to develop a good multiple choice exam. And these are tricky because
the objective is to test more than simple memorization. You need to
administer it to many people and find out which questions aren't clear or
are easily misinterpreted. Oracle has the resources to do that, an
individual author isn't. My claim is that if you have mastered the material
enough to point out flaws with your preparation materials, dude you're ready
to pass the exam.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Friday, August 15, 2003 6:29 AM
To: Multiple recipients of list ORACLE-L


yeah thats what i figured... but having these certifications are good for my
career. 

thanks. I figured it was a stupid question. 
> 
> From: "Cary Millsap" <[EMAIL PROTECTED]>
> Date: 2003/08/15 Fri AM 01:14:23 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: OCP Architecture question
> 
> With respect to evaluating answer number one, it's a bad question,
> because you have know way to know whether the context is supposed to be
> 
>  
> 
> a)   assume a fixed rollback segment size, but use fewer, larger
> extents; or
> 
> b)   make the rollback segment larger by using the same number of
> larger extents.
> 
>  
> 
> In context (a), #1 is a bad answer. In context (b), it's a better
> answer, but it's still poor.
> 
>  
> 
> The thing that really chaps me about stupid certification questions like
> this is that no answer among the choices listed is really the right
> thing for you to try to do, which is:
> 
>  
> 
> FIX THE QUERY THAT'S TAKING SO LONG TO RUN.
> 
>  
> 
> In other words, make queries run quickly enough that they don't require
> multiple-hour-old undo blocks to produce read-consistent results.
> 
>  
> 
> Jacking around with rollback segments is just a kludge that will produce
> results far inferior to what you can achieve by attacking the query
> problem at its root.
> 
>  
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic <http://www.hotsos.com/training/clinic101>  101 in
> Sydney
> - Hotsos Symposium 2004 <http://www.hotsos.com/events/symposium/2004>
> March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
> 
> -Original Message-
> Tim Gorman
> Sent: Thursday, August 14, 2003 10:54 PM
> To: Multiple recipients of list ORACLE-L
> 
>  
> 
> They all allow the RBS to be bigger.  More space available for RBS
> roughly equals fewer ORA-01555, for most situations...
> 
> 
> 
> on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote:
> 
> Im using the self test software and here is a question... I dont like
> the answers. Please tell me if Im wrong.
> 
> Which Three methods can be used to avoid snapshot too old errors. This
> is for the 8i test. 
> 
> 1. User larger extents
> 2. Increase MAXEXTENTS for existing rollback segments
> 3. Create rollback segments with higher optimal values
> 4. Create rollback segments iwth high minextents
> 5. Run long queries when transaction processing is high. 
> 
> Ruling out 5 is obvious. The test says its. 
> 
> 1,3,4
> 
> How does using large extents help this? What about a higher minextents
> value? 
> 
>  
> 
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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: OCP Architecture question

[Wolfgang Breitling]

A lot of those multiple choice question are best approached from a reverse 
standpoint, much like a lot of my recent election experiences. You look at 
the choices and cross out the ones which are definitely not it until you 
whittled it down to the number of supposedly correct choices you need. If 
you don't like any of the choices you have to use those that you least not 
like.

At 05:24 PM 8/14/2003 -0800, you wrote:
Im using the self test software and here is a question... I dont like the 
answers. Please tell me if Im wrong.

Which Three methods can be used to avoid snapshot too old errors. This is 
for the 8i test.

1. User larger extents
2. Increase MAXEXTENTS for existing rollback segments
3. Create rollback segments with higher optimal values
4. Create rollback segments iwth high minextents
5. Run long queries when transaction processing is high.
Ruling out 5 is obvious. The test says its.

1,3,4

How does using large extents help this? What about a higher minextents value?
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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: OCP Architecture question

[Stephen Lee]

 
1.  Maybe, 
maybe not.  To make a point, take it to a ridiculous extreme: Suppose you 
have a tablespace of 100M with two rollback segments made of 1M extents 
sizes.  Then each segment must use 2M each (minextents must be at least 2) 
which means either segment could possibly grow to use 98M if needed 
(but not at the same time).  Now make the extent sizes 25M.  Then 
each segment uses 50M with no growth possibility.  Now you don't have 
the ability to extend a segment to 98M; so this could be bad.  But neither 
do you have a case where one segment can extend to 98M leaving the other poor 
segment stuck at 2M; so this could be good.
 
So  "It 
Depends."
 
2.  I think 
this addresses a different issue; i.e. "failed to extend..."
 
3.  
Essentially same reasoning as #1.
 
4.  
Essentially same reasoning as #1.
 
5.  No 
comment needed.

  -Original Message-From: Ryan 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, August 14, 2003 8:24 
  PMTo: Multiple recipients of list ORACLE-LSubject: OCP 
  Architecture question
  Im using the self test software and here is a 
  question... I dont like the answers. Please tell me if Im wrong.
   
  Which Three methods can be used to avoid snapshot 
  too old errors. This is for the 8i test. 
   
  1. User larger extents
  2. Increase MAXEXTENTS for existing rollback 
  segments
  3. Create rollback segments with higher optimal 
  values
  4. Create rollback segments iwth high 
  minextents
  5. Run long queries when transaction processing 
  is high. 
   
  Ruling out 5 is obvious. The test says its. 
  
   
  1,3,4
   
  How does using large extents help this? What 
  about a higher minextents value? 

Re: RE: OCP Architecture question

[rgaffuri]

i have all of it or 8i. this question was in architecture. I havent looked at the sql 
and pl/sql stuff since the cert test for that was a blowoff. 
> 
> From: "Ed Sherman" <[EMAIL PROTECTED]>
> Date: 2003/08/15 Fri AM 09:00:43 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: OCP Architecture question
> 
> Ryan,
> 
> I will research the answer but I have an urgent question.
> 
> Do you have SelfTest Software for the SQL and PL/SQL test or do you have the
> Architecure and Administration SelfTest Software?
> 
> Thanks,
> Ed
>   -Original Message-
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Ryan
>   Sent: Thursday, August 14, 2003 9:24 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: OCP Architecture question
> 
> 
>   Im using the self test software and here is a question... I dont like the
> answers. Please tell me if Im wrong.
> 
>   Which Three methods can be used to avoid snapshot too old errors. This is
> for the 8i test.
> 
>   1. User larger extents
>   2. Increase MAXEXTENTS for existing rollback segments
>   3. Create rollback segments with higher optimal values
>   4. Create rollback segments iwth high minextents
>   5. Run long queries when transaction processing is high.
> 
>   Ruling out 5 is obvious. The test says its.
> 
>   1,3,4
> 
>   How does using large extents help this? What about a higher minextents
> value?
> 
> 



Ryan,
 
I will 
research the answer but I have an urgent question.
 
Do you 
have SelfTest Software for the SQL and PL/SQL test or do you have the 
Architecure and Administration SelfTest Software?
 
Thanks,
Ed

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of RyanSent: 
  Thursday, August 14, 2003 9:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OCP Architecture question
  Im using the self test software and here is a 
  question... I dont like the answers. Please tell me if Im wrong.
   
  Which Three methods can be used to avoid snapshot 
  too old errors. This is for the 8i test. 
   
  1. User larger extents
  2. Increase MAXEXTENTS for existing rollback 
  segments
  3. Create rollback segments with higher optimal 
  values
  4. Create rollback segments iwth high 
  minextents
  5. Run long queries when transaction processing 
  is high. 
   
  Ruling out 5 is obvious. The test says its. 
  
   
  1,3,4
   
  How does using large extents help this? What 
  about a higher minextents value? 

RE: OCP Architecture question

[Ed Sherman]

Ryan,
 
I will 
research the answer but I have an urgent question.
 
Do you 
have SelfTest Software for the SQL and PL/SQL test or do you have the 
Architecure and Administration SelfTest Software?
 
Thanks,
Ed

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of RyanSent: 
  Thursday, August 14, 2003 9:24 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OCP Architecture question
  Im using the self test software and here is a 
  question... I dont like the answers. Please tell me if Im wrong.
   
  Which Three methods can be used to avoid snapshot 
  too old errors. This is for the 8i test. 
   
  1. User larger extents
  2. Increase MAXEXTENTS for existing rollback 
  segments
  3. Create rollback segments with higher optimal 
  values
  4. Create rollback segments iwth high 
  minextents
  5. Run long queries when transaction processing 
  is high. 
   
  Ruling out 5 is obvious. The test says its. 
  
   
  1,3,4
   
  How does using large extents help this? What 
  about a higher minextents value? 

Re: RE: OCP Architecture question

[rgaffuri]

yeah thats what i figured... but having these certifications are good for my career. 

thanks. I figured it was a stupid question. 
> 
> From: "Cary Millsap" <[EMAIL PROTECTED]>
> Date: 2003/08/15 Fri AM 01:14:23 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: OCP Architecture question
> 
> With respect to evaluating answer number one, it's a bad question,
> because you have know way to know whether the context is supposed to be
> 
>  
> 
> a)   assume a fixed rollback segment size, but use fewer, larger
> extents; or
> 
> b)   make the rollback segment larger by using the same number of
> larger extents.
> 
>  
> 
> In context (a), #1 is a bad answer. In context (b), it's a better
> answer, but it's still poor.
> 
>  
> 
> The thing that really chaps me about stupid certification questions like
> this is that no answer among the choices listed is really the right
> thing for you to try to do, which is:
> 
>  
> 
> FIX THE QUERY THAT'S TAKING SO LONG TO RUN.
> 
>  
> 
> In other words, make queries run quickly enough that they don't require
> multiple-hour-old undo blocks to produce read-consistent results.
> 
>  
> 
> Jacking around with rollback segments is just a kludge that will produce
> results far inferior to what you can achieve by attacking the query
> problem at its root.
> 
>  
> 
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> 
> Upcoming events:
> - Hotsos Clinic <http://www.hotsos.com/training/clinic101>  101 in
> Sydney
> - Hotsos Symposium 2004 <http://www.hotsos.com/events/symposium/2004>
> March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
> 
> -Original Message-
> Tim Gorman
> Sent: Thursday, August 14, 2003 10:54 PM
> To: Multiple recipients of list ORACLE-L
> 
>  
> 
> They all allow the RBS to be bigger.  More space available for RBS
> roughly equals fewer ORA-01555, for most situations...
> 
> 
> 
> on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote:
> 
> Im using the self test software and here is a question... I dont like
> the answers. Please tell me if Im wrong.
> 
> Which Three methods can be used to avoid snapshot too old errors. This
> is for the 8i test. 
> 
> 1. User larger extents
> 2. Increase MAXEXTENTS for existing rollback segments
> 3. Create rollback segments with higher optimal values
> 4. Create rollback segments iwth high minextents
> 5. Run long queries when transaction processing is high. 
> 
> Ruling out 5 is obvious. The test says its. 
> 
> 1,3,4
> 
> How does using large extents help this? What about a higher minextents
> value? 
> 
>  
> 
> 
> 
Title: Re: OCP Architecture question








With respect to evaluating answer number
one, it’s a bad question, because you have know way to know whether the
context is supposed to be

 

a)  
assume a fixed rollback
segment size, but use fewer, larger extents; or

b)  
make the rollback segment
larger by using the same number of larger extents.

 

In context (a), #1 is a bad answer. In
context (b), it’s a better answer, but it’s still poor.

 

The thing that really chaps me about stupid
certification questions like this is that no answer among the choices listed is
really the right thing for you to try to do, which is:

 

FIX THE QUERY THAT’S
TAKING SO LONG TO RUN.

 

In other words, make queries run quickly
enough that they don’t require multiple-hour-old undo blocks to produce
read-consistent results.

 

Jacking around with rollback segments is
just a kludge that will produce results far inferior to what you can achieve by
attacking the query problem at its root.

 



Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101
in Sydney
- Hotsos Symposium 2004
March 7–10 Dallas
- Visit www.hotsos.com for schedule details...



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tim
Gorman
Sent: Thursday, August 14, 2003
10:54 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: OCP Architecture
question

 

They
all allow the RBS to be bigger.  More space available for RBS roughly
equals fewer ORA-01555, for most situations...



on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote:

Im
using the self test software and here is a question... I dont like the answers.
Please tell me if Im wrong.

Which Three methods can be used to avoid snapshot too old errors. This
is for the 8i test. 

1. User larger extents
2. Increase MAXEXTENTS for existing rollback segments
3. Create rollback segments with higher optimal values
4. Create rollback segments iwth high minextents
5. Run long queries when transaction processing is high. 

Ruling out 5 is obvious. The test says its. 

1,3,4

How does using large extents help this? What about a higher minextents
value? 

 

RE: OCP Architecture question

[Cary Millsap]

Title: Re: OCP Architecture question








With respect to evaluating answer number
one, it’s a bad question, because you have know way to know whether the
context is supposed to be

 

a)  
assume a fixed rollback
segment size, but use fewer, larger extents; or

b)  
make the rollback segment
larger by using the same number of larger extents.

 

In context (a), #1 is a bad answer. In
context (b), it’s a better answer, but it’s still poor.

 

The thing that really chaps me about stupid
certification questions like this is that no answer among the choices listed is
really the right thing for you to try to do, which is:

 

FIX THE QUERY THAT’S
TAKING SO LONG TO RUN.

 

In other words, make queries run quickly
enough that they don’t require multiple-hour-old undo blocks to produce
read-consistent results.

 

Jacking around with rollback segments is
just a kludge that will produce results far inferior to what you can achieve by
attacking the query problem at its root.

 



Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic 101
in Sydney
- Hotsos Symposium 2004
March 7–10 Dallas
- Visit www.hotsos.com for schedule details...



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tim
Gorman
Sent: Thursday, August 14, 2003
10:54 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: OCP Architecture
question

 

They
all allow the RBS to be bigger.  More space available for RBS roughly
equals fewer ORA-01555, for most situations...



on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote:

Im
using the self test software and here is a question... I dont like the answers.
Please tell me if Im wrong.

Which Three methods can be used to avoid snapshot too old errors. This
is for the 8i test. 

1. User larger extents
2. Increase MAXEXTENTS for existing rollback segments
3. Create rollback segments with higher optimal values
4. Create rollback segments iwth high minextents
5. Run long queries when transaction processing is high. 

Ruling out 5 is obvious. The test says its. 

1,3,4

How does using large extents help this? What about a higher minextents
value? 

 

Re: OCP Architecture question

[Tim Gorman]

Title: Re: OCP Architecture question



They all allow the RBS to be bigger.  More space available for RBS roughly equals fewer ORA-01555, for most situations...



on 8/14/03 6:24 PM, Ryan at [EMAIL PROTECTED] wrote:

Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong.
 
Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 
 
1. User larger extents
2. Increase MAXEXTENTS for existing rollback segments
3. Create rollback segments with higher optimal values
4. Create rollback segments iwth high minextents
5. Run long queries when transaction processing is high. 
 
Ruling out 5 is obvious. The test says its. 
 
1,3,4
 
How does using large extents help this? What about a higher minextents value? 

RE: OCP Question

[Mercadante, Thomas F]

Jay,

I would guess B and E.  I see no reason for a redo-log switch.  Looks like a
trick question.  B is one correct answer.  The other correct is either E or
A.  I would go for E.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, August 05, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L


Hello:

I was going through some OCP questions and wanted to make sure that my 
answers where correct.
This question comes from a 3rd party testing site, I have been checking each

question against my study guides to make sure they are correct.

I've done some testing and think that my answers might be correct but would 
like to double check as well as get anyone elses option on the answers and 
the reasoning for option E.

When the status of the tablespace moves from read-only to read write, which 
tow events occur?
(Choose Two)

A) Redo-log switch must take place
B) Normal checkpoints on the file now occur
C) Oracle automatically marks the file for backup
D) All objects in the tablespace are checked for integrity
E) The the DBWn process writes to the data files of the tablespace


I believe the answers are A, B

Reason:
A) I tested moving the a tablespace from read-only to read write and have 
noticed a log switch after moving the tablespace to a writeable state.
B) Since it is on longer Read-Only it will be updated during the checkpoint 
process
C) Doesn't happen, at least in my reading or testing
D) No verify structure is issued, or any of the other oracle tools for 
object checking are used
E) I'm alittle unsure of this one, it should update the headers how since it

is in a Read Write mode, although this should only happen at a checkpoint 
right?


Thanks in Advance,
Jay

_
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Wade
  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: Mercadante, Thomas F
  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: OCP Test Order

[Paula_Stankus]

Title: RE: OCP Test Order





to tell the truth the networking exam is basically some rote memorization and the questions are straightforward - I prepared while waiting 1/2 hour to take exam at most.

The performance tuning exam is what I have been told to immediately forget by some certifiable guru's.  Basically, not all of it is incorrect but this will be one area you will be studying again from time to time as new versions and new information becomes available and with your own experiences - IMHO.  

Bottom-line:  Don't think it much matters the perf. tuning exam is slightly more to remember then networking.  Good luck.  Just get it done and don't fret too much about it.  It won't and shouldn't be your final studying by a long-shot.  

I did B&R first because it was my #1 priority and I believe the most applicable - good refresher.
I did Perf. tuning next.
I did networking as a "get this over with certification thing".


-Original Message-
From: Jay Wade [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 02, 2003 5:35 PM
To: Multiple recipients of list ORACLE-L
Subject: OCP Test Order



Hello:


I resently finished my 8i Backup and Recovery test and was thinking about 
taking the 8i Networking testing before performance tuning.  I was wondering 
if those of you that have taken both test feel that would be an ok choice of 
action or would taking performance tuning first be better?


Thanks In Advance,
jay


_
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Wade
  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: OCP Test Order

[DENNIS WILLIAMS]

Jay - Personally I did the Tuning exam next after B&R and saved the Network
for last because most of it is new to me. The B&R and Tuning exams share
quite a bit of material in terms of they both require a clear understanding
of the Oracle architecture, how the rollback, redo, SGA, etc. all interact.
Obviously the thrust of the questions are different, with the B&R
emphasizing integrity and Tuning emphasizing performance. Networking doesn't
share anything with the other modules other than it touches on MTS. So I
would vote to go ahead and hit the Tuning next.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Monday, June 02, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L


Hello:

I resently finished my 8i Backup and Recovery test and was thinking about 
taking the 8i Networking testing before performance tuning.  I was wondering

if those of you that have taken both test feel that would be an ok choice of

action or would taking performance tuning first be better?

Thanks In Advance,
jay

_
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Wade
  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: DENNIS WILLIAMS
  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: ocp discount

[Juan Miranda]

put 
OTN20 in the discount code

  -Mensaje original-De: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]En nombre de AKEnviado el: martes, 
  27 de mayo de 2003 18:45Para: Multiple recipients of list 
  ORACLE-LAsunto: ocp discount
  I heard/read they give 20% discount on ocp exam 
  fee if u are registered with technet .
  Can any body confirm that . How do I get that 
  discount ?
   
  -ak
   

Re: RE: ocp discount

[Shamita Singh]

Yes, that's it.
 
Shamita Singh
AK <[EMAIL PROTECTED]> wrote:




is it OTN20 ?
 
-ak

- Original Message - 
From: April Wells 
To: Multiple recipients of list ORACLE-L 
Sent: Tuesday, May 27, 2003 11:01 AM
Subject: RE: RE: ocp discount

when you signed up with technet there should have been an announcement or a splash screen that gave you a discount code... you have to type that in when you register for the tests.  Don't remember what the code was, off hand, but I remember it was delivered in one of those two manners. 
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need.
~ Jerry Gillies ~ 
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 27, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: ocp discount 
im registered with technet and when i signed up to take my tests with prometric? I was charged the same $125/test? > > From: April Wells <[EMAIL PROTECTED]> > Date: 2003/05/27 Tue PM 01:04:44 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: RE: ocp discount > > > yes they do. >  > to get it, you register with technet. > otn.oracle.com >  > > April Wells > Oracle DBA/Oracle Apps DBA > Corporate Systems > Amarillo Texas > !
> You will recognize your own path when you come upon it, because you will > suddenly have all the energy and imagination you will ever need. > > ~ Jerry Gillies ~ > > -Original Message- > Sent: Tuesday, May 27, 2003 11:45 AM > To: Multiple recipients of list ORACLE-L > > > I heard/read they give 20% discount on ocp exam fee if u are registered with > technet . > Can any body confirm that . How do I get that discount ? >  > -ak >  > > > The information contained in t!
his 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. > > 



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.
Shamita
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.

Re: RE: ocp discount

[AK]

Title: RE: RE: ocp discount



is it OTN20 ?
 
-ak

  - Original Message - 
  From: 
  April Wells 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, May 27, 2003 11:01 
AM
  Subject: RE: RE: ocp discount
  
  when you signed up with technet there should have been an 
  announcement or a splash screen that gave you a discount code... you have to 
  type that in when you register for the tests.  Don't remember what the 
  code was, off hand, but I remember it was delivered in one of those two 
  manners. 
  April Wells Oracle DBA/Oracle Apps 
  DBA Corporate Systems Amarillo 
  Texas 
  You will recognize your own path when you come upon it, 
  because you will suddenly have all the energy and imagination you will ever 
  need.
  ~ Jerry Gillies ~ 
  -Original Message- From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 27, 2003 12:35 PM To: 
  Multiple recipients of list ORACLE-L Subject: Re: RE: 
  ocp discount 
  im registered with technet and when i signed up to take my 
  tests with prometric? I was charged the same $125/test? > > From: April Wells 
  <[EMAIL PROTECTED]> > Date: 2003/05/27 Tue PM 
  01:04:44 EDT > To: Multiple recipients of list 
  ORACLE-L <[EMAIL PROTECTED]> > Subject: 
  RE: ocp discount > > 
  > yes they do. >  
  > to get it, you register with technet. 
  > otn.oracle.com >  
  > > April Wells 
  > Oracle DBA/Oracle Apps DBA > Corporate Systems > Amarillo Texas 
  > > You will recognize 
  your own path when you come upon it, because you will > suddenly have all the energy and imagination you will ever 
  need. > > ~ Jerry 
  Gillies ~ > > 
  -Original Message- > Sent: Tuesday, May 27, 
  2003 11:45 AM > To: Multiple recipients of list 
  ORACLE-L > > 
  > I heard/read they give 20% discount on ocp exam 
  fee if u are registered with > technet . 
  > Can any body confirm that . How do I get that discount 
  ? >  > -ak 
  >  > > > 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. > 
  > 
  


  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: RE: ocp discount

[DENNIS WILLIAMS]

When you signed up for the exam, there was a question as to whether you had
any discount codes. It is the same screen that asks if you are an Oracle
employee. If you enter the code on that screen, then you receive the
discount. 
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, May 27, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L


im registered with technet and when i signed up to take my tests with
prometric? I was charged the same $125/test? 
> 
> From: April Wells <[EMAIL PROTECTED]>
> Date: 2003/05/27 Tue PM 01:04:44 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: ocp discount
> 
> 
> yes they do.
>  
> to get it, you register with technet.
> otn.oracle.com
>  
> 
> April Wells 
> Oracle DBA/Oracle Apps DBA 
> Corporate Systems 
> Amarillo Texas 
> 
> You will recognize your own path when you come upon it, because you will
> suddenly have all the energy and imagination you will ever need.
> 
> ~ Jerry Gillies ~ 
> 
> -Original Message-
> Sent: Tuesday, May 27, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I heard/read they give 20% discount on ocp exam fee if u are registered
with
> technet .
> Can any body confirm that . How do I get that discount ?
>  
> -ak
>  
> 
> 
> 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.
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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: ocp discount

[M Rafiq]

OTN20

Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Tue, 27 May 2003 10:01:44 -0800
when you signed up with technet there should have been an announcement or a
splash screen that gave you a discount code... you have to type that in when
you register for the tests.  Don't remember what the code was, off hand, but
I remember it was delivered in one of those two manners.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will
suddenly have all the energy and imagination you will ever need.
~ Jerry Gillies ~


-Original Message-
Sent: Tuesday, May 27, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L
im registered with technet and when i signed up to take my tests with
prometric? I was charged the same $125/test?
>
> From: April Wells <[EMAIL PROTECTED]>
> Date: 2003/05/27 Tue PM 01:04:44 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: ocp discount
>
>
> yes they do.
>
> to get it, you register with technet.
> otn.oracle.com
>
>
> April Wells
> Oracle DBA/Oracle Apps DBA
> Corporate Systems
> Amarillo Texas
>
> You will recognize your own path when you come upon it, because you will
> suddenly have all the energy and imagination you will ever need.
>
> ~ Jerry Gillies ~
>
> -Original Message-
> Sent: Tuesday, May 27, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I heard/read they give 20% discount on ocp exam fee if u are registered
with
> technet .
> Can any body confirm that . How do I get that discount ?
>
> -ak
>
>
>
> 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.
>
>

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.

_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
 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: ocp discount

[April Wells]

Title: RE: RE: ocp discount





when you signed up with technet there should have been an announcement or a splash screen that gave you a discount code... you have to type that in when you register for the tests.  Don't remember what the code was, off hand, but I remember it was delivered in one of those two manners. 

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


You will recognize your own path when you come upon it, because you will suddenly have all the energy and imagination you will ever need.

~ Jerry Gillies ~




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 27, 2003 12:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: ocp discount



im registered with technet and when i signed up to take my tests with prometric? I was charged the same $125/test? 
> 
> From: April Wells <[EMAIL PROTECTED]>
> Date: 2003/05/27 Tue PM 01:04:44 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: ocp discount
> 
> 
> yes they do.
>  
> to get it, you register with technet.
> otn.oracle.com
>  
> 
> April Wells 
> Oracle DBA/Oracle Apps DBA 
> Corporate Systems 
> Amarillo Texas 
> 
> You will recognize your own path when you come upon it, because you will
> suddenly have all the energy and imagination you will ever need.
> 
> ~ Jerry Gillies ~ 
> 
> -Original Message-
> Sent: Tuesday, May 27, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I heard/read they give 20% discount on ocp exam fee if u are registered with
> technet .
> Can any body confirm that . How do I get that discount ?
>  
> -ak
>  
> 
> 
> 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.
> 
> 



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: RE: ocp discount

[rgaffuri]

im registered with technet and when i signed up to take my tests with prometric? I was 
charged the same $125/test? 
> 
> From: April Wells <[EMAIL PROTECTED]>
> Date: 2003/05/27 Tue PM 01:04:44 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: ocp discount
> 
> 
> yes they do.
>  
> to get it, you register with technet.
> otn.oracle.com
>  
> 
> April Wells 
> Oracle DBA/Oracle Apps DBA 
> Corporate Systems 
> Amarillo Texas 
> 
> You will recognize your own path when you come upon it, because you will
> suddenly have all the energy and imagination you will ever need.
> 
> ~ Jerry Gillies ~ 
> 
> -Original Message-
> Sent: Tuesday, May 27, 2003 11:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I heard/read they give 20% discount on ocp exam fee if u are registered with
> technet .
> Can any body confirm that . How do I get that discount ?
>  
> -ak
>  
> 
> 
> 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.
> 
> 



yes they do.
 
to get it, you register with technet.
otn.oracle.com
 
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
You will recognize your own path when you 
come upon it, because you will suddenly have all the energy and imagination you 
will ever need.
~ Jerry Gillies ~ 

  -Original Message-From: AK 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, May 27, 2003 11:45 
  AMTo: Multiple recipients of list ORACLE-LSubject: ocp 
  discount
  I heard/read they give 20% discount on ocp exam 
  fee if u are registered with technet .
  Can any body confirm that . How do I get that 
  discount ?
   
  -ak
   
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: ocp discount

[April Wells]

yes they do.
 
to get it, you register with technet.
otn.oracle.com
 
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas 
You will recognize your own path when you 
come upon it, because you will suddenly have all the energy and imagination you 
will ever need.
~ Jerry Gillies ~ 

  -Original Message-From: AK 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, May 27, 2003 11:45 
  AMTo: Multiple recipients of list ORACLE-LSubject: ocp 
  discount
  I heard/read they give 20% discount on ocp exam 
  fee if u are registered with technet .
  Can any body confirm that . How do I get that 
  discount ?
   
  -ak
   
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: Re: OCP

[Darrell Landrum]

John,

Just to clarify, that wasn't me that said you only need to get 50 % correct on the 9i 
upgrade exam.  This thread looks like it, but my message follows:
> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]>

Thanks,
Darrell

>>> [EMAIL PROTECTED] 03/13/03 03:23AM >>>
Well said Kirti - 
Darell, you wil fail every OCP exam  you take with 50%. You need a minimum of about 
65% and up to 75% on others (don't know why they vary so much)

John

-Original Message-
Sent: 12 March 2003 13:59
To: Multiple recipients of list ORACLE-L


>>> You only need to get 50% of the questions right on the upgrade tests.

Why not set the goal to it get 100% right?  ;) 

- Kirti 



-Original Message-
Sent: Wednesday, March 12, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L


I didnt realize that you might be able to do the 8i one without handing $2k to oracle 
for their class and taking the upgrade exams is a better path.

anyone know if this is possible? You only need to get 50% of the questions right on 
the upgrade tests. 

> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]>
> Date: 2003/03/12 Wed AM 07:48:43 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: OCP
> 
> Jay,
> 
> One thing to consider is that just starting the 9i track and if you've not taken any 
> OCP exams prior to September of 2002, there is a requirement to attend one 9i 
> training class in addition to the exams.  However (you'll probably need to call 
> Oracle to get a solid answer to this), if you can still take the 8i track with no 
> classroom training and then take the 9i upgrade exam (if they allow this with no 
> classroom training), this would be your least expensive route since the classes are 
> quite expensive.  The down side is a total of six exams instead of just four.
> If your company is willing to send you to one of the 9i classes, I would take 
> advantage of that and just go for the 9i track.
> 
> Good luck!
> Darrell
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Deshpande, Kirti
  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: Hallas, John, Tech Dev
  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: Darrell Landrum
  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: OCP

[Hallas, John, Tech Dev]

Well said Kirti - 
Darell, you wil fail every OCP exam  you take with 50%. You need a minimum of about 
65% and up to 75% on others (don't know why they vary so much)

John

-Original Message-
Sent: 12 March 2003 13:59
To: Multiple recipients of list ORACLE-L


>>> You only need to get 50% of the questions right on the upgrade tests.

Why not set the goal to it get 100% right?  ;) 

- Kirti 



-Original Message-
Sent: Wednesday, March 12, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L


I didnt realize that you might be able to do the 8i one without handing $2k to oracle 
for their class and taking the upgrade exams is a better path.

anyone know if this is possible? You only need to get 50% of the questions right on 
the upgrade tests. 

> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]>
> Date: 2003/03/12 Wed AM 07:48:43 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: OCP
> 
> Jay,
> 
> One thing to consider is that just starting the 9i track and if you've not taken any 
> OCP exams prior to September of 2002, there is a requirement to attend one 9i 
> training class in addition to the exams.  However (you'll probably need to call 
> Oracle to get a solid answer to this), if you can still take the 8i track with no 
> classroom training and then take the 9i upgrade exam (if they allow this with no 
> classroom training), this would be your least expensive route since the classes are 
> quite expensive.  The down side is a total of six exams instead of just four.
> If your company is willing to send you to one of the 9i classes, I would take 
> advantage of that and just go for the 9i track.
> 
> Good luck!
> Darrell
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: Hallas, John, Tech Dev
  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: OCP

[kirti . deshpande]

>>> You only need to get 50% of the questions right on the upgrade tests.

Why not set the goal to it get 100% right?  ;) 

- Kirti 



-Original Message-
Sent: Wednesday, March 12, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L


I didnt realize that you might be able to do the 8i one without handing $2k
to oracle for their class and taking the upgrade exams is a better path.

anyone know if this is possible? You only need to get 50% of the questions
right on the upgrade tests. 

> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]>
> Date: 2003/03/12 Wed AM 07:48:43 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: OCP
> 
> Jay,
> 
> One thing to consider is that just starting the 9i track and if you've not
taken any OCP exams prior to September of 2002, there is a requirement to
attend one 9i training class in addition to the exams.  However (you'll
probably need to call Oracle to get a solid answer to this), if you can
still take the 8i track with no classroom training and then take the 9i
upgrade exam (if they allow this with no classroom training), this would be
your least expensive route since the classes are quite expensive.  The down
side is a total of six exams instead of just four.
> If your company is willing to send you to one of the 9i classes, I would
take advantage of that and just go for the 9i track.
> 
> Good luck!
> Darrell
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: 
  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: OCP

[peter . sharman]

I think there are a couple of ways you can do this.  Firstly, if you ring
Prometric and try to register for the 9i Upgrade exam.  IIRC, they'll ask
you for your SSN and their system should reject you if you don't have the
necessary pre-req certification.  Secondly, you can send an email to
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> .  From what it says on
http://www.oracle.com/education/certification/faq/index.html?faq8.html
<http://www.oracle.com/education/certification/faq/index.html?faq8html> ,
we're attempting to build an automated way of doing this.  Problem is of
course that all the records are actually held by Prometric as an independent
body, so there may be legal issues with Oracle having a way to access that.
 
As for the 50% passing score, sorry that's just wrong.  As you can see here
(http://www.oracle.com/education/certification/index.html?dba9i_exam.html
<http://www.oracle.com/education/certification/index.html?dba9i_exam.html>
), the passing score for that exam is 70%.
 

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

 

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 6:39 AM
To: Multiple recipients of list ORACLE-L



So how can you check the status of your 8i OCP so you can sign up for the 9i
OCP upgrade exam?  

-Original Message- 
<mailto:[EMAIL PROTECTED]> ] 
Sent: Wednesday, March 12, 2003 8:59 AM 
To: Multiple recipients of list ORACLE-L 


>>> You only need to get 50% of the questions right on the upgrade tests. 

Why not set the goal to it get 100% right?  ;) 

- Kirti 



-Original Message- 
Sent: Wednesday, March 12, 2003 7:29 AM 
To: Multiple recipients of list ORACLE-L 


I didnt realize that you might be able to do the 8i one without handing $2k
to oracle for their class and taking the upgrade exams is a better path.

anyone know if this is possible? You only need to get 50% of the questions
right on the upgrade tests. 

> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]> 
> Date: 2003/03/12 Wed AM 07:48:43 EST 
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
> Subject: Re: OCP 
> 
> Jay, 
> 
> One thing to consider is that just starting the 9i track and if you've not
taken any OCP exams prior to September of 2002, there is a requirement to
attend one 9i training class in addition to the exams.  However (you'll
probably need to call Oracle to get a solid answer to this), if you can
still take the 8i track with no classroom training and then take the 9i
upgrade exam (if they allow this with no classroom training), this would be
your least expensive route since the classes are quite expensive.  The down
side is a total of six exams instead of just four.

> If your company is willing to send you to one of the 9i classes, I would
take advantage of that and just go for the 9i track.

> 
> Good luck! 
> Darrell 
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>  
-- 
Author: Deshpande, Kirti 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
<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: 
  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: OCP

[DENNIS WILLIAMS]

Pete - You've made my day. We had some education money to use or lose last
fall, and the 9i New Features class was offered locally. I thought I might
be able to take the upgrade class even though I  hadn't completed the 8i
route. December is not a good month for finding study time, so I shelved
that idea. I'm glad I didn't waste time cramming for a test I might not have
been qualified for. The 50% comment jolted me because I could probably have
made that without cramming.



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, March 12, 2003 10:40 AM
To: Multiple recipients of list ORACLE-L


I think there are a couple of ways you can do this.  Firstly, if you ring
Prometric and try to register for the 9i Upgrade exam.  IIRC, they'll ask
you for your SSN and their system should reject you if you don't have the
necessary pre-req certification.  Secondly, you can send an email to
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> .  From what it says on
http://www.oracle.com/education/certification/faq/index.html?faq8.html
<http://www.oracle.com/education/certification/faq/index.html?faq8.html> ,
we're attempting to build an automated way of doing this.  Problem is of
course that all the records are actually held by Prometric as an independent
body, so there may be legal issues with Oracle having a way to access that.
 
As for the 50% passing score, sorry that's just wrong.  As you can see here
( http://www.oracle.com/education/certification/index.html?dba9i_exam.html
<http://www.oracle.com/education/certification/index.html?dba9i_exam.html>
), the passing score for that exam is 70%.
 

Pete



"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

 

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 6:39 AM
To: Multiple recipients of list ORACLE-L



So how can you check the status of your 8i OCP so you can sign up for the 9i
OCP upgrade exam?  

-Original Message- 
<mailto:[EMAIL PROTECTED]> ] 
Sent: Wednesday, March 12, 2003 8:59 AM 
To: Multiple recipients of list ORACLE-L 


>>> You only need to get 50% of the questions right on the upgrade tests. 

Why not set the goal to it get 100% right?  ;) 

- Kirti 



-Original Message- 
Sent: Wednesday, March 12, 2003 7:29 AM 
To: Multiple recipients of list ORACLE-L 


I didnt realize that you might be able to do the 8i one without handing $2k
to oracle for their class and taking the upgrade exams is a better path.

anyone know if this is possible? You only need to get 50% of the questions
right on the upgrade tests. 

> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]> 
> Date: 2003/03/12 Wed AM 07:48:43 EST 
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 
> Subject: Re: OCP 
> 
> Jay, 
> 
> One thing to consider is that just starting the 9i track and if you've not
taken any OCP exams prior to September of 2002, there is a requirement to
attend one 9i training class in addition to the exams.  However (you'll
probably need to call Oracle to get a solid answer to this), if you can
still take the 8i track with no classroom training and then take the 9i
upgrade exam (if they allow this with no classroom training), this would be
your least expensive route since the classes are quite expensive.  The down
side is a total of six exams instead of just four.

> If your company is willing to send you to one of the 9i classes, I would
take advantage of that and just go for the 9i track.

> 
> Good luck! 
> Darrell 
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>  
-- 
Author: Deshpande, Kirti 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
<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: DENNIS WILLIAMS
  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

RE: Re: OCP

[Pete Sharman]

Title: Message



I think there are a couple of ways you can do this.  Firstly, if you 
ring Prometric and try to register for the 9i Upgrade exam.  IIRC, 
they'll ask you for your SSN and their system should reject you if you don't 
have the necessary pre-req certification.  Secondly, you can send an email 
to [EMAIL PROTECTED].  From 
what it says on http://www.oracle.com/education/certification/faq/index.html?faq8.html, 
we're attempting to build an automated way of doing this.  Problem is of 
course that all the records are actually held by Prometric as an independent 
body, so there may be legal issues with Oracle having a way to access 
that.
 
As for the 50% passing score, sorry that's just wrong.  As you can 
see here (http://www.oracle.com/education/certification/index.html?dba9i_exam.html), 
the passing score for that exam is 70%.
 

Pete

"Controlling 
developers is like herding cats."
Kevin 
Loney, Oracle DBA Handbook
"Oh 
no, it's not.  It's much harder than 
that!"
Bruce 
Pihlamae, long-term Oracle DBA
 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED] On Behalf Of 
  [EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 
  6:39 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Re: OCP
  So how can you check the status of your 8i OCP so you can sign 
  up for the 9i OCP upgrade exam?  
  -Original Message- From: 
  Deshpande, Kirti [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, March 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: OCP 
  >>> You only need to get 50% of the questions right 
  on the upgrade tests. 
  Why not set the goal to it get 100% right?  ;) 

  - Kirti 
  -Original Message- Sent: 
  Wednesday, March 12, 2003 7:29 AM To: Multiple 
  recipients of list ORACLE-L 
  I didnt realize that you might be able to do the 8i one 
  without handing $2k to oracle for their class and taking the upgrade exams is 
  a better path.
  anyone know if this is possible? You only need to get 50% of 
  the questions right on the upgrade tests. 
  > > From: "Darrell Landrum" 
  <[EMAIL PROTECTED]> > Date: 2003/03/12 
  Wed AM 07:48:43 EST > To: Multiple recipients of 
  list ORACLE-L <[EMAIL PROTECTED]> > 
  Subject: Re: OCP > > 
  Jay, > > One thing to 
  consider is that just starting the 9i track and if you've not taken any OCP 
  exams prior to September of 2002, there is a requirement to attend one 9i 
  training class in addition to the exams.  However (you'll probably need 
  to call Oracle to get a solid answer to this), if you can still take the 8i 
  track with no classroom training and then take the 9i upgrade exam (if they 
  allow this with no classroom training), this would be your least expensive 
  route since the classes are quite expensive.  The down side is a total of 
  six exams instead of just four.
  > If your company is willing to send you to one of the 9i 
  classes, I would take advantage of that and just go for the 9i 
  track.
  > > Good luck! > Darrell > > 
  
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: Deshpande, Kirti   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: OCP

[Paula_Stankus]

Title: RE: OCP





I thought it was better on principal of not wanting to spend the $2K for a class.


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 12, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OCP



Jai
    An important part of the OCP is what it means to others, that is people
you work for, people that will read your resume. Do you see a possibility
that having both 8i and 9i on your resume would be a benefit. For example if
a hiring manager specifies "Oracle8i OCP", and company policy dictates that
job requirements be passed to the HR department for screening, there is a
possibility that your Oracle9i OCP would not be considered. Frustrating,
irritating, I know, but our ancestors got kicked out of Eden and it's been
downhill ever since.




Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, March 12, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L




Dear All, 


I plan to take up Oracle Certification (DBA) very soon. Iam quite confused
about the 
tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i or
go 
straight for the 9i OCP DBA title, with regard to the complexities of the
exam. 


Thanks in advance for all your help and guidance which would be really
helpful. 


Best Regards
Jai


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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: OCP

[DENNIS WILLIAMS]

50% ?? You're joshing me!

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 



-Original Message-
Sent: Wednesday, March 12, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L


I didnt realize that you might be able to do the 8i one without handing $2k
to oracle for their class and taking the upgrade exams is a better path.

anyone know if this is possible? You only need to get 50% of the questions
right on the upgrade tests. 

> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]>
> Date: 2003/03/12 Wed AM 07:48:43 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: OCP
> 
> Jay,
> 
> One thing to consider is that just starting the 9i track and if you've not
taken any OCP exams prior to September of 2002, there is a requirement to
attend one 9i training class in addition to the exams.  However (you'll
probably need to call Oracle to get a solid answer to this), if you can
still take the 8i track with no classroom training and then take the 9i
upgrade exam (if they allow this with no classroom training), this would be
your least expensive route since the classes are quite expensive.  The down
side is a total of six exams instead of just four.
> If your company is willing to send you to one of the 9i classes, I would
take advantage of that and just go for the 9i track.
> 
> Good luck!
> Darrell
> 
> >>> [EMAIL PROTECTED] 03/12/03 04:09AM >>>
> Dear All,
> 
> I plan to take up Oracle Certification (DBA) very soon. Iam quite confused

> about the
> tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i 
> or go
> straight for the 9i OCP DBA title, with regard to the complexities of the 
> exam.
> 
> Thanks in advance for all your help and guidance which would be really 
> helpful.
> 
> Best Regards
> Jai
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Darrell Landrum
>   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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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: OCP

[DENNIS WILLIAMS]

Jai
An important part of the OCP is what it means to others, that is people
you work for, people that will read your resume. Do you see a possibility
that having both 8i and 9i on your resume would be a benefit. For example if
a hiring manager specifies "Oracle8i OCP", and company policy dictates that
job requirements be passed to the HR department for screening, there is a
possibility that your Oracle9i OCP would not be considered. Frustrating,
irritating, I know, but our ancestors got kicked out of Eden and it's been
downhill ever since.



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, March 12, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L



Dear All, 

I plan to take up Oracle Certification (DBA) very soon. Iam quite confused
about the 
tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i or
go 
straight for the 9i OCP DBA title, with regard to the complexities of the
exam. 

Thanks in advance for all your help and guidance which would be really
helpful. 

Best Regards
Jai

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  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: OCP

[Ron Rogers]

Paula,
 When you completed the OCP exams, you were given a "report card" that
was stamped and sealed by the test provider with a passed notation.
After you have completed all of the requirements for the particular
track you were taking you should receive a certificate and card from the
Oracle Corp.
 The report from the testing orginization had a disclamer that you
should safe guard the report a proof of completing a track.
Ron

>>> [EMAIL PROTECTED] 03/12/03 09:39AM >>>
So how can you check the status of your 8i OCP so you can sign up for
the 9i
OCP upgrade exam?  

-Original Message-
Sent: Wednesday, March 12, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L


>>> You only need to get 50% of the questions right on the upgrade
tests.

Why not set the goal to it get 100% right?  ;) 

- Kirti 



-Original Message-
Sent: Wednesday, March 12, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L


I didnt realize that you might be able to do the 8i one without handing
$2k
to oracle for their class and taking the upgrade exams is a better
path.

anyone know if this is possible? You only need to get 50% of the
questions
right on the upgrade tests. 

> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]>
> Date: 2003/03/12 Wed AM 07:48:43 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: OCP
> 
> Jay,
> 
> One thing to consider is that just starting the 9i track and if
you've not
taken any OCP exams prior to September of 2002, there is a requirement
to
attend one 9i training class in addition to the exams.  However
(you'll
probably need to call Oracle to get a solid answer to this), if you
can
still take the 8i track with no classroom training and then take the
9i
upgrade exam (if they allow this with no classroom training), this
would be
your least expensive route since the classes are quite expensive.  The
down
side is a total of six exams instead of just four.
> If your company is willing to send you to one of the 9i classes, I
would
take advantage of that and just go for the 9i track.
> 
> Good luck!
> Darrell
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Deshpande, Kirti
  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 Rogers
  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: OCP

[Paula_Stankus]

Title: RE: Re: OCP





So how can you check the status of your 8i OCP so you can sign up for the 9i OCP upgrade exam?  


-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 12, 2003 8:59 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: OCP



>>> You only need to get 50% of the questions right on the upgrade tests.


Why not set the goal to it get 100% right?  ;) 


- Kirti 




-Original Message-
Sent: Wednesday, March 12, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L



I didnt realize that you might be able to do the 8i one without handing $2k to oracle for their class and taking the upgrade exams is a better path.

anyone know if this is possible? You only need to get 50% of the questions right on the upgrade tests. 


> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]>
> Date: 2003/03/12 Wed AM 07:48:43 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: OCP
> 
> Jay,
> 
> One thing to consider is that just starting the 9i track and if you've not taken any OCP exams prior to September of 2002, there is a requirement to attend one 9i training class in addition to the exams.  However (you'll probably need to call Oracle to get a solid answer to this), if you can still take the 8i track with no classroom training and then take the 9i upgrade exam (if they allow this with no classroom training), this would be your least expensive route since the classes are quite expensive.  The down side is a total of six exams instead of just four.

> If your company is willing to send you to one of the 9i classes, I would take advantage of that and just go for the 9i track.

> 
> Good luck!
> Darrell
> 
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: OCP

[Deshpande, Kirti]

>>> You only need to get 50% of the questions right on the upgrade tests.

Why not set the goal to it get 100% right?  ;) 

- Kirti 



-Original Message-
Sent: Wednesday, March 12, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L


I didnt realize that you might be able to do the 8i one without handing $2k to oracle 
for their class and taking the upgrade exams is a better path.

anyone know if this is possible? You only need to get 50% of the questions right on 
the upgrade tests. 

> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]>
> Date: 2003/03/12 Wed AM 07:48:43 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: OCP
> 
> Jay,
> 
> One thing to consider is that just starting the 9i track and if you've not taken any 
> OCP exams prior to September of 2002, there is a requirement to attend one 9i 
> training class in addition to the exams.  However (you'll probably need to call 
> Oracle to get a solid answer to this), if you can still take the 8i track with no 
> classroom training and then take the 9i upgrade exam (if they allow this with no 
> classroom training), this would be your least expensive route since the classes are 
> quite expensive.  The down side is a total of six exams instead of just four.
> If your company is willing to send you to one of the 9i classes, I would take 
> advantage of that and just go for the 9i track.
> 
> Good luck!
> Darrell
> 
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  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: OCP

[rgaffuri]

I didnt realize that you might be able to do the 8i one without handing $2k to oracle 
for their class and taking the upgrade exams is a better path.

anyone know if this is possible? You only need to get 50% of the questions right on 
the upgrade tests. 

> 
> From: "Darrell Landrum" <[EMAIL PROTECTED]>
> Date: 2003/03/12 Wed AM 07:48:43 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: OCP
> 
> Jay,
> 
> One thing to consider is that just starting the 9i track and if you've not taken any 
> OCP exams prior to September of 2002, there is a requirement to attend one 9i 
> training class in addition to the exams.  However (you'll probably need to call 
> Oracle to get a solid answer to this), if you can still take the 8i track with no 
> classroom training and then take the 9i upgrade exam (if they allow this with no 
> classroom training), this would be your least expensive route since the classes are 
> quite expensive.  The down side is a total of six exams instead of just four.
> If your company is willing to send you to one of the 9i classes, I would take 
> advantage of that and just go for the 9i track.
> 
> Good luck!
> Darrell
> 
> >>> [EMAIL PROTECTED] 03/12/03 04:09AM >>>
> Dear All,
> 
> I plan to take up Oracle Certification (DBA) very soon. Iam quite confused 
> about the
> tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i 
> or go
> straight for the 9i OCP DBA title, with regard to the complexities of the 
> exam.
> 
> Thanks in advance for all your help and guidance which would be really 
> helpful.
> 
> Best Regards
> Jai
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Darrell Landrum
>   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: OCP

[Darrell Landrum]

Jay,

One thing to consider is that just starting the 9i track and if you've not taken any 
OCP exams prior to September of 2002, there is a requirement to attend one 9i training 
class in addition to the exams.  However (you'll probably need to call Oracle to get a 
solid answer to this), if you can still take the 8i track with no classroom training 
and then take the 9i upgrade exam (if they allow this with no classroom training), 
this would be your least expensive route since the classes are quite expensive.  The 
down side is a total of six exams instead of just four.
If your company is willing to send you to one of the 9i classes, I would take 
advantage of that and just go for the 9i track.

Good luck!
Darrell

>>> [EMAIL PROTECTED] 03/12/03 04:09AM >>>
Dear All,

I plan to take up Oracle Certification (DBA) very soon. Iam quite confused 
about the
tracks and the exams. Is it better to pass OCP 8i and then upgrade to 9i 
or go
straight for the 9i OCP DBA title, with regard to the complexities of the 
exam.

Thanks in advance for all your help and guidance which would be really 
helpful.

Best Regards
Jai

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Darrell Landrum
  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: OCP Hands-On Course Requirement

[KENNETH JANUSZ]

Title: OCP Hands-On Course Requirement



I would recommend Oracle University.
 
http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?redir_type=3&p_org_id=&lang=&source_call=global
 
Ken Janusz, CPIM

  - Original Message - 
  From: 
  Wiegand, 
  Kurt 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, February 27, 2003 7:59 
  AM
  Subject: OCP Hands-On Course 
  Requirement
  
  Can anyone direct me towards an "Oracle Authorized 
  Education Center or Partner" in the 
  Washington D.C. area?  I'm planning on getting certified but only see 
  Oracle University offering 9-5 
  Monday-Friday courses.  Thanks. 
  Kurt 

RE: OCP Exams - What to study out of?

[DENNIS WILLIAMS]

No (sigh), I just took the class, so now I've got to get the energy to take
the test.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, November 06, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


So you took and passed the upgrade exam already?

Brian

-Original Message-
Sent: Wednesday, November 06, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L


And I hope it is okay to take 9i New Features before you've finished all
your 8i modules, because I wound up taking a new features class to use up
some education money that was expiring. The Oracle instructor, John Hibbard,
is superb. He makes the class very entertaining and he has done a lot of
research outside the class manual and he throws that in as well. 
   I wanted a short "cram sheet" with a fast overview of topics likely to be
on the 9i New Features exam and ended up writing my own 5-page document, so
if anyone wants a copy, send me a private note and I'll send you a copy. No
guarantees, and if you find any errors, let me know.


Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richards, Brian
  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.com
-- 
Author: DENNIS WILLIAMS
  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: OCP Exams - What to study out of?

[Richards, Brian]

So you took and passed the upgrade exam already?

Brian

-Original Message-
Sent: Wednesday, November 06, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L


And I hope it is okay to take 9i New Features before you've finished all
your 8i modules, because I wound up taking a new features class to use up
some education money that was expiring. The Oracle instructor, John Hibbard,
is superb. He makes the class very entertaining and he has done a lot of
research outside the class manual and he throws that in as well. 
   I wanted a short "cram sheet" with a fast overview of topics likely to be
on the 9i New Features exam and ended up writing my own 5-page document, so
if anyone wants a copy, send me a private note and I'll send you a copy. No
guarantees, and if you find any errors, let me know.


Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richards, Brian
  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: OCP Exams - What to study out of?

[DENNIS WILLIAMS]

And I hope it is okay to take 9i New Features before you've finished all
your 8i modules, because I wound up taking a new features class to use up
some education money that was expiring. The Oracle instructor, John Hibbard,
is superb. He makes the class very entertaining and he has done a lot of
research outside the class manual and he throws that in as well. 
   I wanted a short "cram sheet" with a fast overview of topics likely to be
on the 9i New Features exam and ended up writing my own 5-page document, so
if anyone wants a copy, send me a private note and I'll send you a copy. No
guarantees, and if you find any errors, let me know.


Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, November 06, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L


You are not wrong! And I, too, am doing OCP 8i, then the upgrade. Using the
Couchman study guide and sample tests books, Self Test Software sample
tests, and (don't laugh) the CBTs by SmartForce (since our company paid for
them, might as well use them).
 
Brian
60% 8i OCP (SQL, B&R, A & A)
 
-Original Message-
Sent: Wednesday, November 06, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L


I took 8i - am taking 8i because I am hoping that then I can just take an
upgrade exam for 9i without the $1,000+ course requirement.  I believe that
is still the case.  Please tell me if I am wrong. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: OCP Exams - What to study out of?

[Richards, Brian]

Title: RE: OCP Exams - What to study out of?



You 
are not wrong! And I, too, am doing OCP 8i, then the upgrade. Using the Couchman 
study guide and sample tests books, Self Test Software sample tests, and (don't 
laugh) the CBTs by SmartForce (since our company paid for them, might as well 
use them).
 
Brian
60% 8i 
OCP (SQL, B&R, A & A)
 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 
2002 12:04 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: OCP Exams - What to study out 
of?
I took 
8i - am taking 8i because I am hoping that then I can just take an upgrade exam 
for 9i without the $1,000+ course requirement.  I believe that is still the 
case.  Please tell me if I am 
wrong. 

RE: OCP Exams - What to study out of?

[Paula_Stankus]

Title: RE: OCP Exams - What to study out of?



I took 
8i - am taking 8i because I am hoping that then I can just take an upgrade exam 
for 9i without the $1,000+ course requirement.  I believe that is still the 
case.  Please tell me if I am wrong.  

  -Original Message-From: KENNETH JANUSZ 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 9:34 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  OCP Exams - What to study out of?
  Unfortunately there are no Corioulus books for 
  9i.
   
  Ken
  
- Original Message - 
From: 
[EMAIL PROTECTED] 

To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, November 06, 2002 8:08 
AM
Subject: RE: OCP Exams - What to study 
out of?

But I did.  All I did was study the Corioulus book - 
and took the exams. 
-Original Message- From: 
DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 05, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: OCP Exams - What to study out of? 
Ken - Wow, I'm impressed. I took and passed one APICS module 
years and years ago and I can testify that they 
aren't easy. And I took the module related to my 
daily job.    Can you share any tips on 
how to study for the SQL exam? I find I learn MUCH 
more from someone that was forced to reassess their strategy than 
from people that say "oh, I took the manual home two 
nights and breezed through it". 
Dennis Williams DBA, 40%OCP 
Lifetouch, Inc. [EMAIL PROTECTED] 
-Original Message- Sent: 
Tuesday, November 05, 2002 2:04 PM To: Multiple 
recipients of list ORACLE-L 
I agree that the SQL exam is very difficult.  I've 
taken it twice and missed passing by just a couple 
of points.  But I will persist. 
Interestingly enough when I got my APICS CPIM certification 
I took six exams and passed them all on the first 
try.  The passing grade is 90%. 
Ken Janusz, CPIM 
- Original Message - To: 
"Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 
Sent: Tuesday, November 05, 2002 11:03 AM 
> Eva - Everything I've heard says that all the exam 
questions come out of the > Oracle University class Student Guides. To put it bluntly, your 
goal is to > pass the exam. You could study the 
Oracle manuals, but there is a lot of > material 
to cover and what strikes you as important might not be covered 
on > the exam, and vice-versa. 
Essentially you are getting two levels of > 
filtering. Somebody read the manuals and used that to prepare student 
> guides, then a group of Oracle instructors read the 
student guide and > prepared questions. I think 
that most of the exam guides were prepared from > the Oracle Student Guides and the 
author has at least taken the exam, so > they 
have a general idea of how the test is approached. Everyone has their 
> favorite exam preparation book and I consider this a 
worthwhile investment, > 
I bought Couchman - > http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 
> H > <http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 
> 0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007 
> 2133414> > 
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721 
> 33414 >    
Two issues: Which exam track are you planning to take? 9i? 8i? 
>    The advice I received is "don't take 
the SQL exam as your first exam". > Take the DBA 
exam first. The SQL exam is reported to be quite hard because 
> it covers all the odd SQL functions and can really 
catch you unawares. As a > practicing DBA you should find the DBA exam pretty easy. I 
didn't personally > take 
that path for my own reasons, but I still consider it good advice. 
> > > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. 
> [EMAIL PROTECTED] > > -Original Message- 
> Sent: Tuesday, November 05, 2002 6:09 AM 
> To: Multiple recipients of list ORACLE-L 
> > > > Hello Everyone, > > 1. I have now made the humungous 
decision to start studying and to write the 
> OCP exams. > 2. Do I study 
out of the Oracle Manuals? > 3. I do have the 
Sybex Study Guides, would studying these be all that is > needed? > 4. Or do the questions come 
out of the Course material ( Which I have not > 
attended ). > 5. I do have some of the Oreilly 
"Insect" Books - would these be any help? > > Any views, opinions etc 
appreciated. > Regards > Denham Eva > Oracle DBA 

RE: OCP Exams - What to study out of?

[Peter Barnett]

In many cases the exams extract exact sentences from
the Oracle Uinversity manuals for their correct
answers.


--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Eva - Everything I've heard says that all the exam
> questions come out of the
> Oracle University class Student Guides. To put it
> bluntly, your goal is to
> pass the exam. You could study the Oracle manuals,
> but there is a lot of
> material to cover and what strikes you as important
> might not be covered on
> the exam, and vice-versa. Essentially you are
> getting two levels of
> filtering. Somebody read the manuals and used that
> to prepare student
> guides, then a group of Oracle instructors read the
> student guide and
> prepared questions. I think that most of the exam
> guides were prepared from
> the Oracle Student Guides and the author has at
> least taken the exam, so
> they have a general idea of how the test is
> approached. Everyone has their
> favorite exam preparation book and I consider this a
> worthwhile investment,
> I bought Couchman -
>
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
> H
>

0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007
> 2133414>
>
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721
> 33414
>Two issues: Which exam track are you planning to
> take? 9i? 8i? 
>The advice I received is "don't take the SQL exam
> as your first exam".
> Take the DBA exam first. The SQL exam is reported to
> be quite hard because
> it covers all the odd SQL functions and can really
> catch you unawares. As a
> practicing DBA you should find the DBA exam pretty
> easy. I didn't personally
> take that path for my own reasons, but I still
> consider it good advice.
> 
> 
> 
> Dennis Williams 
> DBA, 40%OCP 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Tuesday, November 05, 2002 6:09 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hello Everyone, 
> 
> 1. I have now made the humungous decision to start
> studying and to write the
> OCP exams. 
> 2. Do I study out of the Oracle Manuals? 
> 3. I do have the Sybex Study Guides, would studying
> these be all that is
> needed? 
> 4. Or do the questions come out of the Course
> material ( Which I have not
> attended ). 
> 5. I do have some of the Oreilly "Insect" Books -
> would these be any help? 
> 
> Any views, opinions etc appreciated. 
> Regards 
> Denham Eva 
> Oracle DBA 
> "UNIX is basically a simple operating system, but
> you have to be a genius to
> understand the simplicity." 
> Dennis Ritchie. 
> 
> 
> 
>   _  
> 
> DISCLAIMER 
> 
> 
> 
> This message is for the named person's use only. It
> may contain
> confidential, proprietary or legally privileged
> information. No
> confidentiality or privilege is waived or lost by
> any mistransmission. If
> you receive this message in error, please
> immediately delete it and all
> copies of it from your system, destroy any hard
> copies of it and notify the
> sender. You must not, directly or indirectly, use,
> disclose, distribute,
> print, or copy any part of this message if you are
> not the intended
> recipient. TFMC, its holding company, and any of its
> subsidiaries each
> reserve the right to monitor and manage all e-mail
> communications through
> its networks. 
> 
> Any views expressed in this message are those of the
> individual sender,
> except where the message states otherwise and the
> sender is authorized to
> state them to be views of any such entity. 
> 
>   _  
> 
> 
> 
> 
>   _  
> 
> This e-mail message has been scanned for Viruses and
> Content and cleared by
> MailMarshal - For more information please visit
> 
> www.marshalsoftware.com 
>   _  
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   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).


=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET: [EMAIL PROTECTED]

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

RE: OCP Exams - What to study out of?

[John . Hallas]

Just bought Oracle Press 9i New Features by the illustrious Robert Freeman.
Seems good and I have also seen another Oracle Press Book  9i New Features
Exam Guide by Daniel Benjamin. This follows the Corioulus format  of a
chapter and questions and a big test at the end.
 
The worrying thing about Robert's book is that in the introduction he states
that due to lack of space he has had to miss certain features out.
Unfortunately he does not even list the ones he has missed out. However
these books should be used in conjunction with the Oracle documentation so
should it should not be too much of an issue.
 
John

-Original Message-
Sent: 06 November 2002 14:34
To: Multiple recipients of list ORACLE-L


Unfortunately there are no Corioulus books for 9i.
 
Ken

- Original Message - 
To: Multiple   recipients of list ORACLE-L 
Sent: Wednesday, November 06, 2002 8:08 AM


But I did.  All I did was study the Corioulus book - and took the exams. 

-Original Message- 
 ] 
Sent: Tuesday, November 05, 2002 4:34 PM 
To: Multiple recipients of list ORACLE-L 


Ken - Wow, I'm impressed. I took and passed one APICS module years and years

ago and I can testify that they aren't easy. And I took the module related 
to my daily job. 
   Can you share any tips on how to study for the SQL exam? I find I learn 
MUCH more from someone that was forced to reassess their strategy than from 
people that say "oh, I took the manual home two nights and breezed through 
it". 

Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message- 
Sent: Tuesday, November 05, 2002 2:04 PM 
To: Multiple recipients of list ORACLE-L 


I agree that the SQL exam is very difficult.  I've taken it twice and missed

passing by just a couple of points.  But I will persist. 

Interestingly enough when I got my APICS CPIM certification I took six exams

and passed them all on the first try.  The passing grade is 90%. 

Ken Janusz, CPIM 

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 
Sent: Tuesday, November 05, 2002 11:03 AM 


> Eva - Everything I've heard says that all the exam questions come out of 
the 
> Oracle University class Student Guides. To put it bluntly, your goal is to

> pass the exam. You could study the Oracle manuals, but there is a lot of 
> material to cover and what strikes you as important might not be covered 
on 
> the exam, and vice-versa. Essentially you are getting two levels of 
> filtering. Somebody read the manuals and used that to prepare student 
> guides, then a group of Oracle instructors read the student guide and 
> prepared questions. I think that most of the exam guides were prepared 
from 
> the Oracle Student Guides and the author has at least taken the exam, so 
> they have a general idea of how the test is approached. Everyone has their

> favorite exam preparation book and I consider this a worthwhile 
investment, 
> I bought Couchman - 
> 
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
  
> H 
> 
<
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
  
> 
0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007

> 2133414> 
> 
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721

> 33414 
>Two issues: Which exam track are you planning to take? 9i? 8i? 
>The advice I received is "don't take the SQL exam as your first exam". 
> Take the DBA exam first. The SQL exam is reported to be quite hard because

> it covers all the odd SQL functions and can really catch you unawares. As 
a 
> practicing DBA you should find the DBA exam pretty easy. I didn't 
personally 
> take that path for my own reasons, but I still consider it good advice. 
> 
> 
> 
> Dennis Williams 
> DBA, 40%OCP 
> Lifetouch, Inc. 
> [EMAIL PROTECTED] 
> 
> -Original Message- 
> Sent: Tuesday, November 05, 2002 6:09 AM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> 
> Hello Everyone, 
> 
> 1. I have now made the humungous decision to start studying and to write 
the 
> OCP exams. 
> 2. Do I study out of the Oracle Manuals? 
> 3. I do have the Sybex Study Guides, would studying these be all that is 
> needed? 
> 4. Or do the questions come out of the Course material ( Which I have not 
> attended ). 
> 5. I do have some of the Oreilly "Insect" Books - would these be any help?

> 
> Any views, opinions etc appreciated. 
> Regards 
> Denham Eva 
> Oracle DBA 
> "UNIX is basically a simple operating system, but you have to be a genius 
to 
> understand the simplicity." 
> Dennis Ritchie. 
> 
> 
> 
>   _ 
> 
> DISCLAIMER 
> 
> 
> 
> This message is for the named person's use only. It may contain 
> confidential, propr

RE: OCP Exams - What to study out of?

[Hately, Mike (NESL-IT)]

Hi,
I remember that replication isn't really covered in Robert's book. 
The way I did this was to step through the candidate guide and compare it to
the index of the New Features book to see what was missing. 

Regards,
Mike Hately


-Original Message-
Sent: Wednesday, November 06, 2002 3:56 PM
To: Multiple recipients of list ORACLE-L


Just bought Oracle Press 9i New Features by the illustrious Robert Freeman.
Seems good and I have also seen another Oracle Press Book  9i New Features
Exam Guide by Daniel Benjamin. This follows the Corioulus format  of a
chapter and questions and a big test at the end.
 
The worrying thing about Robert's book is that in the introduction he states
that due to lack of space he has had to miss certain features out.
Unfortunately he does not even list the ones he has missed out. However
these books should be used in conjunction with the Oracle documentation so
should it should not be too much of an issue.
 
John
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately, Mike (NESL-IT)
  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: OCP Exams - What to study out of?

[Paula_Stankus]

Title: RE: OCP Exams - What to study out of?





Just the first one.  That is the only one I have tried.  I have the second one Nov. 12th.  I am spacing them out a little because I have football games to go to, holidays, elderly parents, etc.  I will let you know the gory details if you wish.  My approach for the second exam I signed up for (backup and recovery) was the same study Cor. book, take self exams.  I haven't gotten a chance to do the self exams yet.  Too many other commitments.  So this is probably more from the seat of my pants.  However, while going through Cor. I am using that to tidy up backup/recovery, writing disaster recovery plans, etc.  Killing a few birds with one stone.  

-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 05, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OCP Exams - What to study out of?



Paula - You're losing me on the connection between SQL and GUI. I can see a
connection between command-line DBA actions and GUI DBA tools. And some GUI
report writing tools create SQL for you, but usually we DBAs are called when
it creates bad SQL code and we must straighten it out.  
 So have you passed all 5 OCP modules?




Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, November 05, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L




I took the SQL exam first and had no problems although I have heard others
have.  I think it has to do with how I learned - I forced myself to use SQL
before getting hooked into a GUI tool of any kind.  In the long-run that is
a good approach as you will always have that but might not always have the
GUI.


-Original Message- 
<mailto:[EMAIL PROTECTED]> ] 
Sent: Tuesday, November 05, 2002 12:04 PM 
To: Multiple recipients of list ORACLE-L 



Eva - Everything I've heard says that all the exam questions come out of the


Oracle University class Student Guides. To put it bluntly, your goal is to 
pass the exam. You could study the Oracle manuals, but there is a lot of 
material to cover and what strikes you as important might not be covered on 
the exam, and vice-versa. Essentially you are getting two levels of 
filtering. Somebody read the manuals and used that to prepare student 
guides, then a group of Oracle instructors read the student guide and 
prepared questions. I think that most of the exam guides were prepared from 
the Oracle Student Guides and the author has at least taken the exam, so 
they have a general idea of how the test is approached. Everyone has their 
favorite exam preparation book and I consider this a worthwhile investment, 
I bought Couchman - 
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
<http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
0>  
H 
<
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
<http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
>  
0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007


2133414> 
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721


33414 
   Two issues: Which exam track are you planning to take? 9i? 8i? 
   The advice I received is "don't take the SQL exam as your first exam". 
Take the DBA exam first. The SQL exam is reported to be quite hard because 
it covers all the odd SQL functions and can really catch you unawares. As a 
practicing DBA you should find the DBA exam pretty easy. I didn't personally


take that path for my own reasons, but I still consider it good advice. 




Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message- 
Sent: Tuesday, November 05, 2002 6:09 AM 
To: Multiple recipients of list ORACLE-L 




Hello Everyone, 


1. I have now made the humungous decision to start studying and to write the


OCP exams. 
2. Do I study out of the Oracle Manuals? 
3. I do have the Sybex Study Guides, would studying these be all that is 
needed? 
4. Or do the questions come out of the Course material ( Which I have not 
attended ). 
5. I do have some of the Oreilly "Insect" Books - would these be any help? 


Any views, opinions etc appreciated. 
Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to


understand the simplicity." 
Dennis Ritchie. 




  _  


DISCLAIMER 




This message is for the named person's use only. It may contain 
confidential, proprietary or legally privileged information. No 
confidentiality or privilege is waived or lost by any mistransmission. If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender. You must not, directly or indirectly, use,

Re: OCP Exams - What to study out of?

[KENNETH JANUSZ]

Title: RE: OCP Exams - What to study out of?



Unfortunately there are no Corioulus books for 
9i.
 
Ken

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, November 06, 2002 8:08 
  AM
  Subject: RE: OCP Exams - What to study 
  out of?
  
  But I did.  All I did was study the Corioulus book - and 
  took the exams. 
  -Original Message- From: 
  DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, November 05, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: OCP Exams - What to study out of? 
  Ken - Wow, I'm impressed. I took and passed one APICS module 
  years and years ago and I can testify that they aren't 
  easy. And I took the module related to my daily 
  job.    Can you share any tips on how to 
  study for the SQL exam? I find I learn MUCH more from 
  someone that was forced to reassess their strategy than from people that say "oh, I took the manual home two nights and breezed 
  through it". 
  Dennis Williams DBA, 40%OCP 
  Lifetouch, Inc. [EMAIL PROTECTED] 
  -Original Message- Sent: 
  Tuesday, November 05, 2002 2:04 PM To: Multiple 
  recipients of list ORACLE-L 
  I agree that the SQL exam is very difficult.  I've taken 
  it twice and missed passing by just a couple of 
  points.  But I will persist. 
  Interestingly enough when I got my APICS CPIM certification I 
  took six exams and passed them all on the first 
  try.  The passing grade is 90%. 
  Ken Janusz, CPIM 
  - Original Message - To: 
  "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 
  Sent: Tuesday, November 05, 2002 11:03 AM 
  > Eva - Everything I've heard says that all the exam 
  questions come out of the > 
  Oracle University class Student Guides. To put it bluntly, your goal is 
  to > pass the exam. You could study the Oracle 
  manuals, but there is a lot of > material to cover 
  and what strikes you as important might not be covered on > the exam, and vice-versa. Essentially 
  you are getting two levels of > filtering. Somebody 
  read the manuals and used that to prepare student > 
  guides, then a group of Oracle instructors read the student guide and 
  > prepared questions. I think that most of the exam guides 
  were prepared from > the 
  Oracle Student Guides and the author has at least taken the exam, so 
  > they have a general idea of how the test is approached. 
  Everyone has their > favorite exam preparation book 
  and I consider this a worthwhile investment, 
  > I bought Couchman - > 
  http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0 
  > H > <http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL 
  > 0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007 
  > 2133414> > 
  &sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721 
  > 33414 >    Two 
  issues: Which exam track are you planning to take? 9i? 8i? >    The advice I received is "don't take the SQL 
  exam as your first exam". > Take the DBA exam 
  first. The SQL exam is reported to be quite hard because > it covers all the odd SQL functions and can really catch you 
  unawares. As a > practicing 
  DBA you should find the DBA exam pretty easy. I didn't personally > take that path for my own 
  reasons, but I still consider it good advice. > > > 
  > Dennis Williams > DBA, 
  40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > 
  > -Original Message- > 
  Sent: Tuesday, November 05, 2002 6:09 AM > To: 
  Multiple recipients of list ORACLE-L > 
  > > > Hello Everyone, > > 1. I have now made the humungous decision to start studying and to 
  write the > OCP 
  exams. > 2. Do I study out of the Oracle 
  Manuals? > 3. I do have the Sybex Study Guides, 
  would studying these be all that is > 
  needed? > 4. Or do the questions come out of the 
  Course material ( Which I have not > attended 
  ). > 5. I do have some of the Oreilly "Insect" 
  Books - would these be any help? > > Any views, opinions etc appreciated. > 
  Regards > Denham Eva > 
  Oracle DBA > "UNIX is basically a simple operating 
  system, but you have to be a genius to 
  > understand the simplicity." > 
  Dennis Ritchie. > > > >   _ > > DISCLAIMER > > > > This 
  message is for the named person's use only. It may contain > confidential, proprietary or legally privileged information. 
  No > confidentiality or privilege is waived or lost 
  by any mistransmission. If > you receive this 
  message in error, please immediately delete it and all > copies of it from your system, destroy any hard copies o

RE: OCP Exams - What to study out of?

[Paula_Stankus]

Title: RE: OCP Exams - What to study out of?





But I did.  All I did was study the Corioulus book - and took the exams.


-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 05, 2002 4:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OCP Exams - What to study out of?



Ken - Wow, I'm impressed. I took and passed one APICS module years and years
ago and I can testify that they aren't easy. And I took the module related
to my daily job.
   Can you share any tips on how to study for the SQL exam? I find I learn
MUCH more from someone that was forced to reassess their strategy than from
people that say "oh, I took the manual home two nights and breezed through
it". 


Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 



-Original Message-
Sent: Tuesday, November 05, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L



I agree that the SQL exam is very difficult.  I've taken it twice and missed
passing by just a couple of points.  But I will persist.


Interestingly enough when I got my APICS CPIM certification I took six exams
and passed them all on the first try.  The passing grade is 90%.


Ken Janusz, CPIM


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 11:03 AM



> Eva - Everything I've heard says that all the exam questions come out of
the
> Oracle University class Student Guides. To put it bluntly, your goal is to
> pass the exam. You could study the Oracle manuals, but there is a lot of
> material to cover and what strikes you as important might not be covered
on
> the exam, and vice-versa. Essentially you are getting two levels of
> filtering. Somebody read the manuals and used that to prepare student
> guides, then a group of Oracle instructors read the student guide and
> prepared questions. I think that most of the exam guides were prepared
from
> the Oracle Student Guides and the author has at least taken the exam, so
> they have a general idea of how the test is approached. Everyone has their
> favorite exam preparation book and I consider this a worthwhile
investment,
> I bought Couchman -
>
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
> H
>
<http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
>
0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007
> 2133414>
>
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721
> 33414
>    Two issues: Which exam track are you planning to take? 9i? 8i?
>    The advice I received is "don't take the SQL exam as your first exam".
> Take the DBA exam first. The SQL exam is reported to be quite hard because
> it covers all the odd SQL functions and can really catch you unawares. As
a
> practicing DBA you should find the DBA exam pretty easy. I didn't
personally
> take that path for my own reasons, but I still consider it good advice.
>
>
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Tuesday, November 05, 2002 6:09 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hello Everyone,
>
> 1. I have now made the humungous decision to start studying and to write
the
> OCP exams.
> 2. Do I study out of the Oracle Manuals?
> 3. I do have the Sybex Study Guides, would studying these be all that is
> needed?
> 4. Or do the questions come out of the Course material ( Which I have not
> attended ).
> 5. I do have some of the Oreilly "Insect" Books - would these be any help?
>
> Any views, opinions etc appreciated.
> Regards
> Denham Eva
> Oracle DBA
> "UNIX is basically a simple operating system, but you have to be a genius
to
> understand the simplicity."
> Dennis Ritchie.
>
>
>
>   _
>
> DISCLAIMER
>
>
>
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mistransmission. If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify
the
> sender. You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. TFMC, its holding company, and any of its subsidiaries each
> reserve the right to monitor and manage all e-mail communications through
> its networks.
>
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise a

RE: OCP Exams - What to study out of?

[Denham Eva]

Title: OCP Exams - What to study out of?



Thanks 
to everyone for their input. I am considering the 8i track.
a. 
Because I work mainly with the 8i DB.
b. I 
hear that for the 9i a attendance of a course is a 
prerequisite. 
 
Regards
Denham

  -Original Message-From: Denham Eva 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 05, 2002 2:09 
  PMTo: Multiple recipients of list ORACLE-LSubject: OCP 
  Exams - What to study out of?
  Hello Everyone, 
  1. I have now made the humungous decision to start 
  studying and to write the OCP exams. 2. Do 
  I study out of the Oracle Manuals? 3. I do 
  have the Sybex Study Guides, would studying these be all that is 
  needed? 4. Or do the questions come out of 
  the Course material ( Which I have not attended ). 5. I do have some of the Oreilly "Insect" Books - would these be any 
  help? 
  Any views, opinions etc appreciated. 
  Regards Denham 
  Eva Oracle DBA 
  "UNIX is basically a simple 
  operating system, but you have to be a genius to understand the 
  simplicity." Dennis 
  Ritchie. 
  
  
  DISCLAIMER 
  
  This message is for the named person's use 
  only. It may contain confidential, proprietary or legally privileged 
  information. No confidentiality or privilege is waived or lost by any 
  mistransmission. If you receive this message in error, please immediately 
  delete it and all copies of it from your system, destroy any hard copies of it 
  and notify the sender. You must not, directly or indirectly, use, disclose, 
  distribute, print, or copy any part of this message if you are not the 
  intended recipient. TFMC, its holding company, and any of its subsidiaries 
  each reserve the right to monitor and manage all e-mail communications through 
  its networks. 
  Any views expressed in this message are those 
  of the individual sender, except where the message states otherwise and the 
  sender is authorized to state them to be views of any such entity. 
  
  

  
  
  This e-mail message has been scanned for Viruses and Content and cleared by 
  MailMarshal - For more information 
  please visit www.marshalsoftware.com 
  
  
  
  
  
  DISCLAIMER 
  
  This message is for the named person's use 
  only. It may contain confidential, proprietary or legally privileged 
  information. No confidentiality or privilege is waived or lost by any 
  mistransmission. If you receive this message in error, please immediately 
  delete it and all copies of it from your system, destroy any hard copies of it 
  and notify the sender. You must not, directly or indirectly, use, disclose, 
  distribute, print, or copy any part of this message if you are not the 
  intended recipient. TFMC, its holding company, and any of its subsidiaries 
  each reserve the right to monitor and manage all e-mail communications through 
  its networks. 
  Any views expressed in this message are those 
  of the individual sender, except where the message states otherwise and the 
  sender is authorized to state them to be views of any such entity. 
  
  

  
  
  This e-mail message has been scanned for Viruses and Content and cleared by 
  MailMarshal - For more information 
  please visit www.marshalsoftware.com 
  
  




DISCLAIMER 

This message is for the named person's use 
only. It may contain confidential, proprietary or legally privileged 
information. No confidentiality or privilege is waived or lost by any 
mistransmission. If you receive this message in error, please immediately delete 
it and all copies of it from your system, destroy any hard copies of it and 
notify the sender. You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. TFMC, its holding company, and any of its subsidiaries each reserve 
the right to monitor and manage all e-mail communications through its 
networks. 
Any views expressed in this message are those 
of the individual sender, except where the message states otherwise and the 
sender is authorized to state them to be views of any such entity. 





This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - 
For more information please visit  
  www.marshalsoftware.com 

RE: OCP Exams - What to study out of?

[DENNIS WILLIAMS]

Ken - Wow, I'm impressed. I took and passed one APICS module years and years
ago and I can testify that they aren't easy. And I took the module related
to my daily job.
   Can you share any tips on how to study for the SQL exam? I find I learn
MUCH more from someone that was forced to reassess their strategy than from
people that say "oh, I took the manual home two nights and breezed through
it". 

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, November 05, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


I agree that the SQL exam is very difficult.  I've taken it twice and missed
passing by just a couple of points.  But I will persist.

Interestingly enough when I got my APICS CPIM certification I took six exams
and passed them all on the first try.  The passing grade is 90%.

Ken Janusz, CPIM

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 11:03 AM


> Eva - Everything I've heard says that all the exam questions come out of
the
> Oracle University class Student Guides. To put it bluntly, your goal is to
> pass the exam. You could study the Oracle manuals, but there is a lot of
> material to cover and what strikes you as important might not be covered
on
> the exam, and vice-versa. Essentially you are getting two levels of
> filtering. Somebody read the manuals and used that to prepare student
> guides, then a group of Oracle instructors read the student guide and
> prepared questions. I think that most of the exam guides were prepared
from
> the Oracle Student Guides and the author has at least taken the exam, so
> they have a general idea of how the test is approached. Everyone has their
> favorite exam preparation book and I consider this a worthwhile
investment,
> I bought Couchman -
>
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
> H
>

0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007
> 2133414>
>
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721
> 33414
>Two issues: Which exam track are you planning to take? 9i? 8i?
>The advice I received is "don't take the SQL exam as your first exam".
> Take the DBA exam first. The SQL exam is reported to be quite hard because
> it covers all the odd SQL functions and can really catch you unawares. As
a
> practicing DBA you should find the DBA exam pretty easy. I didn't
personally
> take that path for my own reasons, but I still consider it good advice.
>
>
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Tuesday, November 05, 2002 6:09 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hello Everyone,
>
> 1. I have now made the humungous decision to start studying and to write
the
> OCP exams.
> 2. Do I study out of the Oracle Manuals?
> 3. I do have the Sybex Study Guides, would studying these be all that is
> needed?
> 4. Or do the questions come out of the Course material ( Which I have not
> attended ).
> 5. I do have some of the Oreilly "Insect" Books - would these be any help?
>
> Any views, opinions etc appreciated.
> Regards
> Denham Eva
> Oracle DBA
> "UNIX is basically a simple operating system, but you have to be a genius
to
> understand the simplicity."
> Dennis Ritchie.
>
>
>
>   _
>
> DISCLAIMER
>
>
>
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mistransmission. If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify
the
> sender. You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. TFMC, its holding company, and any of its subsidiaries each
> reserve the right to monitor and manage all e-mail communications through
> its networks.
>
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized to
> state them to be views of any such entity.
>
>   _
>
>
>
>
>   _
>
> This e-mail message has been scanned for Viruses and Content and cleared
by
> MailMarshal - For more information please visit
>  www.marshalsoftware.com
>   _
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   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-M

RE: OCP Exams - What to study out of?

[DENNIS WILLIAMS]

Paula - You're losing me on the connection between SQL and GUI. I can see a
connection between command-line DBA actions and GUI DBA tools. And some GUI
report writing tools create SQL for you, but usually we DBAs are called when
it creates bad SQL code and we must straighten it out.  
 So have you passed all 5 OCP modules?



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, November 05, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L



I took the SQL exam first and had no problems although I have heard others
have.  I think it has to do with how I learned - I forced myself to use SQL
before getting hooked into a GUI tool of any kind.  In the long-run that is
a good approach as you will always have that but might not always have the
GUI.

-Original Message- 
 ] 
Sent: Tuesday, November 05, 2002 12:04 PM 
To: Multiple recipients of list ORACLE-L 


Eva - Everything I've heard says that all the exam questions come out of the

Oracle University class Student Guides. To put it bluntly, your goal is to 
pass the exam. You could study the Oracle manuals, but there is a lot of 
material to cover and what strikes you as important might not be covered on 
the exam, and vice-versa. Essentially you are getting two levels of 
filtering. Somebody read the manuals and used that to prepare student 
guides, then a group of Oracle instructors read the student guide and 
prepared questions. I think that most of the exam guides were prepared from 
the Oracle Student Guides and the author has at least taken the exam, so 
they have a general idea of how the test is approached. Everyone has their 
favorite exam preparation book and I consider this a worthwhile investment, 
I bought Couchman - 
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
  
H 
<
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
  
0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007

2133414> 
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721

33414 
   Two issues: Which exam track are you planning to take? 9i? 8i? 
   The advice I received is "don't take the SQL exam as your first exam". 
Take the DBA exam first. The SQL exam is reported to be quite hard because 
it covers all the odd SQL functions and can really catch you unawares. As a 
practicing DBA you should find the DBA exam pretty easy. I didn't personally

take that path for my own reasons, but I still consider it good advice. 



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message- 
Sent: Tuesday, November 05, 2002 6:09 AM 
To: Multiple recipients of list ORACLE-L 



Hello Everyone, 

1. I have now made the humungous decision to start studying and to write the

OCP exams. 
2. Do I study out of the Oracle Manuals? 
3. I do have the Sybex Study Guides, would studying these be all that is 
needed? 
4. Or do the questions come out of the Course material ( Which I have not 
attended ). 
5. I do have some of the Oreilly "Insect" Books - would these be any help? 

Any views, opinions etc appreciated. 
Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to

understand the simplicity." 
Dennis Ritchie. 



  _  

DISCLAIMER 



This message is for the named person's use only. It may contain 
confidential, proprietary or legally privileged information. No 
confidentiality or privilege is waived or lost by any mistransmission. If 
you receive this message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify the 
sender. You must not, directly or indirectly, use, disclose, distribute, 
print, or copy any part of this message if you are not the intended 
recipient. TFMC, its holding company, and any of its subsidiaries each 
reserve the right to monitor and manage all e-mail communications through 
its networks. 

Any views expressed in this message are those of the individual sender, 
except where the message states otherwise and the sender is authorized to 
state them to be views of any such entity. 

  _  




  _  

This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - For more information please visit 
< http://www.marshalsoftware.com  >
www.marshalsoftware.com 
  _  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: DENNIS WILLIAMS 
  INET: [EMAIL PROTECTED] 

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

Re: OCP Exams - What to study out of?

[KENNETH JANUSZ]

I agree that the SQL exam is very difficult.  I've taken it twice and missed
passing by just a couple of points.  But I will persist.

Interestingly enough when I got my APICS CPIM certification I took six exams
and passed them all on the first try.  The passing grade is 90%.

Ken Janusz, CPIM

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, November 05, 2002 11:03 AM


> Eva - Everything I've heard says that all the exam questions come out of
the
> Oracle University class Student Guides. To put it bluntly, your goal is to
> pass the exam. You could study the Oracle manuals, but there is a lot of
> material to cover and what strikes you as important might not be covered
on
> the exam, and vice-versa. Essentially you are getting two levels of
> filtering. Somebody read the manuals and used that to prepare student
> guides, then a group of Oracle instructors read the student guide and
> prepared questions. I think that most of the exam guides were prepared
from
> the Oracle Student Guides and the author has at least taken the exam, so
> they have a general idea of how the test is approached. Everyone has their
> favorite exam preparation book and I consider this a worthwhile
investment,
> I bought Couchman -
>
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
> H
>

0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007
> 2133414>
>
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721
> 33414
>Two issues: Which exam track are you planning to take? 9i? 8i?
>The advice I received is "don't take the SQL exam as your first exam".
> Take the DBA exam first. The SQL exam is reported to be quite hard because
> it covers all the odd SQL functions and can really catch you unawares. As
a
> practicing DBA you should find the DBA exam pretty easy. I didn't
personally
> take that path for my own reasons, but I still consider it good advice.
>
>
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -Original Message-
> Sent: Tuesday, November 05, 2002 6:09 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hello Everyone,
>
> 1. I have now made the humungous decision to start studying and to write
the
> OCP exams.
> 2. Do I study out of the Oracle Manuals?
> 3. I do have the Sybex Study Guides, would studying these be all that is
> needed?
> 4. Or do the questions come out of the Course material ( Which I have not
> attended ).
> 5. I do have some of the Oreilly "Insect" Books - would these be any help?
>
> Any views, opinions etc appreciated.
> Regards
> Denham Eva
> Oracle DBA
> "UNIX is basically a simple operating system, but you have to be a genius
to
> understand the simplicity."
> Dennis Ritchie.
>
>
>
>   _
>
> DISCLAIMER
>
>
>
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mistransmission. If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify
the
> sender. You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. TFMC, its holding company, and any of its subsidiaries each
> reserve the right to monitor and manage all e-mail communications through
> its networks.
>
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized to
> state them to be views of any such entity.
>
>   _
>
>
>
>
>   _
>
> This e-mail message has been scanned for Viruses and Content and cleared
by
> MailMarshal - For more information please visit
>  www.marshalsoftware.com
>   _
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
>   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.com
-- 
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
---

RE: OCP Exams - What to study out of?

[Rick_Cale]

The Cloverleaf product I know is from Quovadx.  One of its usages it
provides an interface between Healthcare systems and Oracle(many  other
DBMS).  For ex. we use to interface with hospitals sending data in standard
HL7 format and Cloverleaf interprets
HL7 format and data is loaded directly into Oracle for further processing.

See http://www.quovadx.com/ for more info

Rick




   

[EMAIL PROTECTED]

tate.fl.usTo: Multiple recipients of list 
ORACLE-L 
Sent by:   <[EMAIL PROTECTED]>  

[EMAIL PROTECTED]  cc:  

  Subject:     RE: OCP Exams - What to 
study out of?   
   

11/05/2002 10:23 AM

Please respond to  

ORACLE-L   

   

   





Guys, anyone know about an application called Cloverleaf?  Basically, my
organization is pursuing using Cloverleaf as the data integration sole
application of choice.  To me Unix/SQL*Loader and native tools for the
various RDBMS usually are more straightforward and provide simplication and
less proprietary coding and it is easier for an organization to find others
who have those type of skills.  Any ideas guys?


-Original Message-
Sent: Tuesday, November 05, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L





Denham,
I have just passed my 8i upgrade exam and added some notes to a page about
getting OCP certification.
It can be accessed on http://www.hcresources.co.uk/ocp.htm
<http://www.hcresources.co.uk/ocp.htm>

Hope you find it interesting

John


-Original Message-
Sent: 05 November 2002 12:09
To: Multiple recipients of list ORACLE-L






Hello Everyone,


1. I have now made the humungous decision to start studying and to write
the
OCP exams.
2. Do I study out of the Oracle Manuals?
3. I do have the Sybex Study Guides, would studying these be all that is
needed?
4. Or do the questions come out of the Course material ( Which I have not
attended ).
5. I do have some of the Oreilly "Insect" Books - would these be any help?


Any views, opinions etc appreciated.
Regards
Denham Eva
Oracle DBA
"UNIX is basically a simple operating system, but you have to be a genius
to
understand the simplicity."
Dennis Ritchie.






  _


DISCLAIMER






This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the

sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications through
its networks.


Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be views of any such entity.


  _







  _


This e-mail message has been scanned for Viruses and Content and cleared by

MailMarshal - For more information please visit
<http://www.marshalsoftware.com> www.marshalsoftware.com
  _





--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  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:/

RE: OCP Exams - What to study out of?

[Paula_Stankus]

Title: RE: OCP Exams - What to study out of?





I took the SQL exam first and had no problems although I have heard others have.  I think it has to do with how I learned - I forced myself to use SQL before getting hooked into a GUI tool of any kind.  In the long-run that is a good approach as you will always have that but might not always have the GUI.

-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 05, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OCP Exams - What to study out of?



Eva - Everything I've heard says that all the exam questions come out of the
Oracle University class Student Guides. To put it bluntly, your goal is to
pass the exam. You could study the Oracle manuals, but there is a lot of
material to cover and what strikes you as important might not be covered on
the exam, and vice-versa. Essentially you are getting two levels of
filtering. Somebody read the manuals and used that to prepare student
guides, then a group of Oracle instructors read the student guide and
prepared questions. I think that most of the exam guides were prepared from
the Oracle Student Guides and the author has at least taken the exam, so
they have a general idea of how the test is approached. Everyone has their
favorite exam preparation book and I consider this a worthwhile investment,
I bought Couchman -
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
H
<http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL
0H&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=007
2133414>
&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721
33414
   Two issues: Which exam track are you planning to take? 9i? 8i? 
   The advice I received is "don't take the SQL exam as your first exam".
Take the DBA exam first. The SQL exam is reported to be quite hard because
it covers all the odd SQL functions and can really catch you unawares. As a
practicing DBA you should find the DBA exam pretty easy. I didn't personally
take that path for my own reasons, but I still consider it good advice.




Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, November 05, 2002 6:09 AM
To: Multiple recipients of list ORACLE-L




Hello Everyone, 


1. I have now made the humungous decision to start studying and to write the
OCP exams. 
2. Do I study out of the Oracle Manuals? 
3. I do have the Sybex Study Guides, would studying these be all that is
needed? 
4. Or do the questions come out of the Course material ( Which I have not
attended ). 
5. I do have some of the Oreilly "Insect" Books - would these be any help? 


Any views, opinions etc appreciated. 
Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity." 
Dennis Ritchie. 




  _  


DISCLAIMER 




This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications through
its networks. 


Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be views of any such entity. 


  _  





  _  


This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
<http://www.marshalsoftware.com> www.marshalsoftware.com 
  _  



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: OCP Exams - What to study out of?

[DENNIS WILLIAMS]

Eva - Everything I've heard says that all the exam questions come out of the
Oracle University class Student Guides. To put it bluntly, your goal is to
pass the exam. You could study the Oracle manuals, but there is a lot of
material to cover and what strikes you as important might not be covered on
the exam, and vice-versa. Essentially you are getting two levels of
filtering. Somebody read the manuals and used that to prepare student
guides, then a group of Oracle instructors read the student guide and
prepared questions. I think that most of the exam guides were prepared from
the Oracle Student Guides and the author has at least taken the exam, so
they have a general idea of how the test is approached. Everyone has their
favorite exam preparation book and I consider this a worthwhile investment,
I bought Couchman -
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=6WIANMIL0
H

&sourceid=00400731866779927243&bfdate=11%2D05%2D2002+10%3A16%3A17&isbn=00721
33414
   Two issues: Which exam track are you planning to take? 9i? 8i? 
   The advice I received is "don't take the SQL exam as your first exam".
Take the DBA exam first. The SQL exam is reported to be quite hard because
it covers all the odd SQL functions and can really catch you unawares. As a
practicing DBA you should find the DBA exam pretty easy. I didn't personally
take that path for my own reasons, but I still consider it good advice.



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, November 05, 2002 6:09 AM
To: Multiple recipients of list ORACLE-L



Hello Everyone, 

1. I have now made the humungous decision to start studying and to write the
OCP exams. 
2. Do I study out of the Oracle Manuals? 
3. I do have the Sybex Study Guides, would studying these be all that is
needed? 
4. Or do the questions come out of the Course material ( Which I have not
attended ). 
5. I do have some of the Oreilly "Insect" Books - would these be any help? 

Any views, opinions etc appreciated. 
Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity." 
Dennis Ritchie. 



  _  

DISCLAIMER 



This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications through
its networks. 

Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be views of any such entity. 

  _  




  _  

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
 www.marshalsoftware.com 
  _  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: OCP Exams - What to study out of?

[Paula_Stankus]

Title: RE: OCP Exams - What to study out of?





Guys, anyone know about an application called Cloverleaf?  Basically, my organization is pursuing using Cloverleaf as the data integration sole application of choice.  To me Unix/SQL*Loader and native tools for the various RDBMS usually are more straightforward and provide simplication and less proprietary coding and it is easier for an organization to find others who have those type of skills.  Any ideas guys?  

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 05, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OCP Exams - What to study out of?



Denham,
I have just passed my 8i upgrade exam and added some notes to a page about
getting OCP certification.
It can be accessed on http://www.hcresources.co.uk/ocp.htm
<http://www.hcresources.co.uk/ocp.htm>  
 
Hope you find it interesting
 
John


-Original Message-
Sent: 05 November 2002 12:09
To: Multiple recipients of list ORACLE-L




Hello Everyone, 


1. I have now made the humungous decision to start studying and to write the
OCP exams. 
2. Do I study out of the Oracle Manuals? 
3. I do have the Sybex Study Guides, would studying these be all that is
needed? 
4. Or do the questions come out of the Course material ( Which I have not
attended ). 
5. I do have some of the Oreilly "Insect" Books - would these be any help? 


Any views, opinions etc appreciated. 
Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity." 
Dennis Ritchie. 




  _  


DISCLAIMER 




This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications through
its networks. 


Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be views of any such entity. 


  _  





  _  


This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
<http://www.marshalsoftware.com> www.marshalsoftware.com 
  _  



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: OCP Exams - What to study out of?

[John . Hallas]

Denham,
I have just passed my 8i upgrade exam and added some notes to a page about
getting OCP certification.
It can be accessed on http://www.hcresources.co.uk/ocp.htm
  
 
Hope you find it interesting
 
John

-Original Message-
Sent: 05 November 2002 12:09
To: Multiple recipients of list ORACLE-L



Hello Everyone, 

1. I have now made the humungous decision to start studying and to write the
OCP exams. 
2. Do I study out of the Oracle Manuals? 
3. I do have the Sybex Study Guides, would studying these be all that is
needed? 
4. Or do the questions come out of the Course material ( Which I have not
attended ). 
5. I do have some of the Oreilly "Insect" Books - would these be any help? 

Any views, opinions etc appreciated. 
Regards 
Denham Eva 
Oracle DBA 
"UNIX is basically a simple operating system, but you have to be a genius to
understand the simplicity." 
Dennis Ritchie. 



  _  

DISCLAIMER 



This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. TFMC, its holding company, and any of its subsidiaries each
reserve the right to monitor and manage all e-mail communications through
its networks. 

Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized to
state them to be views of any such entity. 

  _  




  _  

This e-mail message has been scanned for Viruses and Content and cleared by
MailMarshal - For more information please visit
 www.marshalsoftware.com 
  _  


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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: OCP Exams - What to study out of?

[Paula_Stankus]

Title: OCP Exams - What to study out of?



I only 
studied the Coriolius books and done the self-exams (which are harder then the 
real one) and passed with 85+% each time.  I think the course materials 
were not as concise as the Cor. books.  I believe you can get some of those 
books still on Amazon.  That publisher is out of business.  Someone 
recently posted which publisher is taking over for them.  Good 
luck.

  -Original Message-From: Denham Eva 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 05, 2002 7:09 
  AMTo: Multiple recipients of list ORACLE-LSubject: OCP 
  Exams - What to study out of?
  Hello Everyone, 
  1. I have now made the humungous decision to start 
  studying and to write the OCP exams. 2. Do 
  I study out of the Oracle Manuals? 3. I do 
  have the Sybex Study Guides, would studying these be all that is 
  needed? 4. Or do the questions come out of 
  the Course material ( Which I have not attended ). 5. I do have some of the Oreilly "Insect" Books - would these be any 
  help? 
  Any views, opinions etc appreciated. 
  Regards Denham 
  Eva Oracle DBA 
  "UNIX is basically a simple 
  operating system, but you have to be a genius to understand the 
  simplicity." Dennis 
  Ritchie. 
  
  
  DISCLAIMER 
  
  This message is for the named person's use 
  only. It may contain confidential, proprietary or legally privileged 
  information. No confidentiality or privilege is waived or lost by any 
  mistransmission. If you receive this message in error, please immediately 
  delete it and all copies of it from your system, destroy any hard copies of it 
  and notify the sender. You must not, directly or indirectly, use, disclose, 
  distribute, print, or copy any part of this message if you are not the 
  intended recipient. TFMC, its holding company, and any of its subsidiaries 
  each reserve the right to monitor and manage all e-mail communications through 
  its networks. 
  Any views expressed in this message are those 
  of the individual sender, except where the message states otherwise and the 
  sender is authorized to state them to be views of any such entity. 
  
  

  
  
  This e-mail message has been scanned for Viruses and Content and cleared by 
  MailMarshal - For more information 
  please visit www.marshalsoftware.com 
  
  

Re: OCP (OPP number)/OTN20

[Mohammad Rafiq]

If you are an employee of OPP then you can use this code. Enter required 
info on screen or call them for test appointment and if you want that 
discount they will ask this question there. Alternately get registered on 
OTN and claim 'OTN20' for 20% discount(net $100). At examination center they 
don't ask anything except your identity..

HTH,

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Mon, 07 Oct 2002 10:49:04 -0800

Hi,

I just registered for oracle 8i upgrade exam and enter the promotion code 
OPP(Oracle preffered partner) but it never prompt to
enter my company name or partner number. Do i need to take copy of OPP copy 
at centre or they will not see it at all??

Thanks
--Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
   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).




_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  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: OCP discount

[John . Hallas]

OPP gets you 35% discount (state member of OTN)

John

-Original Message-
Sent: 05 July 2002 16:13
To: Multiple recipients of list ORACLE-L


Anybody knows of a current "magic" code for a discount on OCP exams.  I am
particularly looking into the 8i DBA upgrade if this does matter.

Thanks.

Djordje
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djordje Jankovic
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: ocp exam/when?

[Reddy, Madhusudana]

http://www.oracle.com/education/certification/index.html?dba9i_ocp.html
 
The above page shows , 
 
Candidates for Oracle9i 
DBA OCP must pass the following two exams as well as completing at least one 
Oracle University required hands-on course within the Oracle9i DBA learning path 
to obtain your OCP credential: 
 
check out on the page , even I am not very clear about this ... but seems 
like you can not eliminate that HANDS ON from Oracle to get OCP 
credential
 
--Madhu
 
 

  -Original Message-From: Lyuda Hoska 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 20, 2002 4:06 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  ocp exam/when?
  
  Thanks.  I was 
  scared...
  I am going to take it 
  a step at the time and become an Associate first.  To me it is a good deal you become an 
  Oracle certified (how sweet the sound) only after two exams. I'll move to a 
  next level after gaining more knowledge and taking a little break from 
  studying.
   
  Just talked to a 
  friend of mine.  He decided to 
  finish his 8i first and then go for upgrade (trying to avoid that exam).  He is a consultant. I think my company 
  would pay $2000 if I asked.
  Depends on the 
  situation...
   
  Buy the way; do you 
  have any reference to Oracle official statement that it is required for 
  Masters only?  I would appreciate 
  it.
  Thank 
  you.
   
   
  -Original 
  Message-From: JOE TESTA 
  [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 
  2002 2:37 
  PMTo: [EMAIL PROTECTED]Subject: RE: ocp 
  exam/when?
   
  
  Check out education.oracle.com and look 
  for certification.
  
   
  
  the reality is unless you want to become 
  an Oracle Certified Master(which you have to be Oracle Certified Professional 
  first), then the 2K price tag will not pertain to 
  you.
  
   
  
  joe
  
   

RE: ocp exam/when?

[Lyuda Hoska]

Thanks.  I was scared...

I am going to take it a step at the time
and become an Associate first.  To
me it is a good deal you become an Oracle certified (how sweet the sound) only
after two exams. I'll move to a next level after gaining more knowledge
and taking a little break from studying.

 

Just talked to a friend of mine.  He decided to finish his 8i first and
then go for upgrade (trying to avoid that exam).  He is a consultant. I think my company
would pay $2000 if I asked.

Depends on the situation...

 

Buy the way; do you have any reference to
Oracle official statement that it is required for Masters only?  I would appreciate it.

Thank you.

 

 

-Original Message-
From: JOE TESTA
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, June 20, 2002 2:37 PM
To: [EMAIL PROTECTED]
Subject: RE: ocp exam/when?

 



Check out education.oracle.com and look for
certification.





 





the reality is unless you want to become an Oracle
Certified Master(which you have to be Oracle Certified Professional first),
then the 2K price tag will not pertain to you.





 





joe