Question about Oracle Partitioning (When to consider it?)

  • From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 17 Dec 2009 14:30:18 -0600

I'm curious if there are any "rules of thumb" about when to consider moving to 
Oracle partitioning.  What warning signs could one look for in a 
non-partitioned server that might indicate a need for Oracle partitioning?

Our largest table is 2.8GB.  I've worked in shops with unpartitioned tables as 
large as 12GB.  (I know some of you work in shops with tables much larger than 
that)

When considering Oracle partitioning, what questions should be asked before 
jumping into it?

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and 
may also be privileged. If you are not the named recipient, please notify the 
sender immediately and delete the contents of this message without disclosing 
the contents to anyone, using them for any purpose, or storing or copying the 
information on any medium.

Other related posts: