Re: Tablespace with more than one file
Date: Mon, 12 Oct 2009 16:48:27 +0800
Thanks everyone for the answers. Appreciate it.Freek, I'm planing to set the max size to 1 GB to be easily copied around if needed. So I'm safe there. As for the file system's restriction, it's been set that way intentionally. Thanks again.
On Mon, Oct 12, 2009 at 4:40 PM, D'Hooge Freek <Freek.DHooge_at_uptime.be>wrote:
> ok, hit the send button by accident (maybe we can add this to the major
> blunders list ;) )
> Like I was saying:
> First of all a warning: if your filesystem only allows files of max 2GB,
> then don't make your datafiles exactly 2GB in size.
> Oracle adds one block to the given size:
> SQL> show parameter db_block_size
> NAME TYPE VALUE
> ------------------------------------ -----------
> db_block_size integer 8192
> SQL> create tablespace testje
> 2 extent management local autoallocate
> 3 segment space management auto
> 4 datafile '/opt/oracle/oradata/GUNNAR/testje.dbf' size 25600K
> 5 /
> Tablespace created.
> SQL> !ls -lk /opt/oracle/oradata/GUNNAR/testje.dbf
> -rw-r----- 1 oracle oinstall 25608 Oct 11 10:42
> So, best to make your datafiles something like 2000M or so.
> The datafiles are used in a round robin fashion. Oracle will try to extend
> them more or less equilly (unless one of them has hit its maxsize).
> The HPUX filesystem limitation of 2GB can be eliminated by adding the
> largefiles parameter to your mount options.
> I think this option is available starting with HPUX 10.20
> Freek D'Hooge
> Oracle Database Administrator
> e-mail: freek.dhooge_at_uptime.be
> tel. +32 (0)3 451 23 82
> From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On
> Behalf Of gidhin joy [gidhin_at_gmail.com]
> Sent: 12 October 2009 09:05
> To: gheibia_at_gmail.com
> Cc: Toon Koppelaars; oracle-l-freelists
> Subject: Re: Tablespace with more than one file
> You are right only if the file #1 is fully used.
> Check whether file #1 is auto extendable to a size more than 2G, if so make
> auto extendable off and resize it to maxsize of 2G so that further writes
> will go to file #2.
> alter database datafile '/datavol/oradata/sid/file1.DBF' autoextend off;
> alter database datafile '/datavol/oradata/sid/file1.DBF' resize 2G;
> Best Regards