Re: Big files
- From: Frits Hoogland <frits.hoogland@xxxxxxxxx>
- To: eric@xxxxxxxxxxx
- Date: Tue, 10 Jan 2012 22:23:07 +0100
I am also using bigfiles for anything that potentially could grow big, and
*always* on ASM.
It is sheer regret you feel when a big datawarehouse query sorts and you are
manually adding smallfile datafiles.
Frits Hoogland
http://fritshoogland.wordpress.com
mailto: frits.hoogland@xxxxxxxxx
cell: +31-6-53569942
On Jan 10, 2012, at 10:17 PM, Eric Grancher wrote:
> hello,
> We have been using bigfile tablespace for years and have not faced specific
> issues with them.
> I recommend reading Niall's post
> http://orawin.info/blog/2012/01/05/adding-datafiles/
>
> cheers
> Eric
>
> On 10 January 2012 03:09, G <andrew.kerber@xxxxxxxxx> 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
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
