| Partition [message #273235] |
Tue, 09 October 2007 11:23  |
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
|
|
|
|
|
|
|
|
| Re: Partition [message #273238 is a reply to message #273235] |
Tue, 09 October 2007 11:36  |
 |
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 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
