One table per tablespace?

From: Tom Gillespie <tgillesp_at_ms13.mis.semi.harris.com>
Date: 1996/01/09
Message-ID: <4cu4t6$f00_at_su102w.ess.harris.com>#1/1

I am looking for opinions on dedicated tablespaces and how many files to use for a large table. The table is currently ~ 250Mb, and growing at 500Mb/year. Since it will store a rolling 10 years of data, the final size of this table will be about 5Gb.

To minimize the number of extents, I'm thinking about creating a tablespace dedicated to this table, comprised of three files, each being about 1.7 Gb. Since I can't create a file in UNIX (Solaris 2.4) greater than 2 Gb, I will use three files.

Wadda ya tink ?

--
 Tom Gillespie                                                 -   -
 Harris Semiconductor                                         | | | |
 Manufacturing Systems                                       _/\/\/\/
 Palm Bay, FL                                                 | | | |
 Tom.Gillespie_at_harris.com                                      _   _

 E Pluribus UNIX

Received on Tue Jan 09 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: John D. Fish: "Immediate job for ORACLE-FINANCIAL Project Manager... 75-150K"
Previous message: Herve Muyal: "insert sql commands from a perl script"
Next in thread: Wayne Balmer: "Re: One table per tablespace?"
Reply: Gary Gapinski: "Re: One table per tablespace?"
Reply: Vijaya Kumar Nair: "Re: One table per tablespace?"
Reply: Wayne Balmer: "Re: One table per tablespace?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message