I require to add additional datafiles to a SmallFile tablespace. The process took several minutes on my system for 1 datafile.

Is it possible to allow Oracle the same capability as SQL Server using instant file initialisation? my googling was unproductive.




No, Oracle does not take advantage of that security policy and always zeroes out the files before writing to them.

I have no idea whether ASM behaves in a different way, but in the filesystem files are always initialized.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.