Home » RDBMS Server » Performance Tuning » Number of table partitions (Oracle 9.2)
Number of table partitions [message #320567] Thu, 15 May 2008 08:44 Go to next message
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
Member
Are there any general guidelines on number of Hash Partitions that should be created for a table having 10/100 million records.
Re: Number of table partitions [message #320569 is a reply to message #320567] Thu, 15 May 2008 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No partition I think, 10 million is small, 100 million is medium.
Now it depends on your number of concurrent transactions on this table and number of disks on which you can spread the partitions.

Regards
Michel
Re: Number of table partitions [message #320578 is a reply to message #320569] Thu, 15 May 2008 09:54 Go to previous messageGo to next message
chintu00
Messages: 91
Registered: February 2007
Location: NJ, US
Member
I have a table that is currently over 100 million records and we are purging data from the table but may end up with 100 million records in the table. what should influence my decision on the number of partition. What you have said below I find very open-ended, I can't make outmuch from it.
Re: Number of table partitions [message #320586 is a reply to message #320578] Thu, 15 May 2008 10:23 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Now it depends on your number of concurrent transactions on this table and number of disks on which you can spread the partitions.

Regards
Michel
Previous Topic: challenge to Sr.DBA
Next Topic: High enq: TX - row lock contention
Goto Forum:
  


Current Time: Mon Dec 05 20:58:24 CST 2016

Total time taken to generate the page: 0.19004 seconds