|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
November 23rd, 2004, 12:49 AM
|
|||
|
|||
|
Setting up tablespace for BIG tables
Hi all, I'm a bit of an oracle newbie and am after some info on how best to setup our database.
In particular we have 1 table that's going to end up very very big. It'll start at around 10 million rows and probably get bigger pretty quickly. Should I put it in it's own tablespace? What sort of extents should I use? Any information gratefully received.
__________________
Like the answers I give? Why not ask me directly at my forum. I'm always glad to help. Javascript scripts and tips can be found at Dynamic Tools. Check out DynamicTable, the best javascript table sorter around. Get reliable and affordable hosting at www.thinksmarthosting.com
|
|
#2
November 23rd, 2004, 03:07 AM
|
||||
|
||||
|
You can even partition the table and place chunks of data in different tablespaces. This will benefit query time in many ways, one of them is partition pruning (the optimizer discards partitions that do not contain data useful for the query).
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
November 23rd, 2004, 05:43 PM
|
|||
|
|||
|
I know I'm asking a lot of questions here but the performance of this table will be critical to the performance of the application as a whole.
Are you saying I should put it in it's own tablespace? Does partition pruning only work if the partitions are in seperate table spaces? How big should I make the tablespace? How large should I make the next extents value for the tablespace? Thanks again, Pete
|
|
#4
November 24th, 2004, 03:08 AM
|
||||||
|
||||||
|
Quote:
I'm adding that you can spread a table on different tablespaces, this is related to your phisical disk configuration ... Quote:
No Quote:
Depending on the table structure you can compute row size and then partition size (example: the size of a month of data, if time is a meaningful partition parameter) Quote:
The answer above should help you in extimating the next extent's size Hope this helps
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Setting up tablespace for BIG tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
