My Oracle Support Banner

EM 13C : Is there a support for Bigfile Tablespaces for OEM Repository Database in 13c (Doc ID 2683029.1)

Last updated on JUNE 22, 2020

Applies to:

Enterprise Manager Base Platform - Version 13.1.0.0.0 to 13.4.0.0.0 [Release 13c]
Information in this document applies to any platform.

Goal

Is there a support for Bigfile Tablespaces for OEM Repository Database in 13c.

What is Bigfile Tablespaces ?

Oracle Database enables the creation of bigfile tablespaces. A bigfile tablespace consists of a single data or temporary file which can be up to 128 TB. The use of bigfile tablespaces can significantly reduce the number of data files for your database. Oracle Database supports parallel RMAN backup and restore on single data files.
Consequently, there is no disadvantage to using bigfile tablespaces and you may choose to use bigfile tablespaces to significantly reduce the number of data and temporary files.

File allocation is a serial process. If you use automatic allocation for your tables and automatically extensible data files, then a large data load can be impacted by the amount of time it takes to extend the file, regardless of whether you use bigfile tablespaces. However, if you preallocate data files and you use multiple data files, then multiple processes are spawned to add data files concurrently. 

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.