RE: OT: RANT ABOUT OCP, Re: Small help

Xing,

Your OCP course may mention the script (depends which course you plan to take), but they will only mention it quickly.

You can look it up in the Oracle administration manuals, or in the O'Reilly Oracle Built-In Packages book.

Basically it generates statistics for the optimizer within a given schema.

The OCP course will give you a basic overview of what Oracle can do and what all its parts are, but it won't give you enough info to administer databases properly. It's a good starting point, though -- you will have been exposed to an overview of what it is all about.

To learn to administer Oracle, you MUST have a test instance to "play" with to try different things. At the same time, try to get exposure to it with people who are doing that work. With a test DB you could look up the procedure, then say "I wonder what it really does" and try it on your own instance, then notice what happens.

To administer Oracle you must have an understanding of how it works, but also you need experience with it because the courses and the manuals don't tell you everything. Some of it is trial and error, getting bruised, etc. etc.

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada

> -----Original Message-----
> From: dgoulet_at_vicr.com
> Sent: Thursday, March 29, 2001 10:01 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:OT: RANT ABOUT OCP, Re: Small help
>
> Lee & Joe,
>
> While I do agree that is possible one should try to figure these
> things out,
> and this really is a simple one, there does come a time when asking for
> help is
> appropriate. In this case Lee's answer is very much so. As far as taking
> an
> OCP course, that does torque my jaws. Over the last two years we must
> have had
> 10 people looking for a job who's only mention of Oracle on their resume
> is that
> they have their OCP certificate. Needless to say, not a one of them has
> been
> invited in for an interview. I'll ask the question that's been bugging me
> for
> some time, Xing, do you think this is some kind of "silver bullet" to
> getting a
> job?
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Joseph S. Testa" <teci_at_oracle-dba.com>
> Date: 3/29/2001 4:05 AM
>
> Lee, i'm with you 200%,
>
>
> oh and for the original addressee(and others) if you can't figure out
> what the heck that simple pl/sql block is doing(or where to figure it
> out), then quit diluting the OCP worthiness, people who study just to
> take the OCP and have no experience just go to further the waste of
> paper that the certificate is printed on. :)
>
>
> joe
>
> lerobe - Lee Robertson wrote:
> >
> > Xing,
> >
> > Have a look at the documentation, specifically, Application Developers
> > Guide, section dealing with "Using Procedures and Packages".
> >
> > No disrespect intended but sometimes, certainly for questions such as
> this,
> > you will learn a heck of a lot more by digging around in the docs, and
> > reading (and working out) the answer for yourself. That is certainly my
> > experience. You will also fell encouraged to delve further and learn
> more
> > about other packages etc. Hope my pointer will help you.
> >
> > To the rest of you - I know it would have been quicker to write down the
> > answer to Xings question, but what will he have learned about the
> general
> > syntax ??
> >
> > Regards
> >
> > Lee
> >
> > -----Original Message-----
> > Sent: 29 March 2001 07:05
> > To: Multiple recipients of list ORACLE-L
> >
> > Hi DBAs and SAs,
> >
> > Can someone tell me what is this ORACLE PL/SQL Script all about,..
> > Ya... I know I have to read alot, my OCP course will start next month.
> >
> > BEGIN
> > dbms_utility.analyze_schema ( '&OWNER', 'ESTIMATE', NULL, 5 ) ;
> > END ;
> > /
> >
> > Thank you
> >
> > Xing
> >
>
>
> --
> Joe Testa http://www.oracle-dba.com
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask :)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.com
>
> 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).