jarsh

 Profile Answers by jarsh 

• Oct 14th, 2008

 

The maximum number of datafiles in an Oracle Database is usually 64K files

dbashashi

 Profile Answers by dbashashi 

• Apr 2nd, 2009

 

Look, A single Oracle database can have max of 1022 of datafile in case of small file tablespace, and only one datafile in case of Bfile tablespace.

dbashashi

 Profile Answers by dbashashi 

• Dec 2nd, 2010

 

Further it depends on which version of oracle we are using. Not to forget that the OS also has its limitation in terms of files it can handle concorrently. Oracle cannot go beyond OS file limit if imposed by it.

akharejhansi

 Profile Answers by akharejhansi 

• Dec 3rd, 2010

 

4 million block limitation is there for small file and 4 billion block for bigfile (in oracle 10 g)...you can calculate the datafile size according to your block size.

hkravipati

 Profile Answers by hkravipati Questions by hkravipati

• Jul 11th, 2011

 

The max no.of datafiles supported by oracle is 65536

Krunal Gandhi

• Nov 23rd, 2011

 

You can set it with db_nk_cache_size parameter....it is used for not standard size that is 2,4,16,32

db_cache_size is for the standard file size 8k.

And it is depends on OS version if it is 32 bit it is support upto 16k and if it is 64 bit then upto 32 bit........

anil

• Dec 13th, 2011

 

It is 64k

MUTHUPANDIAN A

• Feb 24th, 2012

 

You can create maximum 65536 datafiles

Sriniv@s

• May 12th, 2012

 

Database having maximum up to 65536 data files. Each table space having 1022 data files.

Nainesh Patel

• Jan 31st, 2016

 

Is this in Windows or Linux?

Raja

• Feb 10th, 2016

 

In 11g 15632

Somesh Menaria

• Feb 22nd, 2016

 

In 11g we can use 1022 datafiles

Mohit tayal

• Mar 20th, 2016

 

Max. database file per database is 65533.
Max. Datafile per tablespace 1022