Database File Size Limits

Most folks don’t realize that the database file size limits are operating system dependent. Limited by maximum operating system file size typically 222 or 4M blocks.

The block size / datafile size limitations are:

Max datafile size for SMALL FILE NORMAL TABLESPACE would be:

Database Block Size     Maximum Datafile File Size
 2k     4194303 *  2k =   8 GB
 4k     4194303 *  4k =  16 GB
 8k     4194303 *  8k =  32 GB
16k     4194303 * 16k =  64 GB
32k     4194303 * 32k = 128 GB

Max datafile size for BIG FILE TABLESPACE would be:

Database Block Size     Maximum Datafile Size
 2k     4294967295 *  2k =   8 TB
 4k     4294967295 *  4k =  16 TB
 8k     4294967295 *  8k =  32 TB
16k     4294967295 * 16k =  64 TB
32k     4294967295 * 32k = 128 TB 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s