Re: 2 GB myth

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 23 Nov 2004 14:09:31 +1100
Message-ID: <41a2a9e6$0$20863$afc38c87@news.optusnet.com.au>

Igor Laletin wrote:

>
> 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.

Have you used RMAN to backup a database. The number of data files is a heavy determinant of how well it can parallelise the operation. It can make a big difference.

HJR

>>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 - 21:09:31 CST