This discussion is archived
3 Replies Latest reply: Sep 30, 2013 4:33 AM by mkeskin RSS

How to use Partition Manager

santi Newbie
Currently Being Moderated



My client wants to use partition manager on 11gR2. I'm unable to find clear instructions How to use it. Please suggest me a link which explains how to use partition manager.



  • 1. Re: How to use Partition Manager
    Justin Cave Oracle ACE
    Currently Being Moderated

    Do you believe that there is an Oracle product called "Partition Manager"?  That's not something I've come across-- do you have a link to any documentation that uses that name.  There are a number of third-party tools called "Partition Manager."  Perhaps your client is referring to one of those products?  If so, you'd need to find out which product the client is referring to and you'd need to visit that vendor's web site for assistance.


    Alternately, perhaps the client is referring to using some Oracle tool and simply using a non-standard name.  Perhaps they want to use the SQL Access Advisor to create partitioning recommendations?  Or using Oracle's ILM tool to manage the lifecycle of partitioned data?  Or something else.



  • 2. Re: How to use Partition Manager
    santi Newbie
    Currently Being Moderated

    Sorry Justin for Typo. I meant to ask about Partition Advisor, new thing introduced in 11g.

  • 3. Re: How to use Partition Manager
    mkeskin Explorer
    Currently Being Moderated


    "Partition Advisor

    Beginning with Oracle Database 11g release 2, the SQL Access Advisor has been enhanced to

    generate partitioning recommendations, in addition to the ones it already provides for indexes,

    materialized views and materialized view logs. Recommendations generated by the SQL Access

    Advisor – either for Partitioning only or holistically - will show the anticipated performance gains

    that will result if they are implemented. The generated script can either be implemented manually

    or submitted onto a queue within Oracle Enterprise Manager. "


    SQL Access Advisor


  • Correct Answers - 10 points
  • Helpful Answers - 5 points