Re: Large tablespace in 8.17

From: joel garry <>
Date: Wed, 6 Feb 2008 13:01:34 -0800 (PST)
Message-ID: <>

On Feb 6, 3:03 am, "xxxx" <> wrote:
> Hi,
> what might be the best way to create a large tablespace in 8.17 db ; -
> should there be several datafiles
>  - first there's a upload made which gives that size approx  ~8 -10 GB
>  - after that every insert adds another ~ 5 MB
> Every hint for some basic values are beeing appreciated !
> Br,
> Ttimo

Be sure and use Locally Managed Tablespaces, and don't use a 2K blocksize (what size depending on what you are really doing). See the administrator's guide in the docs, and explanations on metalink (or google).

The LMT especially helps if you have lots of rows, or deletion of different sized objects will be going on. The mention of FET$ here: refers to Dictionary Managed Tablespaces, LMT's use a bitmap in the file header instead.

~8-10G isn't especially large. But 8.1.7 lacks support, if you are creating something new, this might be a time to upgrade.

Always be sure and post the OS version, too.


-- is bogus.
"Five second fuses only last three seconds" - Infantry Journal
Received on Wed Feb 06 2008 - 15:01:34 CST

Original text of this message