Re: Tablespace with more than one file

From: Amir Gheibi <gheibia_at_gmail.com>
Date: Mon, 12 Oct 2009 16:48:27 +0800
Message-ID: <c906cd460910120148s299d84a9m533a2ae7579caffe_at_mail.gmail.com>



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
> /opt/oracle/oradata/GUNNAR/testje.dbf
> SQL>
>
> 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
>
> regards,
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> e-mail: freek.dhooge_at_uptime.be
> tel. +32 (0)3 451 23 82
> http://www.uptime.be
>
>
> 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
> ~Gidhin
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 12 2009 - 03:48:27 CDT

Original text of this message