Re: 2 GB myth

"zeb" <spam_at_nowhere.com> wrote in message news:<419f0b8e$0$5181$636a15ce_at_news.free.fr>...
> Hi,
>
> Can I use safely datafile larger than 2 GB ?

With your os/oracle versions - yes, you can.

> I know it is a file system limitation not oracle limitation,
> now on recent filesystem there is no such limitation.
>
> Is this a "psychologic" limitation ?

A legacy from 32-bit days.

> Is there any known bugs ?

As far as I remember there were some a long time ago, e.g. not all os utilities were 64-bit ready etc. It's all in a past now.

> perfomance pb ?

Possibly. AFAIK I/O operations for files in ufs can't run in parallel. If you have a large active tablespace you may want to create more smaller datafiles to run more I/O's in parallel.

> management ?

Not really. A number of datafiles doesn't have much impact on your workload. Also smaller datafiles usually don't mean much faster datafile recovery. True, you may get it restored on a disk a bit faster. The difference would be small though - current tape drives restore at 1G+/min. After that you still need to go through all redo logs and it's the same for any datafile size.  

> Can I go safely with this ??
>
> oracle 8i, 9i
> HP-UX 11.0

I can't remember any large files related problems for these versions.

Cheers,
Igor Received on Mon Nov 22 2004 - 19:22:41 CST