Re: "Headroom" in datafiles?
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- Date: Mon, 21 Sep 2009 08:46:08 +0300
We keep all our TABLE SPACES at about 20% free and add datafiles as needed.
There are exceptions but this is the rule of thumb.
We do not care about how much a DATA FILE is full.
We also have monitoring on the file systems and ASM groups.
On the average we increase/add one datafile about once a week..
Adar Yechiel
Rechovot, Israel
Taylor, Chris David wrote:
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 <mailto: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.*
Other related posts:
