Oracle datafile size in Windows 
Author Message
 Oracle datafile size in Windows
Hi,

Oracle 8.1.7 database - size ca. 100 GB
Windows 2000 Advanced Server - NTFS

What is the better solution:
1. few large datafiles
2. numerous relatively small datafiles (max. 2 GB)

In case of the first solution - how do you think- what is the "safe" size of
such large datafile in Windows  ?

TIA
EP



Mon, 21 Feb 2005 04:36:42 GMT
 Oracle datafile size in Windows

Quote:

> Hi,

> Oracle 8.1.7 database - size ca. 100 GB
> Windows 2000 Advanced Server - NTFS

> What is the better solution:
> 1. few large datafiles
> 2. numerous relatively small datafiles (max. 2 GB)

> In case of the first solution - how do you think- what is the "safe" size of
> such large datafile in Windows  ?

> TIA
> EP

How large do you think you can make files under 32 bit Windows?

Daniel Morgan



Mon, 21 Feb 2005 05:57:24 GMT
 Oracle datafile size in Windows

Quote:
> How large do you think you can make files under 32 bit Windows?

> Daniel Morgan

Up to the volume size - at least in NTFS.

http://www.microsoft.com/windowsxp/home/using/productdoc/en/default.a...

Regards
EP



Mon, 21 Feb 2005 06:32:12 GMT
 Oracle datafile size in Windows

There were some major issues with files greater than 4 gig in NT 4.0

I personally would not create a datafile greater than 4 gig on
Windows.

Quote:
>Hi,

>Oracle 8.1.7 database - size ca. 100 GB
>Windows 2000 Advanced Server - NTFS

>What is the better solution:
>1. few large datafiles
>2. numerous relatively small datafiles (max. 2 GB)

>In case of the first solution - how do you think- what is the "safe" size of
>such large datafile in Windows  ?

>TIA
>EP



Mon, 21 Feb 2005 09:59:45 GMT
 Oracle datafile size in Windows
Hi EP,

I personally would recommend option 2 with a 100 GBish database.

This will require 50ish data files which is not particularly excessive. It
will also give you more flexibility with online backup strategies and less
issues with restore and recovery times if such a fateful day were to arrive.

Cheers

Richard

Quote:

> Hi,

> Oracle 8.1.7 database - size ca. 100 GB
> Windows 2000 Advanced Server - NTFS

> What is the better solution:
> 1. few large datafiles
> 2. numerous relatively small datafiles (max. 2 GB)

> In case of the first solution - how do you think- what is the "safe" size
of
> such large datafile in Windows  ?

> TIA
> EP



Mon, 21 Feb 2005 13:03:40 GMT
 Oracle datafile size in Windows
What is the max size of a Oracle data file on windows NT?


Mon, 21 Feb 2005 16:44:54 GMT
 Oracle datafile size in Windows
Ton,

Please read Note 62427.1 on Metalink.

Peter



Quote:
> What is the max size of a Oracle data file on windows NT?



Mon, 21 Feb 2005 19:15:39 GMT
 Oracle datafile size in Windows
See Richard's excellent note suggesting option 2 and justifying it in terms
of B & R. How many disks do you have? If it is one raid 5 array the point is
probably somewhat moot. You will in any case run into a file size limitation
caused not by any NT limitation but by the fact that an oracle datafile can
only have so many blocks.

I'd also suggest that you don't think of the db as 100gb of data but as
comprised of tables of varying sizes. You will want to create a range of
locally managed tablespaces with different uniform sizes. 1 with an extent
size of say 64k for tables of say less than 1m., one with an extent size of
say 1m for tables less than say 100m and so on.

So for two different reasons I'd suggest option 2, backup and recovery and
sensible division of db objects by size.

The final reason for multiple datafiles (to spread IO) depends entirely on
how many disks you have which you don't tell us, but in general small
datafiles spread across multiple disks will give better performance than
large datafiles on single disks.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

Quote:

> Hi,

> Oracle 8.1.7 database - size ca. 100 GB
> Windows 2000 Advanced Server - NTFS

> What is the better solution:
> 1. few large datafiles
> 2. numerous relatively small datafiles (max. 2 GB)

> In case of the first solution - how do you think- what is the "safe" size
of
> such large datafile in Windows  ?

> TIA
> EP



Mon, 21 Feb 2005 19:49:56 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. Oracle Datafile size in Windows NTFS

2. TABLESPACE SIZE/DATAFILE SIZE ORACLE 8 AND NT 4

3. Increasing the size of a datafile in Oracle 8.1.6 on Aix 4.3.3

4. Oracle 8 on AIX: size of datafiles

5. Datafile - Size for Oracle

6. Over sized datafile in SQL7

7. datafile size

8. accurate datafile size info

9. Sizing of Datafiles

10. MSSQL7 datafile size

11. ideal cluster size for SQL Server datafiles (drives)

12. Alter tablespace add datafile file size error


 
Powered by phpBB® Forum Software