Home » RDBMS Server » Performance Tuning » criteria for partitioning (Oracle 10gR2)
criteria for partitioning [message #335602] Tue, 22 July 2008 23:07 Go to next message
eaganfox
Messages: 6
Registered: July 2008
Location: Minnesota
Junior Member
Are there any rules of thumb (numbers) to determine when a table in an OLTP environment should be partitioned? This is as part of strategic planning for that table as there are no performance problems at present. Can we say for instance that partitioning should occur when a threhsold is reached with X number of records, or X bytes of data, or X number of inserts/deletes?

[Updated on: Tue, 22 July 2008 23:10]

Report message to a moderator

Re: criteria for partitioning [message #335604 is a reply to message #335602] Tue, 22 July 2008 23:13 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow the Posting Guidelines as stated in URL above


http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/ex_plan.htm#i26093
Re: criteria for partitioning [message #335608 is a reply to message #335602] Tue, 22 July 2008 23:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I answered to this question less than one day before you asked yours.
Please search BEFORE posting:
http://www.orafaq.com/forum/m/335399/102589/#msg_335399

Regards
Michel
Re: criteria for partitioning [message #336291 is a reply to message #335608] Fri, 25 July 2008 09:37 Go to previous messageGo to next message
eaganfox
Messages: 6
Registered: July 2008
Location: Minnesota
Junior Member
Thanks gurus.
Re: criteria for partitioning [message #337744 is a reply to message #336291] Fri, 01 August 2008 00:30 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
eaganfox As you are at stage of planning...

So Try to find out.... is your table is going to do select only or update only or insert only?

If you are going to insert only than partition will not be benefited, but fact is in real life 95% time we need access to the record we stored inserted.

Partition is helpful when you have to do search (select) and also when you have to update... coz for update you have to search record than you have to update...

If Data will frequently change for any particular table in OLTP and table size will grow very fast in future than better to have partition table.



Re: criteria for partitioning [message #337764 is a reply to message #337744] Fri, 01 August 2008 01:24 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you should read the link I posted you will learn something about the reasons of partitioning.

Regards
Michel

[Updated on: Fri, 01 August 2008 01:25]

Report message to a moderator

Previous Topic: Adding INDEX_DESC hint slow down the query
Next Topic: HIGH no of LOCKS exclusive in tables for UPDATE Statement
Goto Forum:
  


Current Time: Thu Dec 08 14:44:58 CST 2016

Total time taken to generate the page: 0.06713 seconds