Thursday, October 9, 2025

Exploring Bigfile Tablespaces with Default Settings in oracle 23ai


BIGFILE Tablespace

A bigfile tablespace is a tablespace with a single, but large datafile. Traditional small file tablespaces, in contrast, typically contain multiple datafiles, but the files cannot be as large. Making SYSUAX, SYSTEM and USER tablespaces bigfile by default will benefit large databases by reducing the number of datafiles, thereby simplifying datafile, tablespace and overall global database management for users.

Fixing a DBCS Startup Failure Caused by ORA-07445

  Introduction: Running Oracle databases on Oracle Database Cloud Service (DBCS) usually provides a stable and well-automated environment, ...