RE: "Headroom" in datafiles?
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "ChrisDavid.Taylor@xxxxxxxxxxxxxxx" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Sep 2009 11:35:01 -0400
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<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:
