Partitioning advantages
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Partitioning advantages

  1. #1
    Join Date
    Jun 2005
    Location
    India
    Posts
    14

    Lightbulb Partitioning advantages

    Hi guys,

    I am looking into the pros and cons of the partitioning in oracle 9i.I have some but it does not encourages me to go for the partitioning.Please explain me the advantages of partitioning from performance point of view or give me the link of web page where I can read the advantages of partitioning which can drastically improve the performance of my database.I am working on OLTP database where some tables have million of rows.

    thanks in advance.
    Rupesh Gopani

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    The fist response from Tom Kyte is quite good:

    http://asktom.oracle.com/pls/ask/f?p...:1434404232212

    In my opinion, the main advantages are from an administrative perspective in the majority of cases. Sure partition pruning can increase performance, but for a few million rows I wouldn't bother. It's meant for truely massive tables, or those where maintenance can be performed at a partition level, like dropping a partition to remove old data etc.

    Think of this as your mantra:

    "Bad partitioning is worse than no partitioning at all"

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    Mar 2002
    Posts
    534
    Totaly agree with:

    Quote Originally Posted by TimHall
    "Bad partitioning is worse than no partitioning at all"
    Be carefull with partitioning. Before using it on your productive system you should check if it is really imporves anything. Are full table scans (fts) realy a big performance issue on your application? how often does fts occure? Will the SQLs doing the fts be much faster if they access only to one partition instead to the entire table?

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You might think of it like this: "What problem am I trying to solve by using partitioning?"

    If you can clearly identify one or more problems, consider, "What are the costs in implementing it ($'s and time etc), and what are the disadvantages? What other means could I use to solve the problem(s), and how do their other benefits and costs compare to partitioning?"
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    I thought you were on holiday?

    I guess the plane hasn't left yet
    Last edited by TimHall; 06-27-2005 at 11:31 AM.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Alas, it is over.

    My back to school essay on "What I Did On My Holidays" is here . My holiday snaps are here

    And I just remembered that I forgot to reply to your email ... sorry .. just a minute.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    I'm going mad. I could have sworn I read a "Slave to the wage" post this morning that said you were off again. Did I pick up an old post by accident?

    Too many forums and blogs. We need a forum/blog ERP. Get the cross reference...

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  8. #8
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Old post. I was the start of the recent holiday, not a new one
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  9. #9
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Quote Originally Posted by TimHall
    Old post. I was the start of the recent holiday, not a new one
    Not that I couldn't manage one right now. It's been a heck of a week
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width