Hi,

Can someone clarify me.In present shop another DBA suggest to increase/Add datafiles by adding a block size to it.DB_block_size =8k.

Suppose if i want to add 100MB space to tablespace XX.

for eg:

Alter tablespace XX add datafile '/local/dat00/oradata/SID/xx_2.dbf' size 102408 MB

Why cant we just add like this:

Alter tablespace XX add datafile '/local/dat00/oradata/SID/xx_2.dbf' size 100 MB

Is there any block efficiency usage???

Thanks in advace.