Re: "Headroom" in datafiles?

From: Jason Heinrich <jheinrichdba_at_gmail.com>
Date: Wed, 16 Sep 2009 11:47:33 -0500
Message-ID: <b32e774d0909160947q3733b992v7034e9b8205f9104_at_mail.gmail.com>



Actually, a bigfile tablespace can hold 2^32 blocks. For an 8K blocksize, that works out to 32 TB.
--
Jason Heinrich


On Wed, Sep 16, 2009 at 10:40 AM, Goulet, Richard <
Richard.Goulet_at_parexel.com> wrote:


> Mark,
>
> I have a touch of a problem with that. Assuming your using an 8K
> block size a data file is limited to 32GB and a bigfile tablespace is
> limited to one datafile. What do you do when the tablespace needs to grow
> beyond 32GB?
>
>
> *Dick Goulet***
> Senior Oracle DBA/NA Team Lead
> PAREXEL International
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Bobak, Mark
> *Sent:* Wednesday, September 16, 2009 11:35 AM
> *To:* ChrisDavid.Taylor_at_ingrambarge.com; 'oracle-l_at_freelists.org'
> *Subject:* RE: "Headroom" in datafiles?
>
> Hi Chris,
>
>
>
> Personally, Iím a big advocate of ASM and bigfile tablespaces. I put all
> my storage under ASM control, and when I create a database, I make sure all
> tablespaces are created as bigfile tablespaces. Tablespaces like SYSTEM,
> SYSAUX, TEMP, I usually set a reasonable max size. My application
> tablespaces are unlimited, and then I just monitor the amount of free space
> available in the diskgroup. When space is low, talk to storage admin, he
> gives me another chunk of raw disk, I add it to my diskgroup, and thatís
> it. Each tablespace grows to the size it needs to be, I donít need to
> monitor individual databases/tablespaces, and life is simple.
>
>
>
> -Mark
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Taylor, Chris David
> *Sent:* Wednesday, September 16, 2009 11:27 AM
> *To:* 'oracle-l_at_freelists.org'
> *Subject:* "Headroom" in datafiles?
>
>
>
> I'm curious how much "headroom" people like to maintain in their
> datafiles? We have a large data reorganization procedure underway as part
> of our DR discovery process and I was playing around with some ideas.
>
>
>
> I was thinking, we could allocate a fixed size for each datafile (say 32G
> for example) and not worry about space or autoextend until we reached some
> threshold.
>
> OR
>
> I could fix each datafile to have 10% free space at all times
>
> OR
>
> something similar.
>
>
>
> I think what bothers me is knowing that some of my datafiles are "99%" full
> for example while others are 5% full in the same database.
>
>
>
> Do any of you get bothered by datafiles being a certain % "full"?
>
>
>
> We've got gobs of disk space "right now" so I've been pushing this to the
> back burner for a while for coming up with a cohesive policy on datafiles.
>
>
>
> Thoughts?
>
>
>
> *Chris Taylor*
>
> *Sr. Oracle DBA*
>
> Ingram Barge Company
>
> Nashville, TN 37205
>
> Office: 615-517-3355
>
> Cell: 615-354-4799
>
> Email: chris.taylor_at_ingrambarge.com
>
>
>
> *CONFIDENTIALITY NOTICE**: This e-mail and any attachments are
> confidential and may also be privileged. If you are not the named recipient,
> please notify the sender immediately and delete the contents of this message
> without disclosing the contents to anyone, using them for any purpose, or
> storing or copying the information on any medium.*
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 16 2009 - 11:47:33 CDT

Original text of this message