FAQ
Hi folks

Did anyone use the self-study CD course from Oracle? Is this a valid
course for exam? (Oracle requires official training for
certification). Does the training software run on Mac OS X (or Linux)?
Is this video training recommended (worth the money)?

It's quite expensive (over 1000$) comparing to other training videos
on the market.

cheers Sven

Search Discussions

  • Rich Jesse at Mar 24, 2011 at 1:54 pm
    Hi Sven,
    Did anyone use the self-study CD course from Oracle? Is this a valid
    course for exam? (Oracle requires official training for
    certification). Does the training software run on Mac OS X (or Linux)?
    Is this video training recommended (worth the money)?
    My company had purchased the 10g New Features TBTs (on CD) before I started.
    Since I had worked a little with 10g at my last job, I thought I'd go
    through them to shore up any gaps in my self-taught education on the new
    features of 10g.

    Long story short, I ended up contacting Oracle because the content had major
    flaws. There were vague references and at least one lesson had a "fact"
    that was outright wrong. If I hadn't known that fact already, I would have
    probably accepted the falsehood.

    And the CDs were Win-only. That was for 10g, so the courseware is 6+ years
    old. Perhaps they've improved since then, but I'm not willing to try again.

    GL!

    Rich
  • Guillermo Alan Bort at Mar 24, 2011 at 4:42 pm
    For OCP (I don't think OCA requires it) you need to attend an instructor-led
    course, so no, the CDs will not be enough. Check the certifications page in
    OTN for a list of approved courses for this requirement for each exam.

    hth
    Alan.-
    On Thu, Mar 24, 2011 at 7:33 AM, Sven Aluoor wrote:

    Hi folks

    Did anyone use the self-study CD course from Oracle? Is this a valid
    course for exam? (Oracle requires official training for
    certification). Does the training software run on Mac OS X (or Linux)?
    Is this video training recommended (worth the money)?

    It's quite expensive (over 1000$) comparing to other training videos
    on the market.

    cheers Sven
    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l
  • TESTAJ3_at_nationwide.com at Mar 24, 2011 at 4:45 pm
    yes that is correct, I teach OCA class here for Nationwide Insurance, and
    to get OCA does not require an instructor led course.

    joe

    Joe Testa, Oracle Certified Professional
    Senior Engineering & Administration Lead
    (Work) 614-677-1668
    (Cell) 614-312-6715

    From:
    Guillermo Alan Bort
    To:
    aluoor_at_gmail.com
    Cc:
    oracle-l@freelists.org
    Date:
    03/24/2011 12:43 PM
    Subject:
    Re: reviews of Oracle SELF-STUDY CD COURSE
    Sent by:
    oracle-l-bounce_at_freelists.org

    For OCP (I don't think OCA requires it) you need to attend an
    instructor-led course, so no, the CDs will not be enough. Check the
    certifications page in OTN for a list of approved courses for this
    requirement for each exam.

    hth
    Alan.-

    On Thu, Mar 24, 2011 at 7:33 AM, Sven Aluoor wrote:
    Hi folks

    Did anyone use the self-study CD course from Oracle? Is this a valid
    course for exam? (Oracle requires official training for
    certification). Does the training software run on Mac OS X (or Linux)?
    Is this video training recommended (worth the money)?

    It's quite expensive (over 1000$) comparing to other training videos
    on the market.

    cheers Sven
  • Prabhu Krishnaswamy at Mar 24, 2011 at 4:49 pm
    Lists,


    Our appliction team has requested (as per vendor's recommendations), to pin the frequently used packages (around 6 to 8 packages) on the shared pool. We thought of pinning the packages using the DB Startup trigger, so every time DB recyles, those packages gets included on the memory. Is there any other better way of handling this rather than using the startu trigger. Any advice is highly appreciated.


    Thank you,
    Prabhu
  • Adam Musch at Mar 24, 2011 at 5:01 pm
    Not that I've ever found.

    --
    Adam Musch
    ahmusch_at_gmail.com
    --
    http://www.freelists.org/webpage/oracle-l
  • Powell, Mark at Mar 24, 2011 at 7:03 pm
    We wrote our own database instance startup and shutdown scripts. Our startup scripts pin numerous Oracle and home-grown packages and execute a dummy procedure to load the entire package into memory since back in 7.x days pinning only loaded the package specification into memory.

    This works well for us and easily allows us to start the database without firing the load and pin process when we want to.

    From: oracle-l-bounce_at_freelists.org On Behalf Of Prabhu Krishnaswamy
    Sent: Thursday, March 24, 2011 12:50 PM
    To: oracle-l@freelists.org
    Subject: Pinning Packages on the shared pool

    Lists,

    Our appliction team has requested (as per vendor's recommendations), to pin the frequently used packages (around 6 to 8 packages) on the shared pool. We thought of pinning the packages using the DB Startup trigger, so every time DB recyles, those packages gets included on the memory. Is there any other better way of handling this rather than using the startu trigger. Any advice is highly appreciated.

    Thank you,
    Prabhu
  • Mark W. Farnham at Mar 24, 2011 at 8:04 pm
    +1 to Mark's approach. Avoiding elapsed time and doing anything not required
    for maintenance and (shudder) recovery bounces is a saver of precious time.



    mwf



    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Powell, Mark
    Sent: Thursday, March 24, 2011 3:04 PM
    To: oracle-l@freelists.org
    Subject: RE: Pinning Packages on the shared pool



    We wrote our own database instance startup and shutdown scripts. Our
    startup scripts pin numerous Oracle and home-grown packages and execute a
    dummy procedure to load the entire package into memory since back in 7.x
    days pinning only loaded the package specification into memory.



    This works well for us and easily allows us to start the database without
    firing the load and pin process when we want to.





    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Prabhu Krishnaswamy
    Sent: Thursday, March 24, 2011 12:50 PM
    To: oracle-l@freelists.org
    Subject: Pinning Packages on the shared pool

    Lists,


    Our appliction team has requested (as per vendor's recommendations), to pin
    the frequently used packages (around 6 to 8 packages) on the shared pool. We
    thought of pinning the packages using the DB Startup trigger, so every time
    DB recyles, those packages gets included on the memory. Is there any other
    better way of handling this rather than using the startu trigger. Any advice
    is highly appreciated.


    Thank you,
    Prabhu
  • Joel.Patterson_at_crowley.com at Mar 28, 2011 at 3:07 pm
    Our appliction team has requested (as per vendor's recommendations), to pin the frequently used packages...
    Maybe I'm missing something here, so comments are welcome. If these 6 to 8 are used frequently, then they will never page out from the LRU list no? so in essence will always be in memory, (or at least almost all of the time).

    So.... are we not complicating something that is essentially not needed?

    Joel Patterson
    Database Administrator
    904 727-2546

    From: oracle-l-bounce_at_freelists.org On Behalf Of Prabhu Krishnaswamy
    Sent: Thursday, March 24, 2011 12:50 PM
    To: oracle-l@freelists.org
    Subject: Pinning Packages on the shared pool

    Lists,

    Our appliction team has requested (as per vendor's recommendations), to pin the frequently used packages (around 6 to 8 packages) on the shared pool. We thought of pinning the packages using the DB Startup trigger, so every time DB recyles, those packages gets included on the memory. Is there any other better way of handling this rather than using the startu trigger. Any advice is highly appreciated.

    Thank you,
    Prabhu
  • Fuad Arshad at Mar 28, 2011 at 3:14 pm
    not true . Oracle can still phase out even frequently used packages in favor of
    cursors.
    A startup trigger is the way and actually I use an oracle utility from MOS
    Toolkit for dynamic marking of Library Cache objects as Kept (PIND) [ID
    301171.1] It is a very useful utility to automatically detect objects and mark
    them for pinned prior to shutdown and then pin them after startup.

    ________________________________
    From: "Joel.Patterson_at_crowley.com"
    To: prabhu_adam_at_hotmail.com; oracle-l_at_freelists.org
    Sent: Mon, March 28, 2011 10:07:56 AM
    Subject: RE: Pinning Packages on the shared pool
    Our appliction team has requested (as per vendor's recommendations), to pin
    the frequently used packages…
    Maybe I’m missing something here, so comments are welcome. If these 6 to 8
    are used frequently, then they will never page out from the LRU list no? so in
    essence will always be in memory, (or at least almost all of the time).

    So…. are we not complicating something that is essentially not needed?

    Joel Patterson
    Database Administrator
    904 727-2546

    ________________________________

    From:oracle-l-bounce_at_freelists.org On
    Behalf Of Prabhu Krishnaswamy
    Sent: Thursday, March 24, 2011 12:50 PM
    To: oracle-l_at_freelists.org
    Subject: Pinning Packages on the shared pool

    Lists,

    Our appliction team has requested (as per vendor's recommendations), to pin the
    frequently used packages (around 6 to 8 packages) on the shared pool. We thought
    of pinning the packages using the DB Startup trigger, so every time DB recyles,
    those packages gets included on the memory. Is there any other better way of
    handling this rather than using the startu trigger. Any advice is highly
    appreciated.

    Thank you,
    Prabhu
  • Joel.Patterson_at_crowley.com at Mar 28, 2011 at 5:34 pm
    Thank you,

    But is that likely? Its analogous to saying they can still phase out even so most of the time they are at the most recently used side of the LRU list.

    Joel Patterson
    Database Administrator
    904 727-2546

    From: Fuad Arshad
    Sent: Monday, March 28, 2011 11:14 AM
    To: Patterson, Joel; prabhu_adam_at_hotmail.com; oracle-l@freelists.org
    Subject: Re: Pinning Packages on the shared pool

    not true . Oracle can still phase out even frequently used packages in favor of cursors.
    A startup trigger is the way and actually I use an oracle utility from MOS
    Toolkit for dynamic marking of Library Cache objects as Kept (PIND) [ID 301171.1]

    It is a very useful utility to automatically detect objects and mark them for pinned prior to shutdown and then pin them after startup.

    From: "Joel.Patterson_at_crowley.com"
    To: prabhu_adam_at_hotmail.com; oracle-l@freelists.org
    Sent: Mon, March 28, 2011 10:07:56 AM
    Subject: RE: Pinning Packages on the shared pool
    Our appliction team has requested (as per vendor's recommendations), to pin the frequently used packages...
    Maybe I'm missing something here, so comments are welcome. If these 6 to 8 are used frequently, then they will never page out from the LRU list no? so in essence will always be in memory, (or at least almost all of the time).

    So.... are we not complicating something that is essentially not needed?

    Joel Patterson
    Database Administrator
    904 727-2546

    From: oracle-l-bounce_at_freelists.org On Behalf Of Prabhu Krishnaswamy
    Sent: Thursday, March 24, 2011 12:50 PM
    To: oracle-l@freelists.org
    Subject: Pinning Packages on the shared pool

    Lists,

    Our appliction team has requested (as per vendor's recommendations), to pin the frequently used packages (around 6 to 8 packages) on the shared pool. We thought of pinning the packages using the DB Startup trigger, so every time DB recyles, those packages gets included on the memory. Is there any other better way of handling this rather than using the startu trigger. Any advice is highly appreciated.

    Thank you,
    Prabhu
  • Fuad Arshad at Mar 28, 2011 at 5:48 pm
    on very busy systems, ERP type systems or systems where there is less memory
    available . I have seen that happen where objects coming in are greating that
    available chunks this causing a full flush before bringing these objects back
    in.
    Not all databases fit in these circumtances and with memory being cheap people
    can have enough to the point where memory flushes from LRU dont happen . but
    there will always be cases and pinning objects help you ensure that the more
    critical objects are not the ones that are impacted.

    ________________________________
    From: "Joel.Patterson_at_crowley.com"
    To: fuadar_at_yahoo.com; prabhu_adam_at_hotmail.com; oracle-l_at_freelists.org
    Sent: Mon, March 28, 2011 12:34:08 PM
    Subject: RE: Pinning Packages on the shared pool

    Thank you,

    But is that likely? Its analogous to saying they can still phase out even so
    most of the time they are at the most recently used side of the LRU list.

    Joel Patterson
    Database Administrator
    904 727-2546

    ________________________________

    From:Fuad Arshad [mailto: fuadar@yahoo.com ]
    Sent: Monday, March 28, 2011 11:14 AM
    To: Patterson, Joel; prabhu_adam_at_hotmail.com; oracle-l_at_freelists.org
    Subject: Re: Pinning Packages on the shared pool

    not true . Oracle can still phase out even frequently used packages in favor of
    cursors.
    A startup trigger is the way and actually I use an oracle utility from MOS
    Toolkit for dynamic marking of Library Cache objects as Kept (PIND) [ID
    301171.1]

    It is a very useful utility to automatically detect objects and mark them for
    pinned prior to shutdown and then pin them after startup.

    ________________________________

    From:"Joel.Patterson_at_crowley.com"
    To: prabhu_adam_at_hotmail.com; oracle-l_at_freelists.org
    Sent: Mon, March 28, 2011 10:07:56 AM
    Subject: RE: Pinning Packages on the shared pool
    Our appliction team has requested (as per vendor's recommendations), to pin
    the frequently used packages…
    Maybe I’m missing something here, so comments are welcome. If these 6 to 8
    are used frequently, then they will never page out from the LRU list no? so in
    essence will always be in memory, (or at least almost all of the time).

    So…. are we not complicating something that is essentially not needed?

    Joel Patterson
    Database Administrator
    904 727-2546

    ________________________________

    From:oracle-l-bounce_at_freelists.org On
    Behalf Of Prabhu Krishnaswamy
    Sent: Thursday, March 24, 2011 12:50 PM
    To: oracle-l_at_freelists.org
    Subject: Pinning Packages on the shared pool

    Lists,

    Our appliction team has requested (as per vendor's recommendations), to pin the
    frequently used packages (around 6 to 8 packages) on the shared pool. We thought
    of pinning the packages using the DB Startup trigger, so every time DB recyles,
    those packages gets included on the memory. Is there any other better way of
    handling this rather than using the startu trigger. Any advice is highly
    appreciated.

    Thank you,
    Prabhu

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 24, '11 at 10:33a
activeMar 28, '11 at 5:48p
posts12
users10
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase