• Arun Kumar

Physical Oracle Database Limits

When you try to add data files or resize existing data files, you cannot go with any number in your mind. Oracle database has limitations which you must consider before you arrive at a conclusion.

Below are the important limitations that you must be aware of. Each limitation has its on corresponding dependencies.

Oracle physical db limitations

Here I will be discussing about Oracle 11g and 12c physical limitations:

DATABASE BLOCK SIZE: min 2KB and max dependent on OS but never exceeds 32K

DATABASE BLOCKS: min in the initial extent of a segment = 2 blocks max per data file are platform dependent = 222 – 1 blocks

DATABASE FILES: max per tablespace = OS dependent, usually 1022 max per database = 65533, sometimes less on different OS

DATABASE FILE SIZE: max size OS dependent. Limited by maximum operating system file size; typically 222 or 4MB blocks. The max size of a single datafile is limited by the database block size. Generally it’s 32TB for 8K block and 128TB for 32K block.


max no of tablespaces per database = 64K.

Number of tablespaces cannot exceed the number of database files because each tablespace must include at least one file.

CONTROLFILES: min 1 controlfile required, recommended to have more than 1 max size = 25000 X (db block size)

REDOLOGFILES: min size = 4MB max size = OS dependent, typically 2 GB max number of logfiles = limited by MAXLOGFILES parameter max number of logfiles per group = unlimited

Recent Posts

See All

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

Automate RMAN Backup using Shell Script

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis