RE: "Headroom" in datafiles?

From: <Joel.Patterson_at_crowley.com>
Date: Wed, 16 Sep 2009 14:23:38 -0400
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA035362E9_at_JAXMSG01.crowley.com>

I like the idea of ASM instances, but have not implemented one yet. As for file systems, ours don't grow extra ordinarily fast, so I just set autoextend on umlimited growth. And have a job in enterprise manager that polls all the databases on all servers once/day and emails if there is a tablespace where all the datafiles are greater than 30Gbs (8K block). Then I add another datafile.  

SysAdmin monitors and grants space on the box (san). So my datafiles are always basically full, (autoextending), so I just monitor there size as described. Works for me, and is very simple.  

Joel Patterson
Database Administrator
904 727-2546

---

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 - 13:23:38 CDT