Grow existing DBFs or add more?
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 10 Aug 2007 11:06:33 -0500 (CDT)
Hey all,
In 10.1.0.5, we're seeing unexpected growth in the data segment tablespace
for JDEdwards. So I've been adding extra datafiles to accommodate -- no
biggie. Looking into the future, I'm thinking that I'd like to increase the
maxsize for the datafiles to mitigate checkpointing pressure.
With that in mind, is there any reason y'all can think of why I wouldn't
want to increase the maxsize of the existing datafiles? We're using RMAN
for backup and the physical layout is less-than-desirable sequentially
striped luns on a RAID-5 SAN (before my time and before my SA's time, too),
if that helps.
Nothing concrete comes to mind from net/doc searches nor memory, but
something in the back of my head keeps nagging about the order in which
extents are going to be spread across these datafiles and recovery.
TIA!
Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
