Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Grow existing DBFs or add more?

Grow existing DBFs or add more?

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Fri, 10 Aug 2007 11:06:33 -0500 (CDT)
Message-ID: <18220.12.17.117.251.1186761993.squirrel@12.17.117.251>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 10 2007 - 11:06:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US