File creation time

From: Tim V. <vannaman_at_nOSpAMswbell.net>
Date: Tue, 06 Jan 2004 05:13:38 GMT
Message-ID: <Xns9467EC4568106vannatNOSPAMusibmcom@151.164.30.94>

Back in the days of Oracle7, there was an IO_BLOCK_SIZE (or similar) parameter you could set that would greatly decrease the time it took to create large tablespace files.

They renamed it for Oracle8, but I forget what it was. Perhaps something with a CC in it. Is there one for Oracle 9? I've taken a peek in the v$parameter table and can't find anything there that would indicate it.

The parameter just changes the blocksize writes only during tablespace creation.

Any clues?

Thanks,

-- 
Tim.

"Those who give up essential liberties for temporary safety deserve neither 
liberty nor safety." - Benjamin Franklin

Received on Mon Jan 05 2004 - 23:13:38 CST