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

It does say tables greater than 2gb should always be considered.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c12parti.htm#459787

This table is is select, inserted and updated too very often.

Many Thanks,
Lizz

"Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx> wrote:     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.


 
---------------------------------
Low, Low, Low Rates! Check out Yahoo! Messenger's cheap  PC-to-Phone call rates.

Other related posts: