Re: Big usr1xxx.ora Files ??

From: Markus Schwitter (Bitec) <MrMagoo_at_plaza.ch>
Date: Mon, 30 Nov 1998 19:29:01 +0100
Message-ID: <3662e42c.0@news2.ibm.net>

>Likewise, when you export, free space on blocks (pctfree settings) are not
>'exported' -- an export file is dense where as table data might (by design)
have
>holes.

So, what pctfree is a usually used parameter ? 10 ? or more ? Our DB is all-set, there will be no modification in the next year (touch wood)... Is there a tool, wich shows the exactly usage ? ..and an optimization tool to correct this ?

>DO NOT USE OS COMPRESSION ON DATAFILES. Of course they compress very well
right

Okay, I'll clear the flag...:-))

>now (it sounds like they are mostly empty). When mostly empty -- they are

>mostly all zeroed out -- compressing the same character over and over is
very

Yes, it really seemes so

Thanks, anyway, for the info !

Markus Received on Mon Nov 30 1998 - 12:29:01 CST