How many max datafiles can there be in an Oracle Database.

Mohit tayal

• Mar 20th, 2016

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

Somesh Menaria

• Feb 22nd, 2016

In 11g we can use 1022 datafiles

Answer Question  Select Best Answer

vanithaananth

 Profile Answers by vanithaananth Questions by vanithaananth

• Jun 24th, 2011

Physical structures of oracle database consists of datafiles,controlfiles redologfiles and archivelogfiles...

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• Feb 18th, 2010

Dear,             Oracle Physical Database Structure consist of Datafiles, Controlfile  & Online Redo Log files.    ...

Answer Question  Select Best Answer

syed fahad

• Sep 13th, 2014

Yes we can start the database ( pfile is a txt file and spfile is a binary file in 9i spfile is not used by oracle only pfile is maintain to start the database )

Saddam Mulla

• Mar 3rd, 2014

Yes we can start oracle database without spfile but required pfile
(Spfile is a system file and pfile is a manual crest file)

Answer Question  Select Best Answer

Fabio

• Jun 9th, 2015

On 11gR2 I would set automatic memory management MEMORY_TARGET=XX, then I would look on OEM the behavior of the memory and set the SGA and PGA accordingly the usage.

Camara

• May 7th, 2015

Sga_target and the sga_max_trget?

Answer Question  Select Best Answer

venu

• Sep 1st, 2012

SCN is generated by oracle when a transaction is successfully commited. This is referred to as SystemChangeNumber. We can think of it as a transaction id generated when we make some transaction in an ...

SANTHOSH

• Aug 15th, 2012

SCN no is a number which is generated by the oracle, when we made any changes to the data that statements will be recorded in redo log files and every committed statement will be given this SCN no by oracle.

Answer Question  Select Best Answer

Ashok

• Jul 13th, 2017

Tablespace is a logical storage device, the database stores the data physically in datafiles and logically in tablespaces

NARESH NADHAN

• May 4th, 2016

Simply I say DATABASE is divided into some logical storage units that is called TABLESPACE.This is logical storage.And a TABLESPACE can have 1024 datafiles.

Answer Question  Select Best Answer

Amitkumar S Solanki

• Oct 17th, 2014

SPFile is dynamic file and PFile is static

syed fahad

• Sep 13th, 2014

PFILE is a txt file and SPFILE is a binary(when u freshly create a database first database is read spfile after we open the database it will create pfile with the help of this command : create pfile from spfile)

Answer Question  Select Best Answer

rakesh

• Aug 4th, 2017

Server Process

Rammy

• Jul 13th, 2017

Exactly server process invoke and write data from datafiles to database buffercache..

Answer Question  Select Best Answer