Oracle Certified Masters exam
Pete Sharman
Certified Masters practicum exam, and would provide you folks with some feedback
on it. This was in relation to a discussion about the Oracle Certified
Professional program being too easy to pass without hands-on knowledge of the
database.
Well, rest assured you will NEVER get through the OCM exam without handson
experience. I've been using Oracle database technology for 16 odd years now,
and I finished each day of the two day exam feeling like a wrung out dish rag.
It's a very tough exam to get through, and as such certainly answers every piece
of negative feedback I've seen on the OCP program. You can rest assured that
anyone who gets through the OCM will really know their stuff with the Oracle
database.
Now if someone will kindly pass me a bottle of whiskey so I have an excuse to
pass out ...
Pete
For full details of the requirements for the OCM, go to
http://www.oracle.com/education/certification/index.html?dba9i_ocm.html, but
here's the list of things that may be covered in the exam FYI:
Database Configuration
Determine and set sizing parameters for database segments.
Create and manage temporary, permanent and undo tablespaces.
Stripe data files across multiple physical devices and locations.
Configure the database environment to support optimal data access performance.
Protect the database from loss of data from any failure scenario.
Create and manage database configuration files.
Oracle Network Configuration
Create and manage multiple network configuration files.
Configure the database instance to support shared server connections.
Setup network tracing.
Configure the network environment to efficiently manage user connections.
Manage Oracle network processes.
Configure the network environment to allow connections to multiple databases.
Oracle Enterprise Manager
Install and configure Oracle Enterprise Manager.
Install and configure the OEM Tuning Pack.
Install and configure the OEM Diagnostics Pack.
Use OEM to modify a database configuration.
Configure OEM to manage database availability.
Perform database administration operations using OEM.
Database Availability
Create a recovery catalog using Recovery Manager.
Use Recovery Manager to perform database backups.
Use Recovery Manager to perform a complete database restore and recovery.
Configure the TNSNAMES.ORA file to support remote connections to a catalog
database using TCP.
Perform a complete recovery from any failure scenario.
Data Management
Create and manage tablespaces to support database access activities.
Manage partitioning within a database environment.
Configure auditing within the database.
Provide users with access to data.
Provide access to data using flashback.
Database Management
Implement fine-grained security.
Generate table, index, column, and system statistics.
Manage the SGA.
Manage new users.
Implement Replication.
Performance Management
Collect instance and database statistics using STATSPACK, USTAT/UTLESTAT, and
OEM Packs.
Analyze statistics and modify parameters to enhance performance.
Configure Resource Manager and use it to manage queries.
Create and manage objects to accommodate different data access methods.
Analyze and tune query performance.
Use events to collect performance information.
Standby Databases and Data Guard
Create and utilize a standby database.
Add data to the primary database in preparation for transfer to a standby
database.
Setup the standby database to use the log writer process to transfer the log
stream to the standby database.
Configure the network environment to allow communication between the standby
database and the primary database.
Open the standby database in a "Read-Only" state.
HTH. Additions and corrections welcome.
Pete
SELECT standard_disclaimer, witty_remark FROM company_requirements;
Richard Foote
Come on, don't keep us in suspense, did you get the 35% required to pass ;)
Actually this does all sound a bit more like it. Couple of issues I have
though are:
You *must* attend 2 Oracle advanced courses before being able to sit the
test. This is a nonsense. If you can pass the practical exam, you pass the
practical exam.
The costs. I've no idea what they are but knowing Oracle, it won't be
pretty. Add two advanced courses and the costs alone are a big turnoff.
General acceptance and worth. Will having this certification mean I can get
more work. Will organisations demand such qualifications or will experience,
reputation and a good resume work everytime. Unless there's a general
requirement for such qualifications from employers, then the return on (the
significant) investment is just not there.
It's definitely a step in the right direction, but unless the above issues
are resolved (or someone pays for me as in the past) then I'd rather spend
the money on a month holiday around the world with my family.
Cheers
Richard
"Pete Sharman" <peter....@oracle.com> wrote in message
news:ak138...@drn.newsguy.com...
Pete Sharman
>
>Hi Pete,
>
>Come on, don't keep us in suspense, did you get the 35% required to pass ;)
Wasn't told what the pass mark was, but yes I passed somehow. A cheap dig that
gets me back for one of the cheap digs I had at you in the past. :)
>
>Actually this does all sound a bit more like it. Couple of issues I have
>though are:
>
>You *must* attend 2 Oracle advanced courses before being able to sit the
>test. This is a nonsense. If you can pass the practical exam, you pass the
>practical exam.
>
Not sure what the reasoning here, so I can't really comment other than the
material in those advanced courses will certainly help you to pass the exam.
>The costs. I've no idea what they are but knowing Oracle, it won't be
>pretty. Add two advanced courses and the costs alone are a big turnoff.
Likewise, no idea what the cost is. It was free for me!
>
>General acceptance and worth. Will having this certification mean I can get
>more work. Will organisations demand such qualifications or will experience,
>reputation and a good resume work everytime. Unless there's a general
>requirement for such qualifications from employers, then the return on (the
>significant) investment is just not there.
I think it will mean just that when more people have attended it. It sounds
pretty much like what I've heard of one of the Cisco exams (CCNE?). All you
need to know is that someone has that and they're a shoo-in to get a job.
That's why I was so pleased with the exam, even though I felt like you know what
afterwards. Jim and the guys that developed it have done an excellent job (FYI,
Jim also wrote the 7.3 B&R Workshop, which is still to my mind the best course
I've ever had the pleasure to teach).
>
>It's definitely a step in the right direction, but unless the above issues
>are resolved (or someone pays for me as in the past) then I'd rather spend
>the money on a month holiday around the world with my family.
I know Deb can run your house on a shoestring, and probably has to now you're a
consultant. ;) But if you can survive on a month holiday with the family on the
costs of this, you must be able to live on love (and David Bowie records)!
Pete
Richard Foote
I still owe you (now let me see in my black book, ah yes) about 239 cheap
digs, 78 expensive digs and $20 bucks (which I'm willing to forget ;)
Don't you feel that being able to pass the practical exams should be
sufficient to obtain OCM. Why *must* you attend training on something that
passing the practical exam would suggest you already know.
Cheers
Richard
"Pete Sharman" <peter....@oracle.com> wrote in message
news:ak1jt...@drn.newsguy.com...
Pete Sharman
>
>Hi Pete,
>
>I still owe you (now let me see in my black book, ah yes) about 239 cheap
>digs, 78 expensive digs and $20 bucks (which I'm willing to forget ;)
I've not forgotten that $20!
>
>Don't you feel that being able to pass the practical exams should be
>sufficient to obtain OCM. Why *must* you attend training on something that
>passing the practical exam would suggest you already know.
Pass, as I said I have no idea what the reasoning here is, but as an Oracle
shareholder anything that increases Oracle profits must be right! :)
Richard Foote
Hey, wait a minute, I'm an Oracle shareholder (crikey. $10.76) !!
Folks out there in real world land, forget everything I've said and go out
and buy yourself Oracle certification, it's sure to be a bargain no matter
the cost.
In Australia, the cost of attending a 5 day advanced course is a touch over
$4,000. Multiply that by 2 and that's $8,000 in training (assuming two, 5
day courses). Add a couple of grand for the practical exam and we're close
to $10,000 Australian. With a few frequent flyer points and some friendly
relatives in the UK, Spain and the US and a good overseas holiday could
indeed be enjoyed by the family for this kind of money.
OCM had better be worth it ...
Cheers
Richard
"Pete Sharman" <peter....@oracle.com> wrote in message
news:ak1o4...@drn.newsguy.com...
Connor McDonald
Anyone that successfully completes the
"Use OEM..."
component deserves to pass...
:-)
--
==============================
Connor McDonald
"Some days you're the pigeon, some days you're the statue..."
Niall Litchfield
news:3D651B...@yahoo.com...
> > Oracle Enterprise Manager
> >
> > Install and configure Oracle Enterprise Manager.
> > Install and configure the OEM Tuning Pack.
> > Install and configure the OEM Diagnostics Pack.
> > Use OEM to modify a database configuration.
> "Use OEM..."
>
> component deserves to pass...
>
Hey it only says use OEM to modify *a* database configuration - nothing
about modifying the database you *intended* to work on in the way you
documented.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Pete Sharman
>
>Pete Sharman wrote:
>>
almighty big snip
>Anyone that successfully completes the
>
>"Use OEM..."
>
>component deserves to pass...
>
>:-)
>--
>==============================
>Connor McDonald
>
>http://www.oracledba.co.uk
>
>"Some days you're the pigeon, some days you're the statue..."
Oh, cynical, cynical!
I'm actually finding OEM a lot better than it has been in the past (first
release I used was 0.99 i.e. before it got out to you guys!) It was actually
quite useful to have a tool where you didn't need to remember every detail of
the syntax, too.
Gene Hubert
for both or do you have a choice? Would someone very good on Unix
have a problem with not knowing NT or vice-versa?
Gene Hubert
Durham, NC
Pete Sharman <peter....@oracle.com> wrote in message news:<ak138...@drn.newsguy.com>...
> Sometime ago, I mentioned that I would be attending the pilot of the Oracle
> Certified Masters practicum exam, and would provide you folks with some feedback
> on it. This was in relation to a discussion about the Oracle Certified
> Professional program being too easy to pass without hands-on knowledge of the
> database.
>
> Well, rest assured you will NEVER get through the OCM exam without handson
> experience. I've been using Oracle database technology for 16 odd years now,
> and I finished each day of the two day exam feeling like a wrung out dish rag.
> It's a very tough exam to get through, and as such certainly answers every piece
> of negative feedback I've seen on the OCP program. You can rest assured that
> anyone who gets through the OCM will really know their stuff with the Oracle
> database.
>
...
Pete Sharman
gwhu...@hotmail.com says...
>
>I'm curious about Unix/NT issues. Do you have to be able to do things
>for both or do you have a choice? Would someone very good on Unix
>have a problem with not knowing NT or vice-versa?
>
>Gene Hubert
>Durham, NC
Have a look at the URL I included before. At this stage (not sure if there are
plans to change this) the exam runs on RedHat AS 2.1. You need a familiarity
with basic Unix commands like vi, cp etc., but that's about it.
Pete
>
>Pete Sharman <peter....@oracle.com> wrote in message
>news:<ak138...@drn.newsguy.com>...
>> Sometime ago, I mentioned that I would be attending the pilot of the Oracle
>>Certified Masters practicum exam, and would provide you folks with some feedback
>> on it. This was in relation to a discussion about the Oracle Certified
>> Professional program being too easy to pass without hands-on knowledge of the
>> database.
>>
>> Well, rest assured you will NEVER get through the OCM exam without handson
>> experience. I've been using Oracle database technology for 16 odd years now,
>>and I finished each day of the two day exam feeling like a wrung out dish rag.
>>It's a very tough exam to get through, and as such certainly answers every piece
>> of negative feedback I've seen on the OCP program. You can rest assured that
>> anyone who gets through the OCM will really know their stuff with the Oracle
>> database.
>>
>...
HTH. Additions and corrections welcome.
Ricky Sanchez
Congratulations. I happen to know that not everyone in the pilot passed.
Good for you.
- ricky