One thing of note is that on versions below 11.1, rman will not be able to break a bigfile tablespace into multiple chunks when taking backups using parallelism. Starting with 11.1, rman can break a large file into multiple pieces using the section size parameter. From my experience, I would only create bigfile tablespaces on ASM. It's generally easier to expand ASM diskgroups than individual filesystems. Andy Colvin Principal Consultant Enkitec andy.colvin@xxxxxxxxxxx http://blog.oracle-ninja.com On Jan 9, 2012, at 8:09 PM, G wrote: > Does anyone have opinions/experience/preferences on bigfile tablespaces? I > had someone ask recently, but I have always used smallfile tablespaces. > > Sent from my iPhone-- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l