OraFAQ Forum: Performance Tuning » Number of table partitions

Home » RDBMS Server » Performance Tuning » Number of table partitions (Oracle 9.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Number of table partitions [message #320567]

Thu, 15 May 2008 08:44

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.

Report message to a moderator

Re: Number of table partitions [message #320569 is a reply to message #320567]

Thu, 15 May 2008 08:52

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Number of table partitions [message #320578 is a reply to message #320569]

Thu, 15 May 2008 09:54

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.

Report message to a moderator

Re: Number of table partitions [message #320586 is a reply to message #320578]

Thu, 15 May 2008 10:23

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 01:46:02 CST 2024