Re: Oracle9i data file size limitations on HPUX 11.11
- From: Jared Still <jkstill@xxxxxxxxx>
- To: MGogala@xxxxxxxxxxxxxxxxxxxx
- Date: Thu, 9 Dec 2004 15:42:38 -0800
How long does it take to restore a a 128 TB file?
a) 42 minutes
b) 42 hours
c) 42 days
d) 42 months
e) 42 years
f ) 42 lifetimes
g) all of the above
Jared
On Wed, 8 Dec 2004 09:45:59 -0500, Gogala, Mladen
<MGogala@xxxxxxxxxxxxxxxxxxxx> wrote:
> Of course, you can have bigfile tablespace, containing a single moderatly
> large file, containing up to 4G blocks, up to 32kb long. This makes the
> largest supported file size equal to 128 TB. There is, however, a catch:
> you will have to upgrade to 10G to do that. Bigfile tablespaces are not
> supported in 9.2. If you do upgrade and use bigfile tablespaces, be aware
> that there are significant limitations with ROWID columns. Contrary to the
> popular belief, size does matter.
> --
> Mladen Gogala
> Ext. 121
>
>
>
> -----Original Message-----
> From: Loughmiller, Greg [mailto:greg.loughmiller@xxxxxxxxxxxx]
> Sent: Wednesday, December 08, 2004 9:18 AM
> To: 'oracle-l@xxxxxxxxxxxxx'
> Subject: Oracle9i data file size limitations on HPUX 11.11
>
> Hey guys,
>
> Quick question. We are working on an effort that will have a multiple
> Terabyte database. I am seeing conflicting information about the max size
> of a data file that Oracle will support. I see where a "vendor" indicates a
> 1.9TB data file in their proposal. But what I'm finding in the Oracle Doc is
> approx 127GB (32K block size). And the typical search of the web turns up
> yet a different answer.....
>
> So, I'm making the assumption of "4 million blocks max per data file" * the
> block size to derive the max oracle data file size (I'm not worried about
> the OS limitations at this time).
>
> Am I off track here? Making an incorrect assumption?
>
> Thanks!
>
> Greg Loughmiller
>
> --
> //www.freelists.org/webpage/oracle-l
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
