Re: 9.2 32-bit to 10.2 64-bit Migration

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Mon, 17 Jul 2006 13:05:15 GMT
Message-ID: <J2Jtp0.L8C@igsrsparc2.er.usgs.gov>

Sybrand Bakker wrote:
> On 14 Jul 2006 04:16:04 -0700, "Charles Hooper"
> <hooperc2000_at_yahoo.com> wrote:
>

>> * Pre-create the tablespaces to reduce the time that it takes to
>> perform the import, and to reduce fragmentation at the operating system
>> level - if you know that you will need a 25GB data file for a
>> tablespace, create the data file at that size before the import.

>
> As a datafile in many cases is the smallest unit of recovery, anything
> beyond 2 Gb is IMO undesirable, and 25 Gb is just asking for trouble.

I would say that it depends on the size of the database. In the multi-terabyte world, a database composed of 2GB datafiles can quickly become a nightmare. In my VLDB's, I use the largest datafile my blocksize will support.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Mon Jul 17 2006 - 08:05:15 CDT