Re: Setting MAXSIZE for a datafile less than UNLIMITED
Date: Tue, 26 Nov 2013 11:30:14 -0600 (CST)
Message-ID: <99072196fa33bde2c9ec0d617c7cf515.squirrel_at_society.servebeer.com>
Mark writes:
> Not sure what specific issues youčre referring to. If youčre on 11.2.0.3,
> and especially if youčre using ASM, I would recommend BIGFILE tablespaces
> and UNLIMITED maxsize. This way, the tablespaces grow organically, and
> you only need to monitor space at the disgroup level. I do that for the
> main application tablespaces. For tablespaces that developers dump stuff
> into, I set max size, as I do with TEMP and UNDO.
>
> The problems in the past, with backing up really large files, are lifted
> in 11gR2 (maybe in 11gR1 also, I cančt rememberŠ) with the SECTION SIZE
> parameter.
I had considered going that route, but timetables won't allow me to fully vet out BIGFILES before I'll need these DBs done.
"Someday...", he says. :)
Thanks!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 26 2013 - 18:30:14 CET