Re: Oracle EE 12.1 standardize on bigfile tablespaces?

On 02/20/2017 08:59 AM, Chris Stephens wrote:
> We are in the process of building a new Exadata system that will host
> a relatively large number of 12.1 EE RAC databases. We are trying to
> keep everything as simple as possible and are currently planning on
> standardizing on bigfile tablespaces for all application data.
>
> Are there any downsides/reasons to not do this?
>
> Thanks,
> chris
>

Yes, there are reasons not to do so. The first and foremost reason is recovery. If you have a 500GB file damaged, you need to restore 500G file and recover it. If you have 32GB file damaged, you need to restore 32GB and recover it. Restoring 32GB is usually a tad faster than restoring 500GB. That can be a world of difference, if CIO is looking over your shoulder and asking "are we done yet?".

Regards

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l