Re: LARGE DATABASES-UNIX SUN SOLARIS 2.4

Martin Spott wrote:
>
> Mary McDonald (mmcdonal_at_harris.com) wrote:
>
> : [...] I've heard that for a Sun Solaris2.4 unix
> : server the filesizes may not be any bigger than 2gig's??
>
> Do you really have to write Oracle data into filesystems ? I know an
> installation using Sybase on Solaris 2.4, writing their data into raw
> partitions bigger than 2 GB. I would expect this to be possible with Oracle
> too.
>

Raw partitions are supported, but are not really recommended unless you know what you are doing. They provide slight (10-30%) performance improvement but are much harder to manage, backups etc. They also look like unused partitions on partition maps. Do you really want to go on holiday and some junior sys prog looking for some spare space decides to .... :-)

If you need large tablespaces, then just use multiple files per tablespace. Each file can be 2GB. The filesystem restriction is somewhere about 4TB.

--
David Bellamy.
Deparment of Commerce.  The University of Queensland.   Australia.
Internet:   bellamy_at_commerce.uq.edu.au
Phone:      +61 7 336 56652