In a datawarehouse, unless your ETL processes are very
slow and your loading window is quite small, you
should always favor the reading performance over the
loading performance.
I want to have the maximum rows per block so my
pctfree is always near 0 and pctused high.
You do not delete often in a
Thanks Lisa !
-Original Message-
Sent: Friday, June 29, 2001 10:21 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Hi Vikas,
The docs should have discussed the reason why. High pctused can lead to a
block going on and off the freelist frequently as deletes/inserts are
processed, an
Title: RE: Setting PCTFREE & PCTUSED in a Datawarehouse
Hi Vikas,
The docs should have discussed the reason why. High pctused can lead to a block going on and off the freelist frequently as deletes/inserts are processed, and also can leave the amount of free space inadequate for a