Re: Setting MAXSIZE for a datafile less than UNLIMITED
- From: "Rich Jesse" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 26 Nov 2013 11:30:14 -0600 (CST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
