Re: Oracle EE 12.1 standardize on bigfile tablespaces?

From: Mladen Gogala <>
Date: Tue, 21 Feb 2017 18:25:59 -0500
Message-ID: <>

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?".


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

Received on Wed Feb 22 2017 - 00:25:59 CET

Original text of this message