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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Bobak, Mark > *Sent:* Wednesday, September 16, 2009 11:35 AM > *To:* ChrisDavid.Taylor@xxxxxxxxxxxxxxx; 'oracle-l@xxxxxxxxxxxxx' > *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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Taylor, Chris David > *Sent:* Wednesday, September 16, 2009 11:27 AM > *To:* 'oracle-l@xxxxxxxxxxxxx' > *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@xxxxxxxxxxxxxxx > > > > *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.* > > >