RE: How much does it cost to run Enterprise Oracle on Linux?

I've got 11GB tables that aren't partitioned and I have no problems.
Where did you see the 2GB recommendation?  I thought I saw a
recommendation for 4GB before (in the S.A.M.E document maybe?), but I
don't remember seeing 2GB.  I would suggest that it doesn't matter so
much how big the table is as how it is used.  If you perform queries
that could benefit from partition scans vs. full table scans, or if you
need the ability to add and drop large amounts of data, e.g. quarterly
sales data in a warehouse or something like that - those are where I
would look at partitioning.  Parallelism works just fine on a regular
table - no need for partitioning to support parallelism.  Oracle will
logically partition it among the parallel processes automatically.


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of laura pena
        
        Our largest table holds 11 millions rows. If we expect to grow
that is great, but Oracle reccomends to start partition a table when the
table reaches 2g or more in size.
        
        Is that what everyone else has as a rule of thumb.


Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

Other related posts: