Re: Large tablespace in 8.17

On Feb 6, 3:03 am, "xxxx" <timo.ta..._at_luukku.com> 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: http://www.informit.com/articles/article.aspx?p=20684 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.

jg

--
@home.com is bogus.
"Five second fuses only last three seconds" - Infantry Journal