Re: Question on bigfiles
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 26 Oct 2009 17:10:55 +0000
Message-ID: <7765c8970910261010g2db441b0t7322831d78c3838d_at_mail.gmail.com>
On Mon, Oct 26, 2009 at 3:50 PM, Surachart Opun <surachart_at_gmail.com> wrote:
Date: Mon, 26 Oct 2009 17:10:55 +0000
Message-ID: <7765c8970910261010g2db441b0t7322831d78c3838d_at_mail.gmail.com>
On Mon, Oct 26, 2009 at 3:50 PM, Surachart Opun <surachart_at_gmail.com> wrote:
>
> If you use big tablespace with ASM, that perfect with VLDB...
>
Right up until you reach 2tb in size at which point all your data is gone :) . Note *6453944.8 *refers. At least with smallfiles you can spread your tablespace out amongst multiple luns. For all the old timers, now we know. 1.7gb is the new 640k, 2tb is the new 2gb...
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 26 2009 - 12:10:55 CDT