Partitioning advantages

[rgopani]

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

[TimHall]

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...

[mike9]

Totaly agree with:

"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?

[slimdave]

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?"

[TimHall]

I thought you were on holiday?

I guess the plane hasn't left yet

[slimdave]

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.

[TimHall]

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...

[TimHall]

Old post. I was the start of the recent holiday, not a new one

[slimdave]

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