Skip to main content

Search

Welcome to Tibero GTS!

Maximum Data File Size Calculation Based on maxdatafiles and Block Size When Creating a Database

Document Type | Technical Information

Category | Installation

Applicable Product Versions | 6FS07PS, 7FS02PS

Document Number | TINTI004

 

Overview

When creating a Tibero database, the MAXDATAFILES value and block size settings affect the number and size of data files, so it is necessary to check these.
 
 
 

Method

File Number Limit According to MAXDATAFILES Setting

  • You can create as many data files as the MAXDATAFILES number specified during CREATE DATABASE.
  • If you want to create more data files than the MAXDATAFILES count, you need to recreate the control file.
  • If MAXDATAFILES is not specified, the default is 100, with a minimum of 10 and a maximum of 65,533.
ItemDescription
Default Value100
Minimum Value10
Maximum Value65,533
Reset Method
The MAXDATAFILES parameter can be adjusted when recreating the control file.
 

Maximum Data File Size Calculation Based on Block Size

  • Tibero stores data in units of blocks.
  • The maximum number of blocks a single data file can have is 2^22-1=4,194,303.
  • Using the maximum number of blocks, you can calculate the maximum size of a single data file.
 Block Size
 Calculation
Maximum Data File Size
8KB
 8KB ร— 4,194,303
 32GB
16KB
 16KB ร— 4,194,303
 64GB
32KB
 32KB ร— 4,194,303
 128GB
Note
  • When the block size is 8KB, the data file can expand up to the maximum size of 32GB.
  • When using the autoextend option, it cannot exceed 32GB, and if more space is needed, a new datafile must be added.
 
 
 

Related to