Re: Big files
From: Andy Colvin <acolvin_at_enkitec.com>
Date: Tue, 10 Jan 2012 22:10:55 -0600
Message-Id: <FB46D946-8786-4639-B825-F48B4ECBE8EB_at_enkitec.com>
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.
Date: Tue, 10 Jan 2012 22:10:55 -0600
Message-Id: <FB46D946-8786-4639-B825-F48B4ECBE8EB_at_enkitec.com>
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_at_enkitec.com
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--
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 10 2012 - 22:10:55 CST