Home » RDBMS Server » Server Administration » Partition
Partition [message #273235] Tue, 09 October 2007 11:23 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have a table with almost 20K records and expting it to grow over million records because of which I want to partition this table.
Is there a way that I can partition the table online?
Thanks,
GK

Report message to a moderator

Re: Partition [message #273236 is a reply to message #273235] Tue, 09 October 2007 11:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is there a way that I can partition the table online?
That is the only way, because you can't make changes when the database is offline.

I seriously doubt that you'll be able to actually measure (benchmark) any performance difference between a partitioned table & non-partitioned table with so few rows.

Report message to a moderator

Re: Partition [message #273237 is a reply to message #273235] Tue, 09 October 2007 11:29 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
This growth is only for a month which means over the peroid of time it will grows into a big table.
-GK

Report message to a moderator

Re: Partition [message #273238 is a reply to message #273235] Tue, 09 October 2007 11:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>This growth is only for a month which means over the peroid of time it will grows into a big table.
"Big" is a relative term.
I stand by my previous statement.
Have you actually paid for the Partitioning license? It is an extra cost feature for Enterprise Edition.
Whether or not any performance gain can be obtained by partitioning is a function of application design & implementation.

I find it curious that you have NO idea how to actually implement partitioning, but are steadfastly convinced it is the solution to your problem.

Ready, Fire, Aim!

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7002.htm#i2129707

[Updated on: Tue, 09 October 2007 12:18] by Moderator

Report message to a moderator

Re: Partition [message #273240 is a reply to message #273238] Tue, 09 October 2007 12:26 Go to previous message
OracleDisected
Messages: 25
Registered: September 2007
Location: Mexico
Junior Member
Hi,

You'll see real benefits using partition when objects are really massive, logical subsetting appear, when parallelism is feasible and/or tablespace\striping gives you IO advantage.

I mean really massive above 10G-20G or hundreds of millions rows.

My 2 cents, given my experience:
1) Partition when index are so huge (20G+) and heavy transaction/reporting causes a lot of IO

2) Partition when there is a benefit of isolating data subsets (years, country code, etc).

Regards

[Edit MC: url to poster blog removed. We don't care about your blog in this post. If you have an answer on your site, post a link to this answer. If you don't, post your blog url in Marketplace]

[Updated on: Thu, 11 October 2007 12:39] by Moderator

Report message to a moderator

Previous Topic: Blob inquiries on sizes
Next Topic: size of segments
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 19:11:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.