Re: Big files

From: Frits Hoogland <frits.hoogland_at_gmail.com>
Date: Tue, 10 Jan 2012 22:23:07 +0100
Message-Id: <9D182A60-0B64-4AE6-95FF-94657046C420_at_gmail.com>

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_at_gmail.com
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_at_gmail.com> 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-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 10 2012 - 15:23:07 CST